title: Restoring a Backup with SQL Server
body: <p>I have a SQL Server database that I am trying to restore. My source database was on a SQL Server 2005 installation. My new server is a SQL Server 2008 machine. I have backed-up the database on the SQL Server 2005 installation. I am trying to restore it onto the SQL Server 2008 installation.</p>
  
  <p>When I try to restore the backed-up database, I receive an error that says:</p>
  
  <pre><code>TITLE: Microsoft SQL Server Management Studio
  ------------------------------
  Restore failed for Server 'DBSERVER'.  (Microsoft.SqlServer.SmoExtended)
  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&amp;EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&amp;EvtID=Restore+Server&amp;LinkId=20476
  ------------------------------
  ADDITIONAL INFORMATION:
  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
  ------------------------------
  The backup set holds a backup of a database other than the existing 'MyDatabase' database.
  RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)
  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.50.1600&amp;EvtSrc=MSSQLServer&amp;EvtID=3154&amp;LinkId=20476
  </code></pre>
  
  <p>What is the problem? What am I doing wrong? I have checked the "Overwrite existing database (WITH REPLACE)" box on the Options page.</p>
  
  <p>Thank you</p>