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

 
discard

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

Browse other questions tagged or ask your own question.