SQL server cluster suggestions

S_NO 21 Reputation points
2022-05-11T19:06:26.523+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,144 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Tom Phillips 17,741 Reputation points
    2022-05-11T20:20:49.923+00:00
    0 comments No comments

  2. Seeya Xi-MSFT 16,476 Reputation points
    2022-05-12T08:59:26.713+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.