July 20, 2005 at 1:35 pm
Dear DBAs,
I have tried to backup databases on Standby SQL Server which give me the following errors:
Server: Msg 3036, Level 16, State 1, Line 1
Database 'db_xxx' is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Does any one know how to work around to backup a database on Standby Server?
Thanks
July 21, 2005 at 10:09 am
My question would be, why would you want to do such a thing? Since there should not be any changes in the db since it was restored from the original, I would just use a backup of the original.
Dylan
Dylan Peters
SQL Server DBA
July 21, 2005 at 6:05 pm
In some cases the location of the orginal backup can be a considerable distance away, maybe even in another country. Restoring over the wan is not an option, sending the tape may not be either or has a time delay that is unaccepteble.
So how can I protect from a failure of the Standby server without requiring the orginal database being restored, either via the wan or by shipping me the tape?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply