Restrict node to failover to particualar node.

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  October 19, 2011 at 8:29 am

  #246678

  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

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  October 19, 2011 at 9:10 am

  #1396703

  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

• R_S

  Ten Centuries

  Points: 1160

  More actions

  October 19, 2011 at 2:55 pm

  #1396977

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

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  October 19, 2011 at 10:41 pm

  #1397044

  Thanks all for replies.

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  October 21, 2011 at 3:32 am

  #1397818

  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"