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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-05 : 08:58:52
|
| Bert writes "Can log shipping be setup to automatically adjust its processes to accommodate a failure between its primary and secondary servers, and accommodate the return to initial log shipping roles? This would involve processes to do the following:1) Keep a backup database on a secondary server in sync with its shipping pair. 2) Activate the Secondary server to take on the primary role.3) When the old primary becomes available have it assume the log shipping backup role.4) Return the primary role to the Initial Primary server.5) Reestablish the initial log shipping processes, which keeps the backup database on a secondary server in sync with its shipping pair.Steps 1 and 2 are fairly simple to implement, but steps 3,4 and 5 are the ones giving me the problems. Is there an easy way to implement the switchover to the secondary server, setup the initial primary as the secondary, and then return the primary and secondary to its initial log shipping roles? " |
|
|
|
|
|
log shipping