October 21, 2013 at 7:50 pm
Hi,
We have a situation where we need to do a DR testing of our existing logshipping solution. We have implemented it using SQL 2000. During the testing we want to bring our DR DB's online but still we will have our Production still to running. I have a taken a full backup of the Prod and kept it ready to revert back once testing is completed.
I would like to know what is the best process to accomplish this.
October 21, 2013 at 8:35 pm
Pause the log shipping jobs that restore. Let new logs continue to be run on the primary and copied over.
Bring the DR database online (with recovery) and test if things are OK.
Once you are done, do a restore of your full backup with norecovery and then start restoring logs. The jobs may or may not pick up at the right sequence, depending on when you made the backup, so you might need some manual restores of logs (with norecovery) to get to the point where the automated jobs pick up.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply