Configure Cluster Quorum Node Weight Settings

13 May Configure Cluster Quorum Node Weight Settings

While using SQL AlwaysOn in connection with a third node on a different location as a DR solution, the third node is needed only in case there is a real Disaster Recovery. For this purpose in most cases a manual intervention/failover is needed and you need to align your DR Cluster Node Weight for it. You can use following PowerShell snippet:

Import-Module FailoverClusters

$node = 'AlwaysOnNode1'
(Get-ClusterNode $node).NodeWeight = 0

$cluster = (Get-ClusterNode $node).Cluster
$nodes = Get-ClusterNode -Cluster $cluster

$nodes | Format-Table -property NodeName, State, NodeWeight



Share this:
Facebook
LinkedIn
WhatsApp
Like this:
Like Loading...


	
Related