Re: Damaged Cluster Node

Unfortunately, the answer is yes.

The SQL 2000 SP4 installer is a cluster-wide installer and will re-apply the SP to all nodes. SQL 2008 introduced rolling upgrades and single-node patching.

Just like the first time, you will incur downtime.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"Randy" <Randy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:B7440A3C-01DF-4D24-B74B-BA8DDBC98D4E@xxxxxxxxxxxxxxxx
Thanks. If SP4 was already applied cluster-wide, do I need to re-apply it
after adding a new node? Does it require downtime on the active node if it
already has SP4?

"Geoff N. Hiten" wrote:

Yes. You must either remove the node or repair it. I recommend removing it
from both SQL(via the installer) and the cluster. Note that these are
separate steps. You can then run the installer to add the RTM bits to the
new node.

You have to apply SP4 cluster-wide. The installer doesn't do individual
nodes.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Randy" <Randy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7466A343-D1DA-47A6-9243-8020DE56A509@xxxxxxxxxxxxxxxx
> 1) We have a two node SQL Server 2000 SP4 Ent on Windows 2003 Ent SP2
> failover cluster. One of the nodes is not available and we are trying > to
> add
> a node to replace it. We added a third node to the windows cluster, > but I
> get an error when running the SQL install on that node.
>
> "One (or more) of the nodes of the NT cluster are unavailable. Setup > will
> continue and allow you to modify the virtual server to remove the > offline
> nodes. Once complete you will be able to perform the normal setup on > the
> clustered instances."
>
> Does this mean we must either repair the damaged node or remove it > before
> we
> can add the new node?
>
> 2) If the node is added, do I need to apply SP4 directly on the new > node?
>
> Thanks, Randy



.

Relevant Pages

  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding 3 nodes to a cluster
    ... First you use the cluster admin tool to add the machines as nodes to the cluster. ... Then you run the SQL installer to install binaries on the newly added nodes and allow the new nodes to host the existing instances. ... >>>I need to add these new servers as seperate instances in the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: Setup Failed to Perform Reqd operations on CLuster Nodes
    ... Windows Client network tools. ... then you cannot build a SQL cluster. ... SQL Installer relies on this functionality to copy installation files to ...
    (microsoft.public.sqlserver.clustering)
  • Re: applying SQL patch
    ... SQL hotfixes are cluster-aware, just like a SQL service pack. ... You must start the hotfix installer from the node that currently ... You may have to reboot the cluster host nodes ...
    (microsoft.public.sqlserver.clustering)
  • Re: SP4 install problem on Win2003Ent-cluster when adding new node
    ... I was trying to add a new node to the cluster, SP4 would not install. ... I understood you failed to upgrade to SQL Server ...
    (microsoft.public.sqlserver.setup)