Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

DR testing in SQL 2000 Expand / Collapse
Posted Monday, October 21, 2013 7:50 PM


Group: General Forum Members
Last Login: Thursday, January 22, 2015 10:10 AM
Points: 14, Visits: 260
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.
Post #1506947
Posted Monday, October 21, 2013 8:35 PM



Group: Administrators
Last Login: Today @ 9:45 AM
Points: 31,689, Visits: 16,173
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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1506949
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse