Re: Cluster Failure Server Reboots

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 10:40:45 -0500

Event logs are your friend. Find out why the cluster service was unable to
move the resources and start the groups. You will need to examine the
system and application logs on both nodes and compare timestamps and event
sequences. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:e79f01c40bce$fc204bc0$a501280a@phx.gbl...
>
> I have a Windows 2000 Advanced Server with a
> Active/Active cluster with SQL Server 2000 Enterprise
> Edition SP3.  I had the Cluster server fail last night
> and reboot.  How could I analyze what cause the server
> failure not to move over to the other Active node?
>
> Please help me with this problem.
>
> Thanks,
>
> Mike

Relevant Pages

  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: active/passive with multiple instances
    ... An Active/Passive cluster is always called that and never Passive/Active. ... There is only 1 SQL Server per instance:) Just so other don't get confused. ... It does matter about the hardware, to achieve true HA it needs to happen at ... a SQL Server DBA plain and simply doesn't care about it being ...
    (microsoft.public.sqlserver.clustering)
  • Re: High Availability
    ... The cluster uses heartbeat to detect whether a node is alive or not responding. ... You may want to research SQL Server Replication/ Log Shipping if you can have some latency. ... Typical Uses of Replication ... Introducing New Features in Microsoft SQL Server 2000 Transactional Replication ...
    (microsoft.public.sqlserver.clustering)
  • Re: Bad startup parameter on clustered instance
    ... you shouldn't directly edit the registry entries of a cluster-aware ... SQL Server resource to keep failing the startup. ... This is because the cluster service checkpoints its changes and basically ... Check the registry entries for the startup parameters on the node to make ...
    (microsoft.public.sqlserver.clustering)