SQL 2005 & SQL 2008 on the same server

  • Hi.

    We have current currently several SQL 2005 Enterprise instances in a 2-node Windows cluster.

    We plan to install SQL 2008 Enterprise on the same cluster.

    Are there any limitations, conflicts on having clustered SQL 2005 & SQL 2008 instances sharing the same servers ?

    Are any pitfalls ?

    Thank you for your advice.

    Serge Vedrine

  • As long as you set the max memory for each instance so that you are not consuming all of the available memory and you have enough resources to support multiple instances, there really shouldn't be any problems.

    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

  • Hi Serge,

    We can very well install Different Editions/versions of SQL Server on a single machine or cluster machine. Like in our case SQL 2005 & SQL 2008. Now the thing that we need to take care are:

    We should have enough memory to support both of the versions and

    best is to Cap Max/Min Server memory for both of the instances

    and leave good amount of memory for OS as well.

    We should have good amount of resources on the server so that it can

    handle both of the editions.

    Regards

    GURSETHI

  • I assume you would just create a separate folder for the 2008 version? Anything tricky about this install (i.e., pitfalls to watch for)?

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

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