What are the challenges you face when working across database platforms? Take the survey

Best practices for formatting disk drives to support Redgate

dazzerbdazzerb Posts: 6
edited November 20, 2008 2:46PM in SQL Backup Previous Versions
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?


  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.