Share via

Does Adding a node weight using powershell, cause the windows cluster to restart?

Veena Srinivas 251 Reputation points
2022-07-20T18:16:32.453+00:00

Hello,

Using Powershell, can I add a node vote to a production Sql server at anytime? Does it take the Windows Cluster offline? I want to be sure it is safe to run this. Please advise. Thanks , VS

$node_weight = 1
$node = "servername"

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

Windows for business | Windows Server | Storage high availability | Clustering and high availability
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

Answer accepted by question author

YufeiShao-msft 7,156 Reputation points
2022-07-21T06:42:34.23+00:00

Hi @Veena Srinivas ,

No, it is safe.
The essence of adding a node vote is to keep the cluster running. So long as one voter is online, the cluster stays running.

https://www.altaro.com/hyper-v/quorum-vote-weight/#How_to_Adjust_the_Node_Vote_Weight

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

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.