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.


23
0
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

Description

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.