Allow backup of database in standby mode - by JRStern

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 466121 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 6/10/2009 4:56:09 PM
Access Restriction Public


Please allow backup of database in standby mode!

This comes up as a very common requirement in HA/DR planning.  Logs are shipped over a (relatively) small pipe to a DR site, for days or weeks or months.  As part of a (partial) failover plan, we need a full backup of a current version of the database to restore on another server on the DR side - but we cannot take the main DR (secondary) copy out of standby without breaking the log chain.  Yes, we might have to pause the application of logs - or possibly not - in order to take the backup of a large-ish database.  But the alternative is shipping a large backup all the way from production over that small pipe, which can be prohibitive.
Sign in to post a comment.
Posted by Microsoft on 10/23/2012 at 9:45 AM
Thank you for your suggestion, however this is not on our roadmap for any near-term releases.
I am accordingly closing this DCR.
Posted by Isaac McN on 1/18/2011 at 7:07 PM
Great workaround Saggi - thanks!
Posted by Saggi Neumann on 6/30/2010 at 1:07 AM
I think that the same feature should also apply to databases in norecovery mode. Thanks!

S. Neumann
Posted by Microsoft on 6/15/2009 at 10:19 AM
Thank you for your suggestion.
Indeed, this request has been discussed many times, both in the form of backing up a Standby database (in the case of Log Shipping) or of backing up a mirror database in the case of Database Mirroring.

We are working on a feature for a future version of SQL Server which will allow you to accomplish this.