title: SQL Server 2014 database restore fails
body: <p>I have clustered version of SQL Server 2014 for production, and for development I use SQL Server 2014 2014 Express edition.</p>
  
  <p>I am facing problem while restore database backup from <code>.bak</code>.</p>
  
  <p>I get the following error every time I try to restore</p>
  
  <blockquote>
    <p>TITLE: Microsoft SQL Server Management Studio</p>
    
    <p>Restore failed for Server 'WEBDESIGNINA\SQLEXPRESS2014'.  (Microsoft.SqlServer.SmoExtended)</p>
    
    <p>ADDITIONAL INFORMATION:</p>
    
    <p>An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)</p>
    
    <p>The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS2014\MSSQL\DATA\Database_Name.mdf'.</p>
    
    <p>File 'Database_Name' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS2014\MSSQL\DATA\Database_Name.mdf'. Use WITH MOVE to identify a valid location for the file.</p>
    
    <p>The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS2014\MSSQL\DATA\Database_Name.ldf'.</p>
    
    <p>File 'Database_Name_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS2014\MSSQL\DATA\Database_Name.ldf'. Use WITH MOVE to identify a valid location for the file.</p>
    
    <p>Problems were identified while planning for the RESTORE statement. Previous messages provide details.<br>
    RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3634)</p>
  </blockquote>
  
  <p>Only way to get around this problem is to delete the database &amp; then restore to new database.</p>
  
  <p>How can I overwrite this database without error</p>