July 13, 2011 at 2:25 am
hi all,
i have db in stand by for logship use.
i want to back up this db and restore it to anthoer db for testim use.
but it is impossbile to back up db in this state-
ani idea how to do this?
sharon.
July 13, 2011 at 2:39 am
sharon-472085 (7/13/2011)
hi all,i have db in stand by for logship use.
i want to back up this db and restore it to anthoer db for testim use.
but it is impossbile to back up db in this state-
ani idea how to do this?
sharon.
Backup up the primary DB.then restore it
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
July 13, 2011 at 3:31 am
hi,
this is alot of data crossing 2 server that far away from each other
i dont want to do backup and restore all the time....
in log shipping the data is there i just need to find way to back up him......
thanks sharon
July 13, 2011 at 4:44 am
Sharon,
Have you actually tried googling the issue yet? Backing up a standy server has actually been discussed in great detail elsewhere.
Here's the first link I found: http://www.sqlservercentral.com/Forums/Topic550669-357-1.aspx#bm551983
EDIT: Another option is to take it out of standby and then back it up. Then restore the log shipping database and start log shipping again.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply