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 ?