title: Restore SQL Server 2008 DB *to* SQL Server 2005
body: <p>Got myself in a bit of a pickle here ... working on a CMS project, under the assumption that sql server 2008 was greenlighted as the db of choice. Well it wasn't, we now have to backport all of our content out SQL Server 2008 and into SQL Server 2005. </p>
  
  <p>A simple backup/restore procedure yields: "RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)". </p>
  
  <p>Unfortunately, exporting the data to an excel spreadsheet yields multiple OLE errors which I believe is actually a problem in the db of the cms. </p>
  
  <p>Does anyone out there have other approaches they would like to recommend for this task? Thanks in advance</p>