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 - 2005-09-26 : 07:58:18
|
| Steve writes "Is it possible to use the replication function in SQL 2000 to mirror the database to another server, and in the event of a disaster, switch to the second server run and update on that server and when the disaster is resolved switch back to the original server. What are the pro's and cons, would a third part replication be more productive ?" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-28 : 02:15:22
|
you may also want to read on logshipping (transferring logs to another server and restoring it, should serverA goes down applications/users needs to be redirected to serverB) and clustering (clustering is fail-over, in case serverA goes down, serverB immediately takes the load from serverA, users won't even know they've shifted from serverA to serverB)for replication, that depends on what type of business you're running  HTH--------------------keeping it simple... |
 |
|
|
|
|
|
SQL Replication