question

Chris W Rea avatar image
Chris W Rea asked

Can a SQL Server 2005 or 2008 cluster be installed along-side an existing SQL Server 2000 cluster?

Consider a case where there is a pre-existing SQL Server 2000 Enterprise Edition 2-node cluster. Could a SQL Server 2005 or 2008 Standard be installed on the same cluster hardware, also in a clustered configuration? What are the constraints, limitations, caveats, and requirements for doing so? Thanks!

sql-server-2008sql-server-2005sql-server-2000clusterserver-instances
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

According to this white paper you can install 2000, 2005 and 2008 side by side in a cluster, as separate instances.

One caveat is that you must have SQL 2000 SP4 installed.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered

Yes it can. The constraints are that the SQL 2005 instance needs it's own Cluster IP and disk resources, so you set up a separate cluster group for the 2000 and 2005 instances. But they can share the same quorum, and obviously run on the same physical hardware.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.