How to I get/manage the Win2012R2 Cluster Resource of SQL Server Possible Owners using Powershell ?
-
How to I get/manage the Win2012R2 Cluster Resources PossibleOwners using Powershell ?
$InstanceName = 'D006'
Get-ClusterResource -Cluster cl11 -Name "SQL Server ($InstanceName)" |
where ResourceType -eq 'SQL Server' | Get-ClusterOwnerNode ;
ClusterObject OwnerNodes
------------- ----------
SQL Server (D006) {DV25, DV26, DV27}
This shows the potential owner nodes of the cluster Role !
I need to remove a node from this list.
If I user that using Remove-ClusterNode It removes the node from the cluster.
Remove a node from a failover cluster. After the node is removed, it no longer functions as part of the cluster unless you add it back to the cluster.
That is not the goal, because with Always On, the node has to be joined to the cluster.
Question is: How do I remove a node from the list of possible owners of a sql server clustered instance ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Solved the issue !
The trick lies in Set-ClusterOwnerNode and specify a Resource !
$Res = Get-ClusterResource -Cluster cl11 -Name "SQL Server ($InstanceName)" |
where ResourceType -eq 'SQL Server'
Set-ClusterOwnerNode -Resource $Res -Owners DV25, DV26
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply