Post reply

SQL server 2008 and SQL server 2005 on same box

  • July 23, 2009 at 8:13 am

    #132120

    Hi,

    What are the disadvantages of having SQL server 2008(instance) and SQL server 2005(instance) on the same box?

    Like performance, resource usage,....

    -Vikas Bindra

  • July 23, 2009 at 8:44 am

    #1029015

    You can only have one Integration Services server and only one default server.

    CEWII

  • July 23, 2009 at 9:24 am

    #1029056

    Is this production?

    As mentioned if you want SSIS, it will be only one version. A couple other services are not instance aware.

    Otherwise, same issues as any other multi instance box. It's possible that an 2008 patch could cause you issues with 2005, mostly with tools, and I'm not 100% sure this is well tested by MS.

  • July 23, 2009 at 9:53 am

    #1029091

    Thanks Steve!

    No, this is a dev box.

    As we are short of hardware, we just wanted to run some test on same server [:)].

    -Vikas Bindra

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

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