question

ACDBA avatar image
0 Votes"
ACDBA asked Criszhan-msft commented

Node and file share majority with two nodes

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
Is there any update on this case?
If the answer is helpful, please click "Accept Answer" and upvote it.

0 Votes 0 ·
Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft edited

Hi,

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

The cluster will not go offline.
https://docs.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.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexBykovskyi avatar image
0 Votes"
AlexBykovskyi answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.