Cluster issues on 2000

#31

logs are clean ?

and you have a "Cluster resource 'Disk Q:' failed" in the system event log ?

there must be something in the cluster.log file !

can you do the following:

- on node 2, disable cluster service
- on node 2, disable clusdisk.sys
- shutdown node 2
- on node 1, disable cluster service
- on node 1, disable clusdisk.sys
- reboot node 1
---> can you access your Q ?

- on node 1, enable cluster service
- on node 1, enable clusdisk.sys
- shutdown node 1
- powerup node 2
---> can you access your Q ?

- on node 2, enable cluster service
- on node 2, enable clusdisk.sys
- reboot node 2
---> does cluster service start ?
---> can you access Q ?

- powerup node 1
---> does cluster service start ?

- with cluster administrator: move the cluster group to node 1
---> does the group move to node 1 ?

- with cluster administrator: move the cluster group to node 2
---> does the group move to node 2 ?

and at each stage, if your answer is no to any of the questions, then stop,
and troubleshoot that first

HTH,
Edwin.

"Ross Mistry" <RossMistry (AT) hotmail (DOT) com> wrote

Quote:

I agree the lack of troubleshooting and diagnostics when building Windows
2000 clusters is horrendous. I have been spoiled for the past year as I
have only been building failover clusters with SQL Server 2008 on Windows
Server 2008.

Unfortunately, the customer I am working with needs to replace an old
cluster. They are forced to build the failover cluster with Windows 2000
and SQL Server 2000 as the 3rd party application running on top is only
certified to use this legacy platform.

Quorum and all the shared disks are available to all nodes within the
cluster. Everything appears to be fine, logs are clean.It has been ages
since I played with a 2000 cluster - I'll pluck away at it tomorrow and
see
what I come up with.

Thanks Geoff!!!

Ross

"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote in message
news:OczZ0Wv4IHA.784 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
One of the biggest weaknesses of Windows 2000 is that it let you build a
non-working cluster. Windows 2003 is better and 2008 is great.
Unfortunately without detailed access to the system and setup logs, I
cant
help a lot. It looks like the Q drive is not accessable from all nodes
and did not correctly form a clustered resource.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Ross Mistry" <RossMistry (AT) hotmail (DOT) com> wrote in message
news:u75QDJv4IHA.5052 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
I need to install SQL Server 2000 on a Windows 2000 cluster - Yes I know
how sad is that...

Anyhow, I have following the installation based on the white paper
below
to a T, however, I receive the following errors after I install Cluster
Services on the first first node - basically clustering service fails
to
start.

http://technet.microsoft.com/en-us/l.../bb727114.aspx

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7031
Date: 7/10/2008
Time: 4:54:33 PM
User: N/A
Computer: POSPOLLPRD1
Description:
The Cluster Service service terminated unexpectedly. It has done this
1
time(s). The following corrective action will be taken in 60000
milliseconds: Restart the service.

Event Type: Error
Event Source: ClusSvc
Event Category: (128)
Event ID: 1009
Date: 7/10/2008
Time: 4:54:31 PM
User: N/A
Computer: POSPOLLPRD1
Description:
The Clustering Service could not join an existing cluster and could not
form a new cluster. The Clustering Service has terminated.
Data:
0000: a4 13 00 00 ¤...

Event Type: Error
Event Source: ClusSvc
Event Category: Services
Event ID: 1069
Date: 7/10/2008
Time: 4:54:31 PM
User: N/A
Computer: POSPOLLPRD1
Description:
Cluster resource 'Disk Q:' failed.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Cluster issues on 2000

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: Cluster issues on 2000 - 07-11-2008 , 08:06 AM