Transaction Log – How to Reinitialize Log Shipping

transaction-log

Here is the situation:

DB on Server A had the transaction log shipping configured and uses Server B as secondary. It has been working well for a long time.

However, we recently detected that one of the trn files got corrupted and Server B cannot restore it.

DB on Server A is still healthy, so I would like to create a new full backup into Server B and restart the transaction log shipping.

Since all the timings and other settings were already tweaked and configured, I am trying to avoid starting from scratch.

What step would i need to follow in order to reinitialize the log shipping? (This is a SQL Servert 2008 R2)

Best Answer

  1. Disable the log shipping jobs on both servers.
  2. Back up the database on Server A.
  3. Restore the database with the backup you just created and with norecovery on Server B.
  4. Re-enable the log shipping jobs on both servers.
Related Question