How to recover from failover cluster failure in Scenario 1

SQL Server Setup Help

SQL Server Setup Help

How to recover from failover cluster failure in Scenario 1

In this scenario, failure is caused by hardware failure in Node 1 of a two-node cluster. This hardware failure could be caused, for example, by the failure of a small computer system interface (SCSI) card or the operating system.

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

  2. Run SQL Server Setup and remove Node 1. For more information, see How to remove a failover clustered instance .

  3. Evict Node 1 from Microsoft Cluster Service (MSCS). To evict a node from MSCS, from Node 2, right-click on the node to remove, and then click Evict Node.

  4. Install new hardware to replace the failed hardware in Node 1.

  5. Install the operating system. For more information about which operating system to install and specific instructions on how to do this, see Before Installing Failover Clustering.

  6. Install MSCS and join the existing cluster. For more information, see Before Installing Failover Clustering.

  7. Run the Setup program on Node 2 and add Node 1 back to the failover cluster. For more information, see How to add nodes to an existing virtual server (Setup).