none
SQL Server Database version vs. SQL Server Installed Version

    Question

  • If we upgrade SQL Server from 2005 to 2008R2, do the databases themselves need to be upgraded to the new SQL Server 2008R2 format ?

    I seem to recall there also needs to be an actual upgrade process on the database themselves to bring them up to the newer version.

    Select @@version shows the current SQL Server Installed Instance. Is there a similar command to show what version the actual MDB format is of the actual database?


    John

    Thursday, June 20, 2013 4:03 PM

Answers

  • If we upgrade SQL Server from 2005 to 2008R2, do the databases themselves need to be upgraded to the new SQL Server 2008R2 format ?

    Hello John,

    No, the database will be automatically upgraded to the new version/database format, but it will run in compatibility level = 2005, you have to change it manually to 2008R2; see View or Change the Compatibility Level of a Database


    Olaf Helper

    Blog Xing

    • Marked as answer by vsla Thursday, June 20, 2013 4:19 PM
    Thursday, June 20, 2013 4:15 PM