Post reply

COMPATIBILTY LEVELS AFTER UPGRADE

  • January 29, 2016 at 3:21 am

    #307504

    Hi

    I have just restored a db in compatibility mode 'SQL Server 2000(80)' (from a sql2005 box) to a SQL2012 box. The database is now at compatibility mode 'SQL Server 2005(90)'

    So it appears the compatibility mode has automatically been upgraded to the lowest possible on sql server 2012 - I was always under the impression this didn't happen - Is this the expected behaviour ?

  • January 29, 2016 at 3:24 am

    #1855178

    It is. SQL 2012 doesn't support compat more 80, so the restored database could not have been left in compat mode 80.

    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

  • January 29, 2016 at 3:26 am

    #1855179

    Thanks Gail. I think I was getting confused with upgrading a sql2000 to sql 2012 which can't happen

    More coffee needed !!!:-)

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

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