SQLCrazyCertified (11/20/2012)
Hi All,I was troubleshooting a connectivity issue for a cluster server.
SQL 2k5 on Windows 2k3.
Found an instance is down, manually brought back online. However, I am wondering howcome it didn't failover to another node rather than being failed.
Does the failover only happens when the node is down?
can someone advise me how to check why it didn't failedover/
Thanks,
SueTons.
The default generally is to try to restart locally, if this is unsuccessful try 3 times on the partner. If this is unsuccessful the group goes offline.
Check the event logs but also, with the group offline move it to the partner node if its not already.
Now try to bring the resources online one at a time in this order
Look out for any resources that fail, most common is the disk resources not failing properly from one node to another.
Btw in future it would help if you post in the correct forum
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉