just want to straighten my concept properly – when we are talking about SQL multi instance failover cluster, e.g. on a 2 node cluster, it means that each node can run its own sql instance, but each instances are running its own database right ?
e.g. 2 nodes (node1, node2)
sql instance A on node1
sql instance B on node2
sql instance A and B are individual instances and are not sharing the same database right ?
when node1 is down, SQL instance A will move to node2 but both sql instance A and B are still separate databases – right ?
Best Answer
That's correct. A traditional failover cluster may contain multiple instances, and each instance may contain multiple databases. A database is part of only one instance, and an instance only runs on one node at a time.