You are a database administrator for Contoso, Ltd. You configure a Microsoft SQL Server failover cluster with four nodes by using Windows Server 2012 R2
Datacenter Edition and SQL Server 2016 Enterprise edition.
A server in the datacenter needs to be replaced. The server is part of the SQL Server Failover Instance (FCI).
You need to remove the FCI node for the server that will be replaced.
What should you do?
A. Evict the node from Failover Cluster Manager.
B. Run the Remove-ClusterResource Windows PowerShell cmdlet.
C. Run the Remove-Cluster Windows PowerShell cmdlet.
D. Remove the shared storage from Failover Cluster Manager.
Correct Answer: A
Explanation/Reference:
Recover from an irreparable failure
Use the following steps to recover from an irreparable failure. The failure could be caused, for example, by the failure of a disk controller or the operating system.
In this case, failure is caused by hardware failure in Node 1 of a two-node cluster.
1. After Node 1 fails, the SQL Server FCI fails over to Node 2.
2. Evict Node 1 from the FCI. To do this, from Node 2, open the Failover Cluster Manager snap-in, right-click Node1, click Move Actions, 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.
5. Using the Failover Cluster Manager snap-in, add Node 1 to the existing cluster. For more information, see Before Installing Failover Clustering.
6. Ensure that the administrator accounts are the same on all cluster nodes.
7. Run SQL Server Setup to add Node 1 to the FCI. For more information, see Add or Remove Nodes in a SQL Server Failover Cluster (Setup).
References: https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/recover-from-failover-cluster-instance-failure
