snippetModerate
how to reinitialize log shipping?
Viewed 0 times
logreinitializeshippinghow
Problem
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)
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)
Solution
- Disable the log shipping jobs on both servers.
- Back up the database on Server A.
- Restore the database with the backup you just created and
with norecoveryon Server B.
- Re-enable the log shipping jobs on both servers.
Context
StackExchange Database Administrators Q#118521, answer score: 14
Revisions (0)
No revisions yet.