Return
-
Title
How to bring subscriber online if the Publisher fails with 5.0 Log Shipping -
Description
If you have a Log Shipping plan setup and the publisher fails, how do you bring the subscriber online?
-
Cause
N/A
-
Resolution
In version 5.0 of LiteSpeed, to bring the subscriber database online,run restore database dbname with recovery.
Example:
RESTORE DATABASE Northwind WITH RECOVERYStop any LiteSpeed Log Shipping jobs prior to running the restore. Once you have the publisher database up again, youll need to setup the Log Shipping plan all over again.