Saturday, May 21, 2011

Cluster Problems when Upgrading to SQL2008

While upgrading from SQL2005 to SQL2008 (not R2) in a 2-node 2-instance Windows 2003 R2 clustered environment, one of the DBAs ran into the problem where one of the SQL resouce groups would not move from one node to the other.  Error message:

An error occurred attempting to move the '<groupname>' group.
A cluster node is not available for this operation.
Error ID: 5005 (0000138d).


Found this which gave the answer.  One of the resources (the network name) did not have the node we we were moving to in its preferred node list.  Once that was corrected, the resource group moved as it should.

No comments:

Post a Comment