Post reply

General question about Log Shipping, how to revert back to Primary DB?

  • September 15, 2012 at 1:27 pm

    #281476

    Hi all,

    I'm new to log shipping, and my question is general and surrounds the basic procedure of fail-over to DR site, then reviving Prod:

    Say I've got a Prod and a DR site, and I'm log-shipping every half hour. The circuit for Prod goes down, lets say after the 3rd log (since the full backup) has been shipped.

    I say goodbye to any transactions that have occurred in prod since that 3rd log was taken, I make sure that 3rd log is rolled into the DR site and then I cut over to DR. Now the DR site is beginning at the point of the end of that 3rd log. We may or may not hand-enter transactions that we know we've lost, but we continue business on DR for a few hours. By this point we now have, say, 6 new logs from DR. The circuit now comes back up on prod.

    So, how do I roll back Prod to the point of the last successful shipped log (#3)? Do I have to do a full restore and roll forward up to Log#3, then call an planned outage for a few minutes (or whatever it takes) on the DR site take a final log on DR, send those DR logs back to the prod site, and roll them right in to prod, then cut back over to Prod?

    So what I'm getting at is that since Prod was at the point of Log#3, and DR started taking live transactions at exactly that point and collected, say logs 4 through 11, Prod will successfully recognize these and I will be in good shape? Is there some easier, quicker way to get Prod to roll-back to the exact point of the end of Log #3 without the full restore?

    Thanks very much,

    James.

  • September 15, 2012 at 3:24 pm

    #1538301

    James Stephens (9/15/2012)

    I say goodbye to any transactions that have occurred in prod since that 3rd log was taken,

    no you dont. You take a tail backup of the primary log and put it in norecovery mode and apply the back to the secondary with recovery.

    James Stephens (9/15/2012)

    The circuit now comes back up on prod.

    So, how do I roll back Prod

    Reverse

    Ps don't forget to stop all related LS jobs

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply