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

Log Shipping Revertion Expand / Collapse
Author
Message
Posted Monday, September 23, 2013 3:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:21 PM
Points: 7, Visits: 117
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.
Post #1497302
Posted Monday, September 23, 2013 7:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:17 AM
Points: 1,379, Visits: 2,687
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.
Post #1497374
Posted Tuesday, September 24, 2013 4:02 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1497743
Posted Thursday, September 26, 2013 1:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:17 AM
Points: 1,379, Visits: 2,687
It will be in a restoring state after the tail log backup
Post #1498696
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse