Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.