September 23, 2013 at 3:09 am
Hi,
This is Damodar. My question is on Log Shipping, I have to reverse the log shipping from DR to Production during DR Test. How can i do that without taking full backup on DR and apply it on Production. Because, taking full backup, moving to Production Server will take lot of time. So, inorder to reduce, is there any alternative to reverse log shipping without any more backups (Full or Differential). Please share if you have knowledge on this. Thanks.
September 23, 2013 at 7:16 am
This can be done by:
1. Run the restore job on DR server
2. Take a tail log backup on Production server - This will leave the database in a restoring state
3. Restore the tail log backup to the DR server.
--Switch back
1. Take a tail log backup on "new" Production server - This will leave the database in a restoring state
2. Restore the tail log backup to the "new" DR server.
This will leave your original Production database as the Primary database.
September 24, 2013 at 4:02 am
What is the status of the database on old production server?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 26, 2013 at 1:33 am
It will be in a restoring state after the tail log backup
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply