<< Interested in Speaking at a Code Camp? | Home | Richmond Code Camp >>

SQL 2000 and SQL 2005 clustered together...can it be done?

And equally important - is it recommended?

Has anyone else out there successfully clustered SQL 2000/2005 together?

I've seen stuff out there that says it works and other stuff that says it doesn't. I'm actually about to scrape up some hardware to try it out because the topic came up at work, just wanted some additional insight before making that plunge.

The end result we're after is to have an Active/Passive Windows 2003 cluster that has a SQL 2000 instance and a SQL 2005 instance on it...more to come as I explore this further.

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Print | posted on Wednesday, October 03, 2007 10:33 AM

Comments on this post

# re: SQL 2000 and SQL 2005 clustered together...can it be done?

Requesting Gravatar...
Sure, you could have two separate instances running. It's the same idea as having two instances running on a standalone system. Of course both (all) nodes need to have the exact same configuration, service pack level for the instances, etc.
Left by Lorin Thwaits on Oct 03, 2007 6:14 PM

# re: SQL 2000 and SQL 2005 clustered together...can it be done?

Requesting Gravatar...
Hi

Can some one provide me documentations of how to achive this.

thanks JOHN
Left by John P on Nov 07, 2007 9:57 AM

# re: SQL 2000 and SQL 2005 clustered together...can it be done?

Requesting Gravatar...
How to: SQL 2000 and SQL 2005 clustered together
Left by chris on Nov 07, 2007 10:35 AM

# re: SQL 2000 and SQL 2005 clustered together...can it be done?

Requesting Gravatar...
John - I haven't gotten around to this project yet but I'll be glad to document it once I do complete it.
Left by Lou on Dec 07, 2007 10:37 PM

Your comment:

 (will show your gravatar)