resync log shipping

  • We have a 100 GB database and is configured with log shipping. For some network issue, one of the log shipping backup file got corrupted and the restore on the secondary is failing.

    In this case what are the steps to re sync the log shipping?

    Thanks

  • check the transaction log shipping monitor, find out the last applied transaction log,find out all the log backups created by the transaction log backup on the primary server after the last applied transaction log on the secondary server,copy the same to the secondary server and run the transaction log restore again on the secondary server.I am assuming the log shipping file has been corrupted while getting copied over the network.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply