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.
-
When there is no instance on Node 2, does it become an Active Passive cluster?
-
Do I have to take the node offline before the uninstall?
-
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.
-
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?
-
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
Best Answer
Let me start by saying there is nothing like
Active-Active
cluster a more correct term which should be used ismulti-instance cluster
. When you have single instance of cluster it would simply be called assingle instance failover cluster
or justfailover 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.No, you do not have to take node offline.
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).
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.Yep correct.