I am new to SQL Clustering.
Can we create Active-Active cluster on SQL Server 2008 R2 Server, which will be having facility to loadbalancing Databases on Clustered Hardware, i.e. some Databases will be on SQL_Cluster_Host_A and Some will be on SQL_Cluster_Host_B.
Or is there any way to configure the above thing?
SQL_Cluster_Host_A will host Database 1,188.8.131.52 and SQL_Cluster_Host_B will host Database 6,7,8,9,10.
When Host A will fail all DBs will goto Host B, and vise versa.
View Complete Post