July 21, 2009 at 12:16 pm
Hello Experts
Is there anyway i can backup the Standby (other than cold backup?)
Thanks
July 21, 2009 at 12:43 pm
Did u try something like this:
use master
backup database ...
I have never tried though
July 21, 2009 at 2:31 pm
What kind of standby are we talking about?
July 21, 2009 at 8:49 pm
By default it says the database is in restore mode; I did not try using the backup command and will try shortly.
July 21, 2009 at 8:51 pm
Lynn Pettis (7/21/2009)
What kind of standby are we talking about?
I have a primary with log shipping to the standby every 5 mins. I want to backup the Standby one. Recently i had the standby / shipped log header corruption due to network failure and had to re-create the standby which took 1.5 hrs to do due to the bandwidth. I was just wondering if i can have the local copy of the standby i can then copy the log files alone from primary and then apply them after i restore from the local (backed up copy of the standby).
July 21, 2009 at 9:14 pm
Just a guess based on my knowledge of backups and restores only, haven't worked in a logshipping environment yet, but no I don't think you can do that.
July 22, 2009 at 2:58 am
give a go once and if you cant then check if u can configure log shipping as read-only instead of stand by(no recovery), where you can do backups
July 22, 2009 at 6:33 am
I can confirm you cannot do that.
a) you cannot backup a database in recovery mode
b) even if you could the log restores would fail beacuse they would be missing the marker for the full backup and you would have an incorrect start point for the log restore
---------------------------------------------------------------------
July 22, 2009 at 8:47 am
george sibbald (7/22/2009)
I can confirm you cannot do that.a) you cannot backup a database in recovery mode
b) even if you could the log restores would fail beacuse they would be missing the marker for the full backup and you would have an incorrect start point for the log restore
Another aspect i observed a while ago is that, if i convert a Standby db which is in Recovery mode ==> to Read Only mode , SQLServer does not seem to allow it to be back in Recovery Mode and this seems to be a known issue 🙂
July 22, 2009 at 1:15 pm
You could kind of get around this with a snapshot and then bcp out data/script schema, but I'm not sure that's what you want.
The standby is the backup, just an FYI.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply