title: How to import a bak file into SQL Server Express
body: <p>I have a <code>.bak</code> file, and I want to use this file to recreate the database in a fresh install of SQL Server 2008 Management Studio.</p>
  
  <p>Can someone point me in the right direction on how this can be done?</p>
  
  <p>I have tried:</p>
  
  <ol>
  <li><p>right click on the Databases container within object explorer</p></li>
  <li><p>from context menu select Restore database</p></li>
  <li><p>Specify To Database as either a new or existing database</p></li>
  <li><p>Specify Source for restore as from device</p></li>
  <li><p>Select Backup media as File</p></li>
  <li><p>Click the Add button and browse to the location of the BAK file</p></li>
  </ol>
  
  <p>but I am getting error that </p>
  
  <blockquote>
    <p>Restore failed for Server 'MyServer-PC'.  (Microsoft.SqlServer.SmoExtended)</p>
    
    <p>ADDITIONAL INFORMATION:</p>
    
    <p>System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'invent' database. (Microsoft.SqlServer.Smo)</p>
  </blockquote>