SQL Server 2008 R2 on same server with SQL Server 2000 and SQL Server 2008

  • Hi *all

    We have an 32 bit installation with SQL Server 2000 and SQL Server 2008 Enterprise Edition.

    All is running fine since years.

    This SQLServer does not contain any production data. We just use it for development (ETL, OLAP).

    My question:

    Do we run into problems if SQL Server 2008 Enterprise Edition R2 is installed on the same server as another instance ?

    Maybe somebody already installed something similar.

    A virtual server is not an option because this server will be replaced next year.

    Thank You for any help.

    Regards,

    Marc

  • Can you do this? Yes, you can. Since it's only a dev server it shouldn't be too large a problem, but you really do have three things that don't like to share memory or cpu, all running on the same machine. But it'll work. I've had all four of the SQL Server versions running on a desktop. None of them run well, but they all run.

    "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

  • Thank you

    Most of the time only 1 instance is running. So memory and cpu is not a problem.

    Regards,

    Marc

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

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