Jim, I used DATACLAS for our applications talking to SQL. It has a table that says what server you should talk to. When one goes down, I update the table to talk to the other server. All users were up and running in 5 minutes when one of the servers went down.
A word of warning though, if the server that is hosting the replication goes down, you will need to rebuild it. Though, I can say I rebuild the replication once a year because it leaves stuff and the database grows. I keep saying I am going to do more research on this go get some sprocs to clean it up better, but never seem to find the time. We have been using replication for years. I think it is a wonderful tool. Dawn >Jim Felton <> wrote: > Dawn, we are looking at SQL 2000 replication right now. Can it be > setup to do an automatic roll over to the backup server if the main > server fails? -----Original Message----- _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the originator of the message. This footer also confirms that this e-mail message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Merle Norman Cosmetics. _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
