High capacity replication and load balancing question

[intelwizrd]

I am trying to set up a load balanced sql server solution that will allow for maximum availability and load balancing. I want to be able to turn off one of the servers at any moment and have the database still be available. I am unsure of to set this up. I want to be able to balance the load of queries, both read and write across all servers. I am going to be starting with 2 quad processor servers and possibly growing from there.

Any thoughts would be very helpfull as I am a newb when it comes to SQL server and replication.

----------------------------
Josh
CCNA, MCSE 2003(in progress)

 

[mrdenny]

There is no true real time replication between servers. To have both server be able to handle read and write queries to the database you'll need transaction replication.

This will be the only replication method that meets your needs.

How many transactions per second are you looking at on each server?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)