Post reply

Cluster upgrade to SQL Server 2008 fails when SQL Server 2005 cluster nodes have different installed features

  • June 30, 2010 at 12:46 pm

    #223356

    Hi,

    Any body tested the scenario of performing in-place upgrade to SQL Server 2008 from SQL Server 2005 having different installed features of SQL Server 2005 on cluster nodes?

    http://support.microsoft.com/kb/955949

    According the above link, the upgrade should fail. But me, the upgrade did not fail and it is successful with NO issues.

    We have different SQL Server 2005 feature on cluster nodes.

    On one node we have database engine & SSIS and on another node just the database engine and NO SSIS.

    But the in-place upgrade is successful. Here my results contradicting the KB article.

    So could you please test this scenario of having different feature on cluster nodes and share your upgrade experience?

    Thanks

  • June 30, 2010 at 7:28 pm

    #1187419

    On one node we have database engine & SSIS and on another node just the database engine and NO SSIS.

    But the in-place upgrade is successful. Here my results contradicting the KB article

    Here in your case the upgrade is successful and the KB article will NOT apply for your case.

    Because SSIS is a shared feature and it's not specific to an instance. So even if you have SSIS on one node and NO SSIS on another node, then upgrade will NOT fail

    This issue is specifically applies to instance-specific features like Reporting Services, Analysis Services and Database Engine

    Thanks

  • July 1, 2010 at 10:48 am

    #1187793

    Thanks for the clarification.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply