Query on cluster

Question

Hi All,

I have a Failover Cluster Manager setup with two nodes (let's say Server01 and Server02), both running Windows Server 2019. Both nodes are part of an Always On Availability SQL cluster. I want to remove Server02 from the Failover Cluster Manager.

Our database team has migrated all databases from Server02, but they have not uninstalled SQL. If I need to remove Server02 from the Failover Cluster Manager, will it be sufficient to right-click on Server02, select More Actions, and then choose Evict?

Answer 1

Hi Glenn Maxwell,

Thanks for your post. Yes, you can evict the node after you migrate all the resources to the another node. Here is the evict command. You can also try to evict from the UI as you mentioned.

Reference: Remove-ClusterNode (FailoverClusters) | Microsoft Learn

Best Regards,

Ian Xue

---

If the Answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hello @Glenn Maxwell

Most important step you must follow before removing the node from Failover Cluster Manager is basically to remove the replica from the Availability Group in SQL Server Management Studio. After that you can remove it from the cluster  

Remove a Secondary Replica from an Availability Group (SQL Server)

Regards

Javier