Post reply

database upgrade

  • May 23, 2012 at 3:59 pm

    #392331

    I would like to know when is the upgrade of databases really happen?

    For example, I am migrating a database from SQL server 2005 to a new server that has SQl server 2008 R2 installed, does the database upgrade process happen when I restore the database?

    The reason I ask this is there is another option to move the database, that is to Attach databases with the files, -- if we copy over the .mdf and .ldf files to the new server, and attach them, does this process do the upgrade of databases too?

    Thanks,

  • May 23, 2012 at 4:14 pm

    #1492183

    Yes and Yes. When you restore or attach a database from a lower version, the database is upgraded at that time.

  • May 23, 2012 at 4:16 pm

    #1492184

    Thanks!

  • May 29, 2012 at 9:50 am

    #1494255

    What exactly are you referring to as "upgraded?" For example, when I restore a 2005 database to 2008, it will have a compatibility of 90 (2005) unless I change it.

    Jared
    CE - Microsoft

  • May 29, 2012 at 9:57 am

    #1494257

    SQLKnowItAll (5/29/2012)

    What exactly are you referring to as "upgraded?" For example, when I restore a 2005 database to 2008, it will have a compatibility of 90 (2005) unless I change it.

    It'll have a compat level of 90, but it will in every way be a 2008 database, the database structure is upgraded to 2008 when the DB is attached or restored to 2008.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 5 (of 5 total)

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