SQL Server Performance

How to restart Log Shipping

Discussion in 'SQL Server Log Shipping' started by wjwagman, Mar 7, 2006.

  1. wjwagman New Member

    Greetings, I have log shipping set up and it has been working properly. Yesterday the primary server was rebooted and now log shipping is failing. The logs are being shipped to the standby server but are not being applied. How do I resolve this problem? Is it necessary to begin from step 1, recreate the standby? Thanks.
  2. satya Moderator

    Stop the log shipping schedule, apply the user database backup from Primary server to secondary server and once it completes successfully continue the log shipping schedule.

    Satya SKJ
    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