How to: Recover from Failover Cluster Failure in Scenario 2

SQL Server Setup

previous page next page

In Scenario 2, failure is caused by Node 1 being down or offline but not irretrievably broken. This could be caused by an operating system failure or a hardware failure.

Procedure

To recover from a failover cluster failure

After Node 1 fails, the Microsoft SQL Server failover cluster fails over to Node 2.

  • Resolve the problem with Node 1.

  • Ensure that the Microsoft Cluster Service (MSCS) cluster is working and all nodes are online.

  • Attempt to failover SQL Server to the recovered node. If this succeeds, no further action is required, with the exception of normal testing. If SQL Server fails to come online on the recovered node, see Failover Cluster Troubleshooting.

    • See Also

    previous page start next page