September 27, 2012 at 10:27 pm
We have a two node (NODE1 and NODE3) cluster (windows 2008) with SQL 2008 (INST1 and INST2) instance running on each node. The quorum setting is "Node and Disk Majority". NODE1 is the owner of the cluster and it holds the quorum disk. What will happened if I restarted the NODE1 (which owns the quorum disk) with out moving the Quorum to the node (NODE2)? Will the cluster fail or NODE2 take the ownership of the quorum and INST1 will failover to NODE2 ? In our environment cluster fails and we need to restart the NODE2 also to bring the cluster up. I am sure this is not the expected behavior.Any clue where I have to look into to fix this issue? Thanks in advance for your help
Thanks
Nelson
(WWW.PracticalSqlDba.com)
September 27, 2012 at 11:28 pm
nelsonaloor (9/27/2012)
We have a two node (NODE1 and NODE3) cluster (windows 2008) with SQL 2008 (INST1 and INST2) instance running on each node. The quorum setting is "Node and Disk Majority". NODE1 is the owner of the cluster and it holds the quorum disk. What will happened if I restarted the NODE1 (which owns the quorum disk) with out moving the Quorum to the node (NODE2)? Will the cluster fail or NODE2 take the ownership of the quorum and INST1 will failover to NODE2 ? In our environment cluster fails and we need to restart the NODE2 also to bring the cluster up. I am sure this is not the expected behavior.Any clue where I have to look into to fix this issue? Thanks in advance for your helpThanks
Nelson
(WWW.PracticalSqlDba.com)
Exactly what you'd expect to happen if a cluster node restarted due a hardware failure provided you haven't paused/disabled part of the cluster. All resources will failover to the passive node.
So it looks like there is an issue in the cluster setup. You will need to check the event and cluster logs.
September 28, 2012 at 3:52 am
nelsonaloor (9/27/2012)
We have a two node (NODE1 and NODE3)
Do you mean NODE1 and NODE2?
nelsonaloor (9/27/2012)
NODE1 is the owner of the cluster and it holds the quorum disk. What will happened if I restarted the NODE1 (which owns the quorum disk) with out moving the Quorum to the node (NODE2)?Will the cluster fail or NODE2 take the ownership of the quorum
The resources will automatically move to the partner node.
nelsonaloor (9/27/2012)
and INST1 will failover to NODE2 ?
As long as NODE2 is a partner for the clustered instance INST1, i.e. you have installed the instance software, then yes it too will move to the partner node
nelsonaloor (9/27/2012)
In our environment cluster fails and we need to restart the NODE2 also to bring the cluster up. I am sure this is not the expected behavior.Any clue where I have to look into to fix this issue? Thanks in advance for your helpThanks
Nelson
(WWW.PracticalSqlDba.com)
What were the results of your cluster validation report?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply