Windows Forum

Ask something
Discussion Locked

SQL2000

0 helpful
3 replies

by mjuhrig

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have several web servers and 2 SQL 2000 servers. I want the web servers to be able to use either SQL server. I have a router that can do the load balancing, I need something like a cluster both sql servers are continuosly updated and need to stay insinc. if 1 goes down the other must be able to take over

3 replies

by glen_mcleod

2 possible solutions come immediately to mind:

Check out Miscrsoft Cluster Services for Win2K.

Look into Log Shipping for SQL Server 2000.

MSCS will offer the best solution, but can be expensive. Log Shipping will give you somewhere between a 'hot' and 'warm' backup, but won't automaticaly fail over, although your router may be able to. I don't know anything about routers, I'm not a hardware guy...

Glen

This discussion is closed to new replies.