SQL server cluster suggestions

Question

Hi All

I have 8 nodes(each 4 one DC and other 4 are differnt DC)... each nodes has sql instance like primary mirroring at one DC it's corresponding node have mirroring in other DC.

we are going to do decomission one of the nodes on each DC..so that node has SQL in it(i,e A node has sql(principle) its corresponding has B node mirror)..even we no need SQL there.

so what would be the proper way to remove the node from cluster and how to deal with SQL and before removing node..

do we need to remove mirroring ,can we do directly remove node from cluster ...how should I ensure proper steps followed and it shouldnt affect other nodes in the cluster.

can someone suggest on this.

SQL 2016 latest sp.
win 2008R2

Answer 1

See:

https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/install/add-or-remove-nodes-in-a-sql-server-failover-cluster-setup?view=sql-server-ver15#Remove

Answer 2

Hi @S_NO ,

Welcome to Microsoft Q&A!
Before you remove the node, you can remove the mirroring first: https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/remove-database-mirroring-sql-server?view=sql-server-ver15

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.