1

I need some pointers to uninstalling 2 instances on SQL Server 2012 cluster

We have a SQL Server 2012 Active -Active cluster with instance A on Node 1 and Instance B, Instance C and 3 services on Node 2. I need to uninstall Instance A and B from Node 2. The services could be removed/disabled.So I will have an Active-Active cluster with Instance C on Node 1 and no instance on Node2.

I have never uninstalled an instance on a cluster and we don’t have any test system so I have a couple of questions.

  1. When there is no instance on Node 2, does it become an Active Passive cluster?

  2. Do I have to take the node offline before the uninstall?

  3. Can I get any links to uninstalling an instance? I have googled but have only come up with uninstalling nodes. I got This one that said about uninstalling an instance but at the end of it, uninstalled the node.

  4. Am I right in understanding that you need the installation media to uninstall the instance? And that I cannot use uninstall programme method for this?

  5. I have followed this link with a comment from Perry Whittle. So does it mean if I use the remove node option , it will remove only the instance BUT the node will still be there ?

I had initially disabled the 2 instances on the node ,thinking that would be a safer option but that gave rise to continuous alerts on our Nagios monitoring system and Operations got errors during the monthly patching.

Thanks

1

When there is no instance on Node 2, does it become an Active Passive cluster?

Let me start by saying there is nothing like Active-Active cluster a more correct term which should be used is multi-instance cluster. When you have single instance of cluster it would simply be called as single instance failover cluster or just failover cluster instance (FCI), people do call it active passive but that is not correct. An active-passive cluster can have 2 instance on one node and other node having no instance which makes it look like active passive but actually it is multi instance failover cluster.

Do I have to take the node offline before the uninstall?

No, you do not have to take node offline.

Can I get any links to uninstalling an instance?

It is in the same MSSQLTIPS link you have posted. And also note when you uninstall an instance you have to uninstall it from ALL nodes of the cluster. That is what the link says in line step 9. Please dont confuse by removing node and removing node from WSFC, its removing node from failover cluster instance(FCI).

Am I right in understanding that you need the installation media to uninstall the instance? And that I cannot use uninstall programme method for this?

When you are removing FCI from Windows server cluster you have to run the setup file and select remove node from failover cluster like shown in the links you are already referring. If you do not have FCI but standalone instance of SQL Server you can go to add remove program and select uninstall, this will uninstall the SQl Server.

So does it mean if I use the remove node option , it will remove only the instance BUT the node will still be there ?

Yep correct.

  • Shanky, thank you so much for such a detailed answer. I will go through the link and try to understand the steps gain. – mail_sady Jul 29 '18 at 9:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.