60 pts.
 Windows cluster troublshooting
All, In windows 2003 cluster resources, while moving resources from one node to another, some time resources are taking long time to come online or it may fails, such as SQL and disk resources. why ? How to trouble shoot and how and why it happens. Is SQL resources depend upon SQL database services? How resources will work during moving from Active to Passive. I would like to know in depth for my question. Can anyone resolve my question? Thanks in advance. Regards. Aravind.

Software/Hardware used:
Software
ASKED: August 1, 2011  7:55 AM
UPDATED: March 31, 2012  7:27 PM

Answer Wiki:
The SQL resource is the SQL Service. The resources that you see in the cluster administrator map to services, or devices on the servers. When the cluster fails over it simply stops the SQL Service on one node and starts the service on the other node. If disks take a long time to fail over that's because the servers are having a problem changing the ownership of the disks from one node to another. This is usually due to something on the old node still trying to do something with the disk on that machine. If SQL is taking a long time to come online that should be shown in the SQL ERRORLOG file. You should look in there to see why that disk isn't coming online.
Last Wiki Answer Submitted:  August 1, 2011  4:07 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _