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 |
|
srad
Starting Member
39 Posts |
 Posted - 2004-04-13 : 06:25:45
|
| Thinking about implementing log shipping and i have read all related BOL stuff and have a question?This database must have been restored using the WITH STANDBY option to properly accept logs.In the event of failure i want to make the Standby Server the PRIMARY so what steps do i need to take in order for this to happen?I have read through How to set up and perform a log shipping role change (Transact-SQL) but this mentions executing sp's on the PRIMARY, but what happens if it's not available?? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-13 : 12:28:03
|
| To make the standby server the PRIMARY, you should copy over the last transaction log if possible, then run RESTORE LOG WITH RECOVERY.I've never used the log shipping role change stored procedures. We move our databases to a disaster recovery site twice a year in which we perform the RESTORE LOG WITH RECOVERY option.Tara |
 |
|
|
|
|
|
Log shipping