title: Possible to restore a backup of SQL Server 2014 on SQL Server 2012?
body: <p>I know that you can't (at least not easily) restore a SQL Server 2012 backup on SQL Server 2008. But how does it work for SQL Server 2014 to SQL Server 2012 ?</p>
  
  <p>On database level there is the property to adjust the compatibility mode to any other SQL Server version.</p>
  
  <p>How does this helps or work ? Will it only disallow the features from 2014? </p>
  
  <p>To be honest I already tried to restore a backup, but 2012 didn't recognize the datafile, so I couldn't click <code>ok Button</code> to start the restore procedure.</p>
  
  <p>Did I miss some important option ?</p>