Best practices for formatting disk drives to support Redgate
dazzerb
Posts: 6
What are the best practice recommendations for formatting drive arrays to support Redgate backups in Windows i.e. looking for disk sector alignment offset, array stripe size and windows default allocation size set?
Do Redgate have recommendations for best performance of do I simply build the arrays optimized for native SQL disk backups?
Do Redgate have recommendations for best performance of do I simply build the arrays optimized for native SQL disk backups?
Comments
We do not have any documentation for recommending how to build and optimize your disk array.
The Microsoft recommendations for optimizing disk arrays for native SQL disk backups will apply for Red Gate SQL Backup files.
I do have the following personal recommendations you may wish to consider:
Ensure that you have sufficient disk storage capacity. Data storage capacity, depends on the number and size of the database backup files you wish to support.
I/O throughput, choose your configuration for the best I/O performance.
Protect against unexpected disk drive failure . Use RAID 1 or RAID 0+1 for good performance and fault tolerance.
Hope that the above answers your enquiry.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com