Best practices for formatting disk drives to support Redgate

dazzerb

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?

Eddie D

Thank you for your post into the forum.

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