Restore from the log shipping database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

High Availability (2008)

Restore from the log shipping database

Author

Topic

csaha
Yak Posting Veteran

52 Posts

Posted - 2012-10-09 : 19:55:04

What steps should I follow to make the secondary server as the primary server where the database is in read only mode. Do I inactivate log shipping and restore the read only database from the transaction log.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-10-10 : 17:06:46

Disable the LS jobs. Recover the database with either a final tlog backup if you can get it or recover what you have on the secondary.

RESTORE LOG ...
FROM ... <--omit this if you can't get the final tlog backup in the case of a disaster or similar
WITH RECOVERY

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources