Feature Request - Offline Backup

EdVassieEdVassie Posts: 15
edited November 24, 2008 1:28PM in SQL Backup Previous Versions
A potential key differentiator for SQL Backup compared to the competition would be the ability to take a backup of a database that is not attached to SQL Server.

Consider the following scenario:
1) A database is attached to SQL Server and hosted on a SAN.
2) The SAN disks are being mirrored internally within the SAN.
3) The SAN mirror is suspended, and the suspended copy is mounted on another server that does not need to have SQL Server installed. We now have a frozen copy of the database that is not attached to SQL Server.
4) A backup is made of the frozen copy, and the backup is registered on the SQL Server instance holding the live database.

This has allowed us to make a backup of the database without putting any load on the SQL Server instance, apart from a small transaction to register the backup. This technique could be used for Full, Differential and Log backups. However, for a Full backup the dirty page map used for differentials could not be reset on the live database.

This concept becomes more valuable as database sizes grow, where the impact of taking a database backup on the SQL Server instance can impact user response time for hours. It would also assist implementation of this concept if Red Gate could work with the popular SAN vendors to provide sample automation scripts.

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Thank you for your suggestion.

    I have created a Feature Request on your behalf for the development team to consider adding Offline Backups of a database that is not attached to SQL Server.

    The reference for this feature request is SB-3674.

    I will update you on this feature request when any changes occur. Unfortunately I cannot guarantee the success of the Feature Request submitted. If the request does obtain approval, what future version of SQL Backup the feature will appear in.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.