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 |
|
ewe1d@yahoo.de
Starting Member
17 Posts |
 Posted - 2004-09-28 : 10:18:35
|
| Hi,Does anyone have experience of doing a switch to a standbyDb that has been fed with data from log shipping? I read in MS Docu Log Shipping http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx that you're sposed to execute 2 stored procs, one on the primary DB, one on the standbyDb, but what do you do if the primary has failed (apart from testing it beforehand...)ThanksChidd |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-28 : 10:35:34
|
| To switch to the standby server all you need to do is recover the datbase (after applying any logs that you can get from the source databasee) then switch all the connections to it.Then you need to decide what to do - create new standby server or rebuild the old server and switch back to it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Experience of switchover to standbydb