Node and file share majority with two nodes

Question

Hi All,

I have a two-node and a file share cluster for SQL Cluster. Dynamic Quorum is enabled. When file share goes offline does the cluster can also go offline?

Both nodes and file share

Regards,
ACDBA

Answer 1

Hey,

As mentioned, cluster will not go offline. File share is a role which is running on top of the cluster. Cluster actually handles high availability of the role. You can use StarWind VSAN to configure disk witness to increase cluster survival rate. The following guide should help: https://www.starwindsoftware.com/resource-library/starwind-virtual-san-for-hyper-v-2-node-hyperconverged-scenario-with-windows-server-2016/

Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

Answer 2

Hi，

>When file share goes offline does the cluster can also go offline?

The cluster will not go offline.
https://learn.microsoft.com/en-us/windows-server/storage/storage-spaces/understand-quorum

Please using the "Validate Cluster "in failover cluster manager to view the report of cluster quorum configuration.
For the cluster with two nodes and file share witness, all three should have votes.