Remove a crash SQL Cluster Node and add new SQL Cluster Node back to exist SQL Cluster


To recover from a failover cluster hardware failure

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

  當節點1發生問題時,SQL Server會failover到節點2

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




3.Verify that Node 1 has been evicted from the cluster definition.


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

  重新安裝一台新的SQL Server

5.Using the Cluster Administrator, configure Microsoft Cluster Server (MSCS) to add Node 1 to the existing cluster. For more information, see How to: View and Read SQL Server Setup Log Files.
  使用容錯移轉叢集管理員將SQL2K8R2C2(新的SQL Server也可以使用別的主機名稱)重新加入原來的叢集

  相關步驟可以這篇 Add a node to an existing two-node SQL Server 2008 R2 Cluster





6.Run SQL Server Setup to add Node 1 to the failover cluster.

  同樣相關步驟可以這篇 Add a node to an existing two-node SQL Server 2008 R2 Cluster





How to: Recover from Failover Cluster Failure in Scenario 1

Failover Cluster Troubleshooting

Comments (0)

Skip to main content