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

I would try option 2, but be prepared for option 1 if it does not work.

Unfortunately, this is not something you can test will in a virtual or lab environment.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"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: SQL 2005 cluster need to rebuild each node - Evict node?
    ... Evict the node from the Cluster membership. ... Add node as a cluster member server. ... raid and ordered the correct hardware raid card. ...
    (microsoft.public.sqlserver.clustering)
  • 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: 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)