Repair Out of Sync Standby / Read-Only Microsoft SQL Database configured with log shipping
Sat, Aug 6, 2011When a log shipping configured stand-by database becomes out of sync, there are a few ways to fix it. Usually there is a threshold of about 45 minutes where after that point, manual intervention is required. When this occurs, it’s usually easily enough to restore the transaction logs manually. Remember to choose the proper options to “RESTORE WITH STANDBY”.
If this doesn’t work, it’s still easy enough to repair. Stop all of the associated backup, transfer, and restore jobs in the log shipping configuration, delete the standby database, and restore a copy of the database. Do a manual log backup and restore, and then start the log shipping jobs again!
