Post reply

Remove node from 2005 cluster instance

  • 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

  • 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"

  • 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

  • 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"

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply