Restrict node to failover to particualar node.

  • Hi All,

    I got one interview question, if I am using more than two node cluster, Is this possible to restrict any node to failover to any particular node ? E.G. I do not want node1 to failover node2, I want if anytime failover happens it should be node1 to node3. If it is possible then how ?

    Thanks in advance

  • Yes, that is possible in one of two ways, you could not install that instance on Node 2 at all or you can go into the resource group for that instance, right click on the SQL Server and go to the tab labeled Advanced Properties, then uncheck Node 2 as a possible node. I would also not have Node 2 checked on the preferred node list but that isn't a preventer of it trying. By unchecking it as a possible node it won't run there.

    CEWII

  • Yes, you can do it by selecting from the Possible Owners list. You can do this from Cluster Admin.

  • Thanks all for replies. 🙂

  • be aware that preferred owner is set at the group level, possible owner is set at each resource level

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply