Can you do SQL Server Clustering of more than 2 servers? Master can have more than 1 slave? What is the limit?
A:
The number of allowable nodes in the SQL Server cluster depends on your SQL Server version and your Windows Server version. For SQL Server 2008 Standard edition, you can only have two cluster nodes. If you have SQL Server Enterprise, the limit depends on your Windows Server version, 8 cluster nodes for 2003 and 16 nodes for 2008.
Here is the Microsoft information for SQL Server clustering.
bobs
2010-08-14 16:08:30