We have a SQL 2000 SP3a Active/Passive cluster running on Windows 2003 SP2.
We had a failover yesterday. However only the SQL Group failed over, not
the Cluster group. I need to reboot the node that failed. Can I move the
Cluster Group without affecting the users?
Thank you in advance.

Yes.

Moving the cluster group will not affect any running applications, including
SQL.

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


"RobinMC" <RobinMC (AT) discussions (DOT) microsoft.com> wrote

Thank you very much for your response.

"Geoff N. Hiten" wrote:

I agree with Geoff, except that if the cluster group does not successfully
move for some reason, this can affect running applications on the node. If
the group owning the quorum does not successfully failover due to an issue
with the quorum device, it will likely cause the cluster service on this
node to shut down...which would cause groups owned by this node to failover
to the other available cluster nodes.

Of course, this situation is unlikely, but it is possible for this situation
to occur...trust me.

Regards,
John

Visit my blog: http://msmvps.com/blogs/jtoner


"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote

Agreed.

That usually happens when there is something fundamentally wrong with the
cluster.

Part of any acceptance testing for a cluster should be testing all group
failovers and making sure they complete successfully and don't affect any
other group.

Then again, we lost the ability to move the cluster group via the GUI in
Windows 2008. Command-line only. What were they thinking?

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




"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote

Agreed...just wanted to get it out there that they should still probably
plan a "cluster group" move during off hours, just in case.

Regards,
John

Visit my blog: http://msmvps.com/blogs/jtoner

"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote