October 19, 2011 at 8:29 am
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
October 19, 2011 at 9:10 am
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
October 19, 2011 at 2:55 pm
Yes, you can do it by selecting from the Possible Owners list. You can do this from Cluster Admin.
October 19, 2011 at 10:41 pm
Thanks all for replies. 🙂
October 21, 2011 at 3:32 am
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