title: Compatibility level for SQL Server database
body: <p>My database hoster allows to restore SQL Server databases with a compatibility level of 90 (SQL Server 2005). My database is created locally with a compatibility level of 100 (SQL Server 2008).  </p>
  
  <p>So, I generated script of my database (version 2008) and run in SQL Server 2005, backup and restore to my database hoster, it works. Currently I do likes it.  </p>
  
  <p>And then I found <a href="http://msdn.microsoft.com/en-us/library/bb510680.aspx" rel="nofollow">ALTER DATABASE</a> that can change compatibility level of database likes</p>
  
  <pre><code>ALTER DATABASE database_name 
  SET COMPATIBILITY_LEVEL = { 90 | 100 | 110 }
  
   90 = SQL Server 2005
   100 = SQL Server 2008 and SQL Server 2008 R2
   110 = SQL Server 2012
  </code></pre>
  
  <p>I turn my database compatibility level using this script in SQL Server 2008, backup my database and restore to my database hoster. But it doesn't work. I want to know why? Is there a better way to fix it ?</p>