Groups | Blog | Home
all groups > sql server clustering > march 2007 >

sql server clustering : SQL 2005 Upgrade


ctowndu33
3/22/2007 6:58:00 AM
We have a two node cluster with two groups on them (W2K3). Each group has a
sql 2k instance running and the groups each reside on a node, failing over to
the other if necessary. My question is that we were looking to upgrade, but
are only able to upgrade the one instance to 2K5. I assume this would break
our failover for the sql 2K cluster group since it would be on a node that
ctowndu33
3/22/2007 7:58:18 AM
When you upgrade the one instance, doesn't that upgrade the sql files on the
actual physical node so that when you fail the 2000 instance over, it will
not work? I guess my question is what files for sql reside on the physical
cluster node that would get upgraded that would inhibit a 2000 virtual group
from running on it. When upgrading to sql 2k5, does it only affect files
that are contained in the virtual group? Thanks in advance!

[quoted text, click to view]
Tom Moreau
3/22/2007 10:09:51 AM
You can upgrade one instance at a time. Thus, you can have one SQL2K
instance and another SQL2005 instance on the same cluster after the upgrade.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
[quoted text, click to view]
We have a two node cluster with two groups on them (W2K3). Each group has a
sql 2k instance running and the groups each reside on a node, failing over
to
the other if necessary. My question is that we were looking to upgrade, but
are only able to upgrade the one instance to 2K5. I assume this would break
our failover for the sql 2K cluster group since it would be on a node that
has been upgraded to 2K5?
ctowndu33
3/22/2007 10:35:24 AM

So from what this document says, we could no longer have the ability to
introduce SQL 2000 into the cluster? I don't think that is a problem, but
what if we need to restore a corrupt virtual group? If we can't restore the
entire thing, we wouldn't be able to rebuild a 2000 instance and then restore
databases, correct?

[quoted text, click to view]
Geoff N. Hiten
3/22/2007 11:06:54 AM
Each instance has its own set of binaries so each instance can be a
different version.

Binaries are updated cluster-wide for a specific instance during a SP,
hotfix, or version upgrade transparently during the install.

Here is the documentation on what is and is not supported in mixed-version
clusters:

The Microsoft SQL Server support policy for Microsoft Clustering
http://support.microsoft.com/kb/327518/en-us

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



[quoted text, click to view]
AddThis Social Bookmark Button