SQL 2012

I've been researching and testing Log Shipping as a DR solution. I got the two servers setup. Log shipping is in place and verified to be working correctly. I failed over by restoring the last translog and recovering the database. All this testing was done on VMs on my laptop. At this point everything looks good.

My question now is, how do you fail back? What if this were a true test of the DR in Production. Ok I proved it worked, the test is over, now I need to fail back. Is there a best practice?

1 Answer 1


Check this article -- Reversing Log Shipping! Now what you need to do is to take the log backup with NORECOVERY on the primary and restore this log on the secondary with RECOVERY. This will preserve the log chain.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.