May 26, 2016 at 7:12 am
Hi,
I am attempting to remove an instance of 2005, from a cluster. I have googled around, and found several articles, but I can't find anything specific, so I am hoping someone here can help. I am just trying to get the instructions, before I attempt the removal.
My questions are:
1. Do I do this from the control panel, Uninstall program, select 2005, and pick the change option, or the remove option? Or do I have to run the setup program?
2. I assume I have to do this from the active node. That's how the 2005 add node is done.
I first one to remove the passive nodes. It is a 3 node cluster, and there are other instances, not 2005, on the same cluster. Do I do it this way?
3. Once all of the passive nodes are removed, I then want to remove the active node. Same option, remove node?
4. Is a reboot required, on any of the nodes, once the removal has taken place? The change option, checks to see if any of the clusters need a reboot, and warn you, accordingly, but after the nodes are removed, from the passive or the active, is a restart necessary?
Just trying to get my ducks in a row, before I attempt the removal. The other instances are in use, so I am trying to avoid any downtime or mistakes on my part.
Thanks,
Leonard Rutkowski
May 26, 2016 at 5:46 pm
I would take a look here first:
How to: Add or Remove Nodes in a SQL Server 2005 Failover Cluster (Setup)
https://msdn.microsoft.com/en-us/library/ms191545(v=sql.90).aspx
How to: Remove a SQL Server 2005 Failover Clustered Instance (Setup)
https://msdn.microsoft.com/en-us/library/ms190438(v=sql.90).aspx
(Hopefully this is not required, but just in case)
How to: Manually Uninstall a SQL Server 2005 Failover Cluster
https://msdn.microsoft.com/en-us/library/ms180973(v=sql.90).aspx
Joie Andrew
"Since 1982"
May 31, 2016 at 11:26 am
Thanks Joie.
Yes, I had already read those links, and unfortunately, they didn't answer my questions.
I will keep digging, or maybe just try it and see what happens.
Leonard
May 31, 2016 at 1:52 pm
If I were you I would set this up in a lab so you can get your procedures down and practice this before trying it on a live system.
Joie Andrew
"Since 1982"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply