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.
| Author |
Topic |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2010-09-07 : 10:43:06
|
| Guys,I have setup log shipping for our OLTP database - the restore on the secondary occurs each night. However, if my primary database fails what are steps that will need to be followed for me to recover from the secondary database especially since the secondary in single user/read only mode and that we cannot backup by the secondary database.Any inputs/suggestions would help.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-09-07 : 12:32:32
|
| The restore on the secondary database should be happening every 15 minutes or so, not each night. To failover to the secondary server in the case of a disaster depends on if the primary server is reachable or not:1. If primary server and primary database is available - Backup the tlog on primary server, restore with recovery to secondary2. If primary server is available but primary database isn't, grab the latest tlog from the primary, restore with recovery to secondary3. If primary is completely unavailable, restore with recovery to secondaryTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Log Shipping Disaster Recovery