title: Problem restoring a 2005 SQL DB with 2008
body: <p>I have a DB I created with SQL Server 2005 and created a backup (*.bak) now I want to restore it with 2008 but ouch, I get the following error:</p>
  
  <pre><code>TITLE: Microsoft SQL Server Management Studio
  ------------------------------
  
  Restore failed for Server 'SHIMMY-PC\SQLEXPRESS'.  (Microsoft.SqlServer.SmoExtended)
  
  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&amp;EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&amp;EvtID=Restore+Server&amp;LinkId=20476
  
  ------------------------------
  ADDITIONAL INFORMATION:
  
  System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)
  
  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&amp;LinkId=20476
  
  ------------------------------
  BUTTONS:
  
  OK
  ------------------------------
  </code></pre>