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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 2 server, 1 running, 1 backup

Author  Topic 

beckkp
Starting Member

3 Posts

Posted - 2004-08-18 : 22:43:39
Hi,
Im currently implementing an application that may need 2 SQL2000 running at the same time...In case that one is down, another one will be up immediately to replace it...Im still finding the solution for this...have considered the Replication but I think it wouldn't automatic switch the server, which is down, to another...
Anyone can give me suggestions or may be solutions...
thanks !!!

==========
||beckkp||
==========

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2004-08-19 : 03:43:20
Failover Clustering !

- Sekar
Go to Top of Page

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2004-08-19 : 03:44:58
HTH..
http://www.sqlteam.com/item.asp?ItemID=5137
http://www.sql-server-performance.com/sqlserver2000_clustering_install_main.asp

- Sekar
Go to Top of Page
   

- Advertisement -