title: SQL Server database restoration failed - Version Conflict
body: <p>I am attempting to restore SQL Server database backups from <code>*.bak</code> files and whenever I try a restore via Microsoft SQL Server Management Studio I get the following error: </p>
  
  <blockquote>
    <p>Restore of database 'ALA_PPD' failed.<br>
    (Microsoft.SqlServer.Management.RelationalEngineTasks)  </p>
    
    <p>ADDITIONAL INFORMATION:</p>
    
    <p>System.Data.SqlClient.SqlError: The database was backed up on a server running version 12.00.2000. That version is incompatible with this server, which is running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)</p>
  </blockquote>
  
  <p>I realize that the versions of servers where different, my question is there a way to convert these 12.00.2000 <code>*.bak</code> files to be usable in version 11.00.2100? </p>
  
  <p>I know that I could install ver. 11.00.2100 and successfully restore but I have databases currently in my 12.00.2000 installation that cannot be removed. </p>
  
  <p>Any suggestions would be greatly appreciated. Sorry if it is a noob question. </p>