Post reply

SQL Server 2008 instance running on the same server as a SQL Server 2005 instance

  • June 26, 2009 at 7:46 am

    #205863

    I have had a quick look around the web, and could not find anything regarding running two instances of SQL Server at different versions on the same server, one at 2005 and the other 2008...If anyone knows of any reason why this is not a good idea or any gotchas to look out for please let me know?

    Gethyn Elliswww.gethynellis.com

  • June 29, 2009 at 7:45 am

    #1016821

    I guess it would depend on if it is a production server and what the performance looks like with only one instance.

  • June 29, 2009 at 8:02 am

    #1016839

    It works fine, I've got servers at home running 2000, 2005 and 2008 instances side by side with no issues.

    They need to be installed in the right order though, lowest versions first. If you install a 2005 instance on a 2008 server, then it can cause you issues when it overwrites some dlls. Also if you subsequently uninstall one of the instances, it usually rips out shared dlls and breaks the other instances on the server.

    All in all, it is feasible, just take care 🙂

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

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