• hdctest (4/2/2015)


    Hello,

    I have a SQL cluster and the Witness disk status shows as online but the passive node shows a "cluster event" that the passive node failed to form a cluster due to this witness issue. Oddly, the failover manager from the active node does not show this or any cluster event. the SQL cluster has not failed over recently.

    Can you tell me how to correct the passive node's witness issue? I'm not sure where to even begin.

    Need a bit more info really.

    how many nodes in the cluster?

    how many clustered instances of sql server?

    If you don't have a great deal of experience I'd get someone to look at it who does have the relevant knowledge. Have you consulted with your windows server engineer?

    If you can post the output of the following Powershell queries it would be helpful

    import-module failoverclusters

    get-clusterquorum

    import-module failoverclusters

    get-clustergroup | ft name, iscoregroup, ownernode, state

    import-module failoverclusters

    get-clusterresource | ?{$_.iscoreresource -EQ "True"} | ft name, iscoreresource, ownernode, ownergroup

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉