Re: Node not behaving in cluster

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 08/13/04


Date: Fri, 13 Aug 2004 10:50:21 -0400

Did you follow the instructions in BOL under Maintaining a Failover Cluster
on how to replace a failed node? SQL can be very picky about changes to
underlying hardware. You may need to treat this as a failed node and
remove-replace it in SQL. Since the Cluster itself seems OK, you can
probably pick up and do just the SQL installation changes.

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mark Larma" <Mark Larma@discussions.microsoft.com> wrote in message
news:46CFE332-8DCD-43AA-AC9A-90AF481133FA@microsoft.com...
> We had to do a system swap on a system -- moved the drives and RAID
> controller to a new system (same type) and just hooked it all up and went
to
> town.  Well, this isn't working very well.  The drives (data and quorum)
fail
> over just fine, but NO other resources will.  Many of them say that only
the
> other node is a valid owner and we can't add this system as a possible
owner.
>  Some have both listed, but they won't start.  Any ideas?
>
> Mark


Relevant Pages

  • Re: one node crashed need to rebuild quick
    ... Look in BOL for step by step instructions on maintaining a failover SQL ... cluster, including how to remove and replace a failed node. ... This client did not have a good backup of the system state ...
    (microsoft.public.sqlserver.clustering)
  • Re: Evict, reinstall and rejoin a node without System State Backup
    ... You will need to run the SQL installer and remove the failed node from the ... SQL installation, ESPECIALLY if you are reusing the original node name. ... distinguish the maintenance of the clustered SQL instance from installing ...
    (microsoft.public.sqlserver.clustering)
  • Re: Stuck at Cluster Network Configuration Wizard
    ... It should ask for the SQL VIP. ... Network settings for this failover cluster). ... identify your failover cluster instance on the network. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Stuck at Cluster Network Configuration Wizard
    ... SQL setup can see the nics (they are listed on this screen under 'Specify ... Network settings for this failover cluster). ... Principal SQL Infrastructure Consultant ...
    (microsoft.public.sqlserver.clustering)
  • Re: select constant.field >> 10g float and double indicator
    ... > Mark C. Stock wrote: ... > I guess it uses some formatter which marks f as float. ... as BINARY_FLOAT and BINARY_DOUBLE data types in the 10g SQL Reference) ... instead of your original alias (of common usage but questionable etymology ...
    (comp.databases.oracle.misc)