3 responses

  1. Sidesoft
    May 12, 2012

    I was trying to restore a bak database from Server 2005 into a new install of 2012 Express and faced nothing but failure…until i read this article. Changed the compatibility level before doing the backup and wala the restore into 2012 was possible. You saved me a lot of frustration!!!

    • Bru Medishetty
      May 21, 2012

      That’s great to know.. I am glad, this article could help you..

  2. Ananova
    June 28, 2013

    Hi,

    When I typed the following query:

    ALTER DATABASE adventureworks SET COMPATIBILITY_LEVEL = 110;

    I got the following error:

    Msg 15048, Level 16, State 1, Line 1

    Valid values of the database compatibility level are 80, 90, or 100.

Leave a Reply

You must be to post a comment.

Back to top
mobile desktop