none
Cannot Failover Groups Manually RRS feed

  • Question

  • We are currently running a two node cluster on Windows Server 2003 and are unable to manually move groups from one node to another.  However, if we shut down the node that is currently hosting the groups, all of the groups will successfully fail over to the second node.  The groups contain SQL Server 2005 resources.

    When we try to move the group manually, it appears that all of the resources move over, but then the SQL Server and SQL Server Agent fail to start.  These are the errors that appear in the event viewer:

    [sqsrvres] OnlineThread: Error 5b4 bringing resource online.
    [sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 5b4)

    Those errors just indicate a timeout error though.  I'm not sure that a solution would be to increase the timeout period though.  When shutting down the node hosting the resources, they all immediately failover to the second one.

    Any ideas would be appreciated.
    Monday, March 8, 2010 10:25 PM

Answers