SQL AOAG(SQL ALways On Availability Group)

  • PDC(Primary Data Center) has 2 Nodes(PDCDB01 and PDCDB02)
  • DRC(Disaster and Recover Center) has 1 Node(DRDB01)
  • FSW(File Share Witness)

Quorum Votes:

  • PDCDB01 - 1 Vote
  • PDCDB02 - 1 Vote
  • FSW - 1 Vote
  • DRCDB01 - 0 Votes

If PDCDB01 and PDCFB02 goes down, I need to force quorom on DRDCDB01 with the sciprts below:

Import-Module FailoverClusters  
$node = "Always OnSrv02"  
Stop-ClusterNode -Name $node  
Start-ClusterNode -Name $node -FixQuorum  
(Get-ClusterNode $node).NodeWeight = 1  
$nodes = Get-ClusterNode -Cluster $node  
$nodes | Format-Table -property NodeName, State, NodeWeight  


net.exe stop clussvc  
net.exe start clussvc /forcequorum  

I was using the cmd since I am creating a batch script.

I was reading an article: Manual Failover of Availability Group to Disaster Recovery site in Multi-Site Cluster It stated that:

Once the remote node has been granted a vote for quorum, then remove the votes of the two nodes in the primary datacenter.

So I created a cmd script instead of the powershell script mentioned in the article:

  cluster.exe node DRDB01 /prop nodeweight=1 /prop:NodeWeight /status
  cluster.exe node PDCDB01 /prop nodeweight=0 /prop:NodeWeight /status
  cluster.exe node PDCDB02 /prop nodeweight=0 /prop:NodeWeight /status

I know that General rule of Quorom is votes should be ODD number. Upon including it in my batch script, i get the error below:

System error 5954 has occurred (0x00001742). The request is invalid either because node weight cannot be changed while the cluster is in disk-only quorum mode, or because changing the node weight would violate the minimum cluster quorum requirements.

Only PDCDB02 has been change to 0 vote. Qurom Votes:

  • DRDB01 - 1 Vote
  • PDCDB02 - 0 Vote
  • FSW - 1 Vote
  • PDCDB01 - 1 Vote

In that case, my question is do I still need to change the votes of PDCDB01 of PDCDB02 to zero. Otherwise, I will just run:

cluster.exe node DRDB01 /prop nodeweight=1 /prop:NodeWeight /status

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.