1. sandeepksharma New Member

   Wanted to know in case Log shipping stops working because of 'Out of Syn.' error, how can we restore log shipping back to operational from the point where it was broken.
   
   Thanks

   sandeepksharma, Jun 8, 2006

   #2
2. satya Moderator

   RESTORE on secondary server from the primary database backup, and then continue the log shipping.
   
   Satya SKJ
   Microsoft SQL Server MVP
   Contributing Editor & Forums Moderator
   http://www.SQL-Server-Performance.Com
   This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

   satya, Jun 8, 2006

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in