Originally posted SQL 2016 Administration but I think this forum may be better
Could someone advise on the following design?
We have a 2-node cluster, Windows 2012, sitting in different Data Centres and different Subnets. The 3rd vote is a File Share Witness sitting on an IAAS VM in Azure....The question recently came on the following scenario
In the scenario where Node 1 was hosting a SQL AG and Node 2 was hosting the Cluster Core Resources. What exactly would happen if we lost connectivity between the 2 DC's (but both Maintained connectivity to Azure and the FSW)?
My initial thoughts are that the SQL AG group would fail from Node 1 to Node 2 and Node 1's Cluster service would stop as it cannot see the other node.
Is this accurate?