instances of sql2005 and sql2008 on same cluster?

  • hi all,

    i know it is possible to have multiple instances on a single cluster. do those instances all have to be the same version? ie can i have instances of sql2005 and sql2008 on the same cluster? is it supported?

    if yes, are there any particular gotchas? or better, does anyone know of articles on this?

    thanks

    rob

  • Yes, it is possible - and you have basically the same issues that you would with multiple instances on a single machine. Namely, you need to make sure you allocate your resources appropriately. If you failover, you want to have enough resources on a single node to handle all of the instances that would failover to that node.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • As indicated, it's really no different than multiple instances of the same version of SQL Server on a cluster. You still have to make the appropriate plans for resources. Where things can get a little more complicated is SQL Server Integration Services because of the pathing. But this is no different than having SSIS 2005 and SSIS 2008 installed together on the same non-clustered box.

    K. Brian Kelley
    @kbriankelley

  • K. Brian Kelley (8/10/2009)


    As indicated, it's really no different than multiple instances of the same version of SQL Server on a cluster. You still have to make the appropriate plans for resources. Where things can get a little more complicated is SQL Server Integration Services because of the pathing. But this is no different than having SSIS 2005 and SSIS 2008 installed together on the same non-clustered box.

    Now, I was not aware that you could have SSIS 2005 and 2008 installed on the same machine. Do you have a reference available that outlines how that can be accomplished?

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Katmai - Custom components and upgrade

    The Key SQL Server 2008 BI Migration: DTS to SSIS 2008, Part 2 of 2[/url]

    Trash Destination Adapter

    K. Brian Kelley
    @kbriankelley

  • Thanks for the links - not sure where in there it talks about side-by-side installation, but I will review it in more detail when I have some time.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Jeffrey Williams (8/10/2009)


    Thanks for the links - not sure where in there it talks about side-by-side installation, but I will review it in more detail when I have some time.

    The first one (Katmai...) talks about ensuring that SSIS 2008 was written so it could be side-by-side. Unlike other services, such as the SQL Active Directory Helper Service and SQL Server Browser, it actually creates a separate, new service for SSIS 2008. The one issue we've seen is knowing what SSIS version a package was created with and executing the correct version of dtexec since we tend to run packages as part of larger batch jobs.

    K. Brian Kelley
    @kbriankelley

Viewing 7 posts - 1 through 7 (of 7 total)

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