Discussion in 'SQL Server 2005 Clustering' started by kumar99ms, Jul 18, 2008.
Hi Every body
What are the differences between active/active and active/passive
In an Active/Passive cluster, all of your databases reside on just one of the cluster nodes. The other node is there simply for redundancy...so if the primary node fails, the other server will take control of it's databases.
In Active/Active, both nodes have live databases on them, and if one fails, the other will take control of the failed servers databases.
Further to add... we should consider the server hardware configuration fact while configuring the A-A cluster. Because once there will be failure, the single server have to load balance both the instance of sql server
One thing you need to make sure that Clustering is not for load balancing - http://sqlserver-qa.net/blogs/perftune/archive/2008/02/29/3576.aspx fyi.
Separate names with a comma.