question

SNO-0014 avatar image
0 Votes"
SNO-0014 asked SeeyaXi-msft commented

SQL server cluster suggestions

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SNO-0014 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @SNO-0014,

Welcome to Microsoft Q&A!
Before you remove the node, you can remove the mirroring first: https://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.