title: Error restoring database backup
body: <p>I am getting an error using SQL Server 2012 when restoring a backup made with a previous version (SQL Server 2008). I actually have several backup files of the same database (taken at different times in the past). The newest ones are restored without any problems; however, one of them gives the following error:</p>
  
  <blockquote>
    <p>System.Data.SqlClient.SqlError: Directory lookup for the file
    "C:\PROGRAM FILES\MICROSOFT SQL
    SERVER\MSSQL.1\MSSQL\DATA\MYDB_ABC.MDF" failed with the operating
    system error 3(The system cannot find the path specified.).
    (Microsoft.SqlServer.SmoExtended)</p>
  </blockquote>
  
  <p>This is a x64 machine, and my database file(s) are in this location: <code>c:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL</code>.</p>
  
  <p>I do not understand why it tries to restore on <code>MSSQL.1</code> and not <code>MSSQL11.MSSQLSERVER</code>. </p>