Load Balancing and Fail Over for SQL Server.

Hi!
Currently we only have one SQL Server database in our production system. I would like to add one more SQL server 2000 database. I would like to configure them so that both server share the load and Failover. I did some research and I found that I can do this by installing the OS (Windows 2000 Server Enterprise Edition) and SQL 2000 Enterprise Edition on both machines using the windows clustering. I want both servers to be active. They both have a copy of the production data. What I don't know is that, if it is possible to synchronize the data on both databases using SQL Server Replication utitlites. From what I know one SQL Server must be Publisher and one Subscriber. Can one sql server be both? Because I want both sql server to be identical. Can I set up replication between more than 2 servers? We just need to add one server for now but I would like it to be expandable. In the future we may need more.
So Please provide me some ideas and answers about the following.
1- Can two SQL Server cross replicate (both update each other in order to be identical)?
2 -Does replication work beyond 2 servers.?
3- If you were to set up a production database; what do you recommend considering the load balancing and Failover using Windows 2000 Server Enterprise Edition and SQL Sever 20000 Enterprise Edition?

Thanks,
MichaelTry this link for a tutorial but get his book a chapter will walk you through the SQL Server setup with the hardware. The only thing he did not cover was the Fiber Channels in detail. Hope this helps.
http://www.windowsnetworking.com/articles_tutorials/Deploy-Windows-Server-2003-Planning-Network-Bandwidth.html|||

I did not answer the second part to your question about replication it is SQL Server Agent dependent. So you must install SQL Server Agent with a service account, most of the service packs we have been getting are fixes to the replication system why I cannot tell you because I have not use it for a long time it uses a lot of system resources and you could do the same with DTS on scheduled Jobs. You can test it because in SQL Server 2000 you can setup replication within one server. Hope this helps.

|||

Thank you guys for your time. I did find an open source solution. It is cross platform and can do merge replication between different databases. The name of the product is daffodil.

Thanks again.

Programmer 420