Post reply

SQL 2012 Database in SQL 2005 compatibility mode

  • May 12, 2014 at 8:21 am

    #396736

    I know you can't restore a database which is SQL 2012 compatibility mode to a SQL 2005 instance, but if the database has always been kept in 2005 compatibility mode on a SQL 2012 instance, can this be restored back to a SQL 2005 instance?

  • May 12, 2014 at 8:33 am

    #1712696

    Nope. The page headers have already been updated. The compatibility level only affects what features are available in the database.

  • May 12, 2014 at 8:33 am

    #1712697

    Nothing whatsoever to do with compatibility level.

    You cannot restore down-version. A SQL 2012 database (a database attached to a 2012 instance) cannot be restored to anything other than SQL Server 2012 or SQL Server 2014.

    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

  • May 12, 2014 at 8:52 am

    #1712715

    Thats what I thought - Cheers

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

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