I have a 3 node cluster.
All of the nodes are part of Cluster01 in what should be A/A/P mode.
Usually instanceA and instanceB of SQL Server would reside on NodeA and NodeB respectively. the windows cluster resources would reside on NodeA and NodeC would be the passive node.
Currently, our configuration is as follows:
- NodeA has the cluster resource group which contains the Quorum, Windows Cluster IP and HostName as well as the MSDTC
- NodeB has instanceA of SQL Server with it's own IP and HostName
- NodeC has instanceB of SQL Server with it's own IP and HostName
My question is, while i know that usually a failover would cause some downtime, given that our SQL Server instances have their own IP and HostName and users are connected to those, would failing over the Quorum, Windows IP/Host and the MSDTC interrupt the SQL service in any way?
I've checked that there are no dependencies to the Windows Cluster, but is that a bit like saying if i pull the plug out will Windows still run?
Thanks in advance!