I'm looking for a way to set up an 2008R2 SQL Server with an multi instance Cluster which serves mutual active/passive.
So basically two nodes where each one holds half of the databases active and the other half passive.
So i have a kind of ghetto load balancing with failover.
Is this possible?
Oh and the Servers running Win 2k8R2 Enterprise Server and the SQL Servers will be both 2008R2 Enterprise.