SQL Server 2005 side-by-side on cluster with SQL Server 2000

SQL Server 2005 side-by-side on cluster with SQL Server 2000

Post by UGF2YW5BbG » Thu, 29 Sep 2005 20:38:04


Hi,

We are using an Active-Passive cluster environment in our project. So far,
we made use of only one instance of SQL Server. i.e SQL Server 2000. New
architectural change is introduced in the current version of the project. We
will have two instances of Database server. One is of SQL Server 2000 and
another is of SQL Server 2005. Tests were successful when we tried this on
single machine. We would like to know how it works on clustered environment.

I want to have an environment where SQL Server 2000 & SQL Server 2005
databases co-exist on an active-passive SQL cluster. I have installed SQL
Server 2005 on cluster. After this, I was trying to install SQL Server 2000
on cluster. The following error message was prompted

he specified virtual server cannot be maintained by this version of setup.
Earlier when we were having SQL Server 2000 Cluster and we were trying to
install SQL Server 2005 on same cluster, the Cluster group was not appearing
in the installer.

Please suggest me an approach for preparing this environment.


Thanks in advance
 
 
 

SQL Server 2005 side-by-side on cluster with SQL Server 2000

Post by SQL M » Thu, 29 Sep 2005 23:50:00

Hi

SQL Server 2005 is still in beta therefore it is not supported for
production use.

SQL Server versions always have to be installed in the order they were
released. SQL Server 2000 before SQL Server 2005.

You need to have each instance with it's own resource groups, in effect, you
have to create a multi instance cluster (active-active in outdated
terminology).

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: XXXX@XXXXX.COM

MVP Program: http://www.yqcomputer.com/

Blog: http://www.yqcomputer.com/

 
 
 

SQL Server 2005 side-by-side on cluster with SQL Server 2000

Post by Geoff N. H » Fri, 30 Sep 2005 00:07:36

I have a working test cluster with SQL 2000 and SQL 2005 using Virtual
Server. So far I have found no show stoppers using the September CTP
release. I am still very early in my testing so don't take this as an
absolute guarantee.

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
 
 
 

SQL Server 2005 side-by-side on cluster with SQL Server 2000

Post by Anthony Th » Mon, 03 Oct 2005 06:38:58

Also, since each Virtual SQL Server instance has a seperate dedicated set of
binaries, disks, IPs, and Names, the two can run side-by-side,
independently. However, there are upgrades to the Hosts due to the
installation of SS2K5, which may interfere with your SS2K installation, most
notebly, the .NET framework.

Moreover, there are only one set of client tools, but in a mixed enironment,
there would be a set for each version. Absolutely, there is an effect of
the SS2K5 tools on the SS2K tools.

In the past, the recommendation has been that side-by-side installations,
clustered or otherwise, is typically as an upgrade option only. You could
merely upgrade you SS2K instance to SS2K5, but I tend to like clean
installs. The side-by-side option allows you to do this, run each version
for a time being until you get everything off of your SS2K instance, then
uninstall it.

Sincerely,


Anthony Thomas


--



I have a working test cluster with SQL 2000 and SQL 2005 using Virtual
Server. So far I have found no show stoppers using the September CTP
release. I am still very early in my testing so don't take this as an
absolute guarantee.

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP