We don't want automatic failover for our availability group, but I have set availability mode to Synchronous, was that a mistake?
The availability group runs on vmware with windows 2012R2, and I got the error messages below after the cluster "crashed". (There was some manual migration off the vmware at the same time)
Can I related the crash to availability mode settings?
Thank You in advance. Regards Odd
Kl 13:58:56 – Critical : Cluster node ‘' was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to the node having lost communication with other active nodes in the failover cluster. Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapters on this node. Also check for failures in any other network components to which the node is connected such as hubs, switches, or bridges.
Kl 13:58:56 – Critical : Cluster node '' was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to the node having lost communication with other active nodes in the failover cluster. Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapters on this node. Also check for failures in any other network components to which the node is connected such as hubs, switches, or bridges.
Kl 13:59:58: -Critical: File share witness resource 'File Share Witness' failed to arbitrate for the file share '\\Quorum'. Please ensure that file share '\\Quorum' exists and is accessible by the cluster. Kl 13:59:58: - Error: Cluster resource 'File Share Witness' of type 'File Share Witness' in clustered role 'Cluster Group' failed.
Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet.
Kl 13:59:58: -Critical: The Cluster service is shutting down because quorum was lost. This could be due to the loss of network connectivity between some or all nodes in the cluster, or a failover of the witness disk. Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapter. Also check for failures in any other network components to which the node is connected such as hubs, switches, or bridges.
Kl 14:01:22: - Error: Cluster resource '_Grp' of type 'SQL Server Availability Group' in clustered role '_Grp' failed.
Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet.
Kl 14:01:34: - Error: Cluster resource '_Grp' of type 'SQL Server Availability Group' in clustered role '_Grp' failed.
Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet.
Kl 14:01:34: - Error: The Cluster service failed to bring clustered role '_Grp' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered role.