title: How can I restore a database backup file (.bak) from SQL Server 2012 into SQL Server 2008 Express?
body: <p>A database that was originally from SQL Server 2008, was restored into SQL Server 2012. A backup from SQL Server 2012 was made and I am trying to restore it on my local SQL Server 2008 Express. However I get an error 'Specified cast is not valid' (SQLManagerUI).</p>
  
  <p>I have generated an SQL Script from 2012 and set it so that it will generate with compatibility to SQL Server 2008. However it is a large sql file, around 700mb.</p>
  
  <p>I recall before that I had tried to run a script of that size before on my local SQLExpress and also got an error.</p>
  
  <p>Is there a way I can get a "large" database from SQL Server 2012 into SQL Server 2008 Express?</p>