Post reply

Backward compatibility mode for SQL Server 2012

  • August 9, 2013 at 8:39 am

    #296897

    I got a requirement that I need to install SQL 2012 and make sure that its compatible to host SQL 2008 R2 applications only.

    I went to the model database properties and changed the compatibility and tested creating a new database and that got created in SQL 2008 mode.

    Was this method right?

    Also, is there a seperate compatibility mode for SQL 2008 and SQL 2008 R2?

  • August 9, 2013 at 9:27 am

    #1640182

    Leave the databases that you restore in compatibility mode 100.

    Doesn't mean that the server's behaving entirely as if it were a SQL 2008/2008 R2, just that some T-SQL structures and keywords are treated as they were in SQL 2008 not SQL 2012.

    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

  • August 9, 2013 at 11:55 am

    #1640230

    Thanks.

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

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