Log shipping and replication

20 pts.
Tags:
Data Recovery
Log Shipping
I'm using log shipping for my DR. When I want to test my DR, I need to access my DR database and do my tests (and modify it). My problem is I don't want to stop my log shipping and lose integrity between my prod DB and DR DB. I'm looking for a solution to quickly get a copy of my DR DB to my test whitout stopping my log shipping.
ASKED: March 4, 2009  3:00 PM
UPDATED: March 4, 2009  3:31 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

There is no quick way to fail over a log shipped database to test DR and fail back. Once you make
the database writeable there is no way to begin the log shipping again without resetting up the log shipping.

Something you could try, and I have no idea if it will work would be to stop the SQL Server service in DR. Copy all the database files. Make the database writeable and do the test. Then stop the SQL Service in DR, delete the database files and restore from the copies that you made. When the database restarts it should come back up in recovery.

This may cause the database to come up suspect. I would recommend testing this especially if resetting up your DR database is very costly.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following