GilaMonster (2/18/2012)
You can't load balance two or more SQL Servers without huge amounts of work to keep the two databases in sync eg though (peer-to-peer replication).Typically you'd load balance a group of web servers and they'd all talk to a single SQL Server, probably a more powerful server.
That said, peer-to-peer replication is a SQL 2005+ feature, I assume you have SQL 2000 since you posted in the SQL 2000 forums. If that's the case, the best advice I can give is upgrade to something less than 10 years old.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability