Stop/ Start Clustering Service...unusual behaviour ? -- sql server clustering

PK via SQLMonster.com
3/3/2005 1:30:02 AM

Hi Everyone,

I have an Active/Avtive 2 node cluster running WIN 2003 with SQL Server
2000 (SP3a).

Over the last couple of days i have been experimenting with it and have
noticed the following behaviour and was wondering whether it was normal.

When all resourses are running on NODE2 (including quorum, cluster name and
cluster ip ) and i right click NODE 1 in Cluster administration and choose
"Stop Cluster Service", NODE 1 becomes inactive with a red cross. I thought
this is normal behaviour...

However, when all resourses are running on NODE1 and I "Stop Cluster
Service" on NODE2, the whole cluster shuts down with a warning message
along the lines of "cluster not available". At this time, i notice that
both NODE1 and NODE2 has blue icon next to it.

To me this behavious is unusual as NODE1 should still be able to service
request even though NODE2 has its cluster services turned off.

I really appreciate any feedback about this issue.

Kind Regrads,
PK

--

Mike Epprecht (SQL MVP)
3/3/2005 1:35:14 AM

Hi

If you "stop cluster service" on the node where the Cluster Group is
running, Windows has no other option than to shut the cluster down. First
move the Cluster Group resource to another node.

Regards
Mike

[quoted text, click to view]

John Toner [MVP]
3/3/2005 8:42:41 AM

Are you sure that all resources, including the cluster group resources, are
running on Node1? It sounds like maybe the cluster group was running on
Node2 at the time you stopped the service on Node2.

If that's the case, it might just be a GUI refresh issue. Check the cluster
service on Node1 and verify that it is still started. If so, your cluster is
still up and it's likely just a refresh issue.

Regards,
John

[quoted text, click to view]

Priyanga Karunathilake via SQLMonster.com
3/3/2005 8:21:45 PM

Hi

When i noticed the following case....i was logged into NODE2.

" However, when all resourses are running on NODE1 and I "Stop Cluster
Service" on NODE2, the whole cluster shuts down with a warning message
along the lines of "cluster not available". At this time, i notice that
both NODE1 and NODE2 has blue icon next to it. "

So, rightly, when Cluster Service was stopped on NODE2, it looked as if the
whole cluster was down, but when i logged into NODE1 and had a look at the
cluster, everything was running on NODE1 and NODE2 was down.

Thanks Everyone,

PK

--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Stop/ Start Clustering Service...unusual behaviour ?