Seperate instances of SQL on differeng VM's -- sql server clustering

Cluster_Quest
4/25/2006 3:01:02 AM

I am being asked to migrate various SQL Databases, 2000 and 2005 to a single
large clustered enviroment.

I believe that you can install a single seperate instance of SQL 2000 on a
Virtual Machine (this is required as they each use differeing collation
sequences), however, can both SQL 2000 and 2005 run in the same clustered
enviroment on different virtual mahcines?

Thanks.....

Russ Kaufmann [MVP]
4/25/2006 9:23:13 AM

[quoted text, click to view]

You can run both instances in the same cluster. But why would you?

If your goal is to have a highly available SQL cluster with the best
performance and highest availability, that means you should be deploying SQL
2005. Migrate your 2000 databases to the new cluster after you have it up
and running.

--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

sql server clustering : Seperate instances of SQL on differeng VM's