0

Is it possible to create FAILOVER CLUSTER A with Node01 (active) and Node02 (passive) and FAILOVER CLUSTER B with the same Node02 (passive) and Node03 (active)?

I realized that SQL Server instances on passive nodes are not charged, only the OS. So sharing a node for more than one passive Sql-Instance would make sense here. I know, once cluster A and cluster B have an issue I am nipped...

But is this an allowed and/or common scenario?

Improve this question

1 Answer 1

Reset to default
3

Is it possible to create FAILOVER CLUSTER A with Node01 (active) and Node02 (passive) and FAILOVER CLUSTER B with the same Node02 (passive) and Node03 (active)?

No you cannot. This is enforced by Windows Server Failover Clustering.

I realized that SQL Server instances on passive nodes are not charged, only the OS. So sharing a node for more than one passive Sql-Instance would make sense here. I know, once cluster A and cluster B have an issue I am nipped...

There is nothing stopping you from creating a 3-node cluster (all nodes in the same cluster) and installing two SQL Server FCIs. You'll get roughly the same results.

Improve this answer
2
  • Isn't SQL Server (2016) Standard Edition stopping me from creating a 3-node cluster?
    – Magier
    Commented Dec 19, 2016 at 9:48
  • 1
    Standard edition is stopping you form having 3 nodes for the same instance. It says nothing about having more than one instance in a cluster. If you have three nodes and an instance on N1 and N2 and another instance on N3 and N2 you're not violating anything.
    – Sean Gallardy
    Commented Dec 19, 2016 at 13:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.