question

H Singh avatar image
H Singh asked

SQL Server clustering 2008 and 2005

Can SQL Server 2008 named clustered instance be installed along side an existing SQL Server 2005 default clustered instance on an active passive failover system. Do we need new quorum disk drive for new instance? What are the challenges faced during installation/maintenance?

sql-server-2008sql-server-2005cluster
2 comments
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.

What version of windows?
0 Likes 0 ·
windows server 2003 R2 64 bt
0 Likes 0 ·
KenJ avatar image
KenJ answered

I've always kept different versions on separate clusters, but it does appear to work.

This SQLServerCentral forum discussion covers some details.

2 comments
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.

thanks for your response. Here i am going to have sq2005 & sq2008 on same windows cluster. One sql2005 being default instance and new sql2008 instance as named instance. keeping saparate ressources -- do we need addd another quorum drive?
0 Likes 0 ·
No. As Steinar mentions, you will only have one quorum drive for the cluster. The quorum drive is for the Microsoft Cluster Service, which is independent of SQL Server.
0 Likes 0 ·
Steinar avatar image
Steinar answered

Hello. You do not need another quorum drive. However you need new disks for your new instance, as it cannot share with the other instance

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.