A Node Recovery
Using the same SQL Server clustering example (two-node cluster of COLTST1 and COLTST3), if any failure is caused by a hardware problem on one of the nodes (for example, if COLTST1 has a bad SCSI card) then you will want to use the following simple procedures to resolve this issue:
1. | After COLTST1 (the active node) fails, SQL Server 2000 should automatically fail-over to COLTST3 (the passive node). |
2. | Once you have determined that there is a hardware problem on COLTST1, you should run SQL Server Setup and remove COLTST1 from the SQL Cluster. |
3. | From Cluster Administrator, “evict” COLTST1 from MSCS (the cluster group). |
4. | Now, you can install new hardware to replace the failed hardware on COLTST1 and bring it back up. |
5. | Run MSCS ... |
Get Microsoft® SQL Server High Availability now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.