Network failure scenario WSFC - 2 Node with FD

[NoSkillDBA]

Hey,Quite a basic failover question really, but I currently can't set up a lab to test this 100%.Suppose we have a scenario with a 3 Node Failover Cluster all on **different datacenters**.* **Node A** \- Preffered Owner of AG1 * SQL AG 1 Primary * SQL AG 2 Standby* **Node B** \- Preffered Owner of AG 2 * SQL AG 1 Standby * SQL AG 2 Primary* **Node C** * FileShare Witness* Node A sees C and B* Node B sees A and C* Node C sees A and B**Q1:** What happens when there is a **network failure** between A and B and the Nodes themselves are online?*Does the Quorum vote happen and the AGs log

Continue reading...