SQL Server Performance Forum – Threads Archive

How to restart Log Shipping

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.

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.

]]>