title: Restore SQL Server 2008 database to SQL Server 2000
body: <p>I have to move an entire database from a SQL Server 2008 machine to a SQL Server 2000 machine.</p>
  
  <p>I created a backup using Management Studio 2008, copied it to the hard drive of the 2000 box, and from withing Management Studio 2008, I choose Restore Database to the 2000 box.</p>
  
  <p>I get an error message stating, "The media family on device ... is incorrectly formed. SQL Server cannot restore this media family".</p>
  
  <p>If I use Enterprise Manager 2000 I get the same error.</p>
  
  <p>Is there a way to move a whole database from the newer SQL server to the older?</p>