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 |
|
TJ
Posting Yak Master
201 Posts |
 Posted - 2002-04-02 : 10:05:42
|
I was presented with the following question and asked to find a way to solve the problem.quote:
What we need is another method of user authentication to the mail server in case server1 goes down. Maybe just a table will work, but I don't know. I was told that this has been tried in the past and has failed. I guess what we really need is a total backup (for failover) database of DB1 running on server2 that can be used for anything in case server1 ever goes down.
Would a daily DTS of the data from server1 with all of the data updated or inserted from this database into server2 be a solution?Is there a better, more efficient way to do this? Is there documentation or articles somewhere that I can read to help me decide what to do?Thanks for your help!Teresa"Someday I'll know enough to help someone else!" |
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2002-04-02 : 10:35:36
|
| How about snapshot replication or merge replication for each database that you want 'mirrored' on server2?Search through BOL for the differences between Snapshot, Transactional, and Merge replication. Each will be able to 'mirror' your data to other servers. |
 |
|
|
|
|
|
Mirror a Server?