Remove node from 2005 cluster instance

• Leonard Rutkowski

  SSCrazy

  Points: 2668

  More actions

  May 26, 2016 at 7:12 am

  #149276

  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

• Joie Andrew

  One Orange Chip

  Points: 27360

  More actions

  May 26, 2016 at 5:46 pm

  #1881731

  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"

• Leonard Rutkowski

  SSCrazy

  Points: 2668

  More actions

  May 31, 2016 at 11:26 am

  #1882223

  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

• Joie Andrew

  One Orange Chip

  Points: 27360

  More actions

  May 31, 2016 at 1:52 pm

  #1882266

  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"