SQL Server Performance

Log shipping

Discussion in 'SQL Server Log Shipping' started by sandeepksharma, Jun 8, 2006.

  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
  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.

Share This Page