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
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@.noemail.noemail> wrote in message
news:8C1A95E1-C554-4951-9065-4A0DDA32EAF6@.microsoft.com...
> 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment