-1

This is about patching a 2 node SQL FCI.

Say node1 is the current active node.

When I am patching the node2, how do I ensure that there won't be a automatic failover to node2 even if node1 crashes during patching?

1 Answer 1

4

The correct and documented procedure is to use the /FAILOVERCLUSTERROLLOWNERSHIP parameter when calling the upgrade source.

9
  • learn.microsoft.com/en-us/sql/sql-server/failover-clusters/… says that As you upgrade each node, it is left out of the possible owners of the failover cluster instance. If there is an unexpected failover, the upgraded nodes do not participate in the failover until Windows Server failover cluster role ownership is moved to an upgraded node by setup.. I had thought this was auto decided by the patching process but looks to be manual option.
    – variable
    Feb 20 at 17:59
  • literally the next sentence is, "By default, SQL Server setup automatically determines when to fail over to an upgraded node." and then goes into the parameter I specified in my answer. I'm unsure as to what the confusion is or why items are taken out of context. Feb 20 at 18:22
  • It's unclear to me whether I need to manually specify this parameter FAILOVERCLUSTERROLLOWNERSHIP
    – variable
    Feb 21 at 3:29
  • If you read the link to the documentation I gave you, you'd find this is explained, "/FAILOVERCLUSTERROLLOWNERSHIP=2 is the default setting. It will be used if this parameter isn't specified. " Feb 21 at 13:05
  • It says the =2 is default and that This setting indicates that SQL Server Setup will manage cluster ownership (move group) as needed. - where can I find what as needed means? I'm looking for something that will conclusively tell me that - by default, node 1 will never fail over to node 2 during the ongoing patching of node 2.
    – variable
    Feb 23 at 17:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.