Re: Evict cluster node BEFORE running SQL setup

Yes. This scenario is documented in BOL under the index topic Failover
Clustering, recovering from a failover clustering failure. Your situation
fits into scenario 1. You will likely get a lot of errors when you remove
the failed node, but that is normal. The SQL installer is trying to update
that node and it cannot. When you are done, you should see only one node
allowed for the SQL resource group in the Cluster Administrator tool.

If you reuse the server name and IP address, make sure and clean it out of
Active Directory before you attempt to add the rebuilt node back to the
domain. I have seen some wierd behavior because of "tombstoned" entries in
AD.

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




"Staffy" <staffy@xxxxxxxxxxxxxxx> wrote in message
news:8C1A95E1-C554-4951-9065-4A0DDA32EAF6@xxxxxxxxxxxxxxxx
Have a two node SQL cluster. Node one has failed and has been evicted from
the cluster i.e. before running the SQL setup and removing the failed node
from SQL and cleaniing the SQL binaries.

What would the best way to proceed?
Can the SQL setup be run after the node has been evicted?

(The intent here is to rebuild the failed node and rejoin the cluster).

Thanks
--
Staffy


.

Relevant Pages

  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Newbie - SAN Advice
    ... Senior SQL Infrastructure Consultant ... SAN/Smart array or through a fibre channel switch. ... The SAN or Smart array will dictate what internal connection the disks ... single-instance cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... You could make a test environnement through Virtual Machine to get a picture on Cluster. ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL server 2005 SP2 failing on cluster
    ... We have been told for a long time that MSDTC is optional on a cluster but is all but required in the real world. ... I'm having problem to update my SQL cluster with SQL server 2005 SP2. ... Package Platform: x86 ... see Help and Support Center at ...
    (microsoft.public.sqlserver.clustering)
  • Re: Create SQL cluster on 2003
    ... Since you are in a cluster configuration, ... Microsoft SQL Server MVP ... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.clustering)