Re: SQL 2005 cluster need to rebuild each node - Evict node?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Basically, for SS2K5 is similar to SS2K except you use the Add /Remove
Programs Control Panel applet instead of the Setup media.

1. Remove the node from the SQL Server definition (you must complete this
step first or risk corruption).
2. Evict the node from the Cluster membership.
3. Rebuild/Repair evicted node.
4. Add node as a cluster member server.
5. Run Add/Remove Programs and add node as a SQL Server possible owner.
6. Reapply patches and hotfixes.

Here are both documents:

Original SS2K:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

Updated SS2K5:
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

Sincerely,


Anthony Thomas


--

"decipher" <decipher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7650C43F-2862-42DC-8F67-2FB654D2F31B@xxxxxxxxxxxxxxxx
Hello,

I have started working for a new company and they have a SQl 2005 64 bit 2
node cluster running on server 2003 enterprise x64. I was applying some
disk
firmware and noticed that the server was not setup with a raid for the OS
partitian. Upon further investigation I noticed that there wasnt even a
hardware raid card installed on the server. I have since setup a software
raid and ordered the correct hardware raid card. I would like to rebuilld
each node of the cluster with a hardware raid. I am a little unsure of
the
steps that I need to take and I would appreciate any advice.

1. Can I use the evict node feature within cluster administrator to evict
the second node, rebuild that node and then join it back to the cluster?
Can
I use SQL server setup to join the node back to the cluster?

2. Is there an easier way? Rather than evict the node I was thinking
that
I could ghost the OS, install the raid card and configure, apply ghost
image,
then run a windows repair install.

Does anyone have some real world advice that they can add?

Thanks very much.


.

Relevant Pages

  • Re: Cluster node removal steps with HP SAN
    ... the first evicted server will be formated and rebuilt with 2003 r2. ... then you need to run a "cluster /forcecleanup" on the ... I have never done this so I do not know but can you evict a node if the ... I remove the SAN disk from this node? ...
    (microsoft.public.windows.server.clustering)
  • Re: Cluster node removal steps with HP SAN
    ... san disks to the new win2003 server had issues. ... node from the cluster registry from the remaining node. ... service is running on say node 2, you cannot evict node 2, from any node. ... uninstall the cluster service before you powered down it would try and join ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL 2005 cluster need to rebuild each node - Evict node?
    ... Microsoft SQL Server MVP ... node cluster running on server 2003 enterprise x64. ... raid and ordered the correct hardware raid card. ... Can I use the evict node feature within cluster administrator to evict ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster node failure (Windows 2000 Advanced Server)
    ... Windows 2000 was limited to 2 nodes, so you will have to evict a node. ... You can't mix 32 & 64 bit in the same cluster, in case that was your R2 plan. ... I have a Windows 2000 Advanced server cluster with 2 nodes. ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... Windows Server 2008 Readiness Team ... cluster on a separate DLink card in multicast mode. ... I thought that the litmus test was that the router functions fine ... member of the NLB cluster, setup NLB on it, plug the NICs ...
    (microsoft.public.windows.server.clustering)