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 |
|
schinni
Yak Posting Veteran
66 Posts |
 Posted - 2004-07-27 : 20:39:32
|
| Hello,This is reagrding LogShipping I have a primary(Server1) and standby(Server 2) my primary(Server1) goes down and i bring the standby (Server2) up and running but i don't want to continue the standby(Server2) as permanent primary machine.So after the primary(Server 1) is bakup and running i want to make as it was before the problems without redoing the whole logshipping processes.What is the easiest way to do thisThanks, |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-24 : 04:24:59
|
| you can use either backup/restore or attach/detach database |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-24 : 13:06:26
|
| Schinni,We manually reverse the roles. So we resetup log shipping. We have tried switching the roles using the log shipping stored procedures, but that hasn't worked for us. We do this a few times a year to test out our disaster recovery processes.Tara |
|
|
|
|
|
|
Changing the Roles in Log Shipping