Load Balancing with NT Server

I'd be very grateful if you expert guys could help me out with a little technical problem.

I have a website that is growing rapidly with ASP on the front, SQL Server on the back end running on IIS/NT.

I'd like to move this two a dual redundant/load balanced system where the site can run on 2 NT servers so that one can take the load if the other has a problem and both can share the traffic while both are running.

I presume that two copies of SQLServer will run, one on each serer with some sort of replicator to keep the data in the two databases in sync.

I understand that there is two approaches:

1. Some sort of clustering software

2. Using a hardware based load balancer.

Which is the best sort of solution?

Do I have two SQLServers, one on each server or put in on a third server? Or do I need 4 servers ?


Can anyone help a desparate man, I'd be very grateful!

Thanks

 

 

 

 

Top