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
Go to Top of Page
   

- Advertisement -