locked
SQL 2008 and SQL 2005 Express RRS feed

  • Question

  • Hello,

     

    Can I have SQL 2008 Server and SQL 2005 express run on a same Server? Obviously SQL2008 Server instance name is MSSQLSERVER and  SQL 2005 instance name is SQLEXPRESS.

    TIA


    Tom
    Thursday, January 19, 2012 7:16 PM

Answers

  • Tom

    Yes


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Peja Tao Friday, January 20, 2012 8:58 AM
    • Marked as answer by Peja Tao Wednesday, January 25, 2012 7:44 AM
    Thursday, January 19, 2012 7:18 PM
  • Hello,

    Please make sure to limit memory usage by the default instance using “max server memory’, to allow 1 GB of RAM for Express and some more GBs of RAM for the operating system. Try to balance memory across instances.

    Hope this helps.  

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Peja Tao Friday, January 20, 2012 8:58 AM
    • Marked as answer by Peja Tao Wednesday, January 25, 2012 7:44 AM
    Thursday, January 19, 2012 7:49 PM

All replies

  • Tom

    Yes


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Peja Tao Friday, January 20, 2012 8:58 AM
    • Marked as answer by Peja Tao Wednesday, January 25, 2012 7:44 AM
    Thursday, January 19, 2012 7:18 PM
  • Hello,

    Please make sure to limit memory usage by the default instance using “max server memory’, to allow 1 GB of RAM for Express and some more GBs of RAM for the operating system. Try to balance memory across instances.

    Hope this helps.  

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Peja Tao Friday, January 20, 2012 8:58 AM
    • Marked as answer by Peja Tao Wednesday, January 25, 2012 7:44 AM
    Thursday, January 19, 2012 7:49 PM
  • Hi,

    Yes you may have different instances of different servers.


    - Sekilha
    Thursday, January 26, 2012 9:15 AM