SQL Server clustering 2008 and 2005

Question

question

H Singh asked Jan 7, '10

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

2

10 |1200

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

Mark Allison commented · Jan 08, 2010 at 06:16 AM

What version of windows?

0 ·

H Singh commented · Jan 08, 2010 at 12:21 PM

windows server 2003 R2 64 bt

0 ·

Answer 1 · 2010-01-07T18:33:49Z

KenJ answered Jan 7, '10

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

This SQLServerCentral forum discussion covers some details.

2

10 |1200

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

H Singh commented · Jan 08, 2010 at 01:58 PM

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 ·

KenJ commented · Jan 11, 2010 at 03:46 PM

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 ·

Answer 2 · 2010-01-11T06:51:39Z

Steinar answered Jan 11, '10

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

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

question