SQL Server Setup Help | |
How to: Recover from Failover Cluster Failure in Scenario 2 | |
See Also |
High Availability Solutions Overview > Getting Started with SQL Server 2008 Failover Clustering > Failover Clustering How-to Topics > |
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 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 fail over 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
Tasks
How to: Read a SQL Server 2008 Setup Log FileConcepts
Failover Cluster TroubleshootingHow to: View SQL Server 2008 Setup Log Files
Other Resources
How to: Rebuild the Master Database for SQL Server 2005How to: Rebuild the Registry for SQL Server 2005