September 25, 2009 at 8:13 am
Hello,
We are currently using a MSCS having two SQL Server 2000 instances. We would
like to upgrade to 2008, but unfortunatly, our CRM application needs to
remain with 2005.
So we would like to upgrade the OLTP database to 2005, and the OLAP to 2008.
Is it possible to have a MSCS with both versions, and switching nodes
without issue ?
Thanks for you advice on this,
Regards,
Vincent
September 25, 2009 at 12:37 pm
I just checked with our systems guys, they say it's possible, but they've never done it and don't recommend it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 28, 2009 at 8:37 am
You may want to see this thread about some possible issues in such mixed cluster:
http://www.sqlservercentral.com/Forums/Topic271610-146-1.aspx
In your situation it would be easier to upgrade both nodes to SS2008, but leave your OLTP database in compatibility level 90 instead of 100. So, your database will work as a pure SS2005 database.
Cluster failover will also work properly in this case.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply