Post reply

Do we need to have same features installed on all cluster nodes?

  • June 15, 2010 at 12:31 pm

    #236453

    Hi,

    We have A/P Cluster setup for SQL Server 2005 and want to upgrade to SQL Server 2008 using in-place upgrade.

    To perform in-place upgrade to SQL Server 2008, Do we need to have same features installed on all cluster nodes? In my case I do NOT have Client Management tools & SSIS on Passive node & they exist only on Active node.

    So is my upgrade fails if we perform in-place upgrade to 2008? Please provide your inputs

    Thanx

  • June 15, 2010 at 5:39 pm

    #1180745

    You only need the client tools and SSIS on the passive node if, and only if, you think you might want to use them when the cluster has failed over to the passive node.;-)

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • June 15, 2010 at 5:50 pm

    #1180749

    You only need the client tools and SSIS on the passive node if, and only if, you think you might want to use them when the cluster has failed over to the passive node

    If we perform in-place upgrade from clustered SQL Server 2005 to 2008 with NOT having same features installed on all clustered node, then will the in-place upgrade continuous with out errors or it will fail?

    and I do not need SSIS on the passive node when the cluster has failed over to the passive node as we have just couple of packages which runs daily once only.

    If the upgrade MUST need same features on all instances, then I will install the tools & SSIS on passive node before performing in-place upgrade

    thanks

  • June 15, 2010 at 7:30 pm

    #1180754

    gmamata7 (6/15/2010)

    If we perform in-place upgrade from clustered SQL Server 2005 to 2008 with NOT having same features installed on all clustered node, then will the in-place upgrade continuous with out errors or it will fail?

    Not sure. Try it out in a test environment.

    and I do not need SSIS on the passive node when the cluster has failed over to the passive node as we have just couple of packages which runs daily once only.

    What if you have a hardware failure on the active node that requires you to be on the passive node > 1 day? IMO, you should install the client tools and SSIS on all nodes.

    If the upgrade MUST need same features on all instances, then I will install the tools & SSIS on passive node before performing in-place upgrade

    You can do this after the upgrade.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

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

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