title: How to restore .bak file in SQL Server 2008 R2
body: <p>I have a code blog but a problem was occurred. In here my backup file is <code>ISBANK.bak</code> and database name is new database name. It doesn't contain anything. I want to add <code>.bak</code> file's content to a new database..</p>
  
  <pre><code>RESTORE DATABASE [DBName]
  FROM DISK = 'D:\ISBANK.bak'
  WITH REPLACE,
  MOVE 'DBName' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008RR2\MSSQL\DATA\DBName.mdf',
  MOVE 'DBName' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008RR2\MSSQL\DATA\DBName.ldf'
  </code></pre>
  
  <p>I am getting these errors:</p>
  
  <blockquote>
    <p><em>Msg 5133, Level 16, State 1, Line 1<br>
    Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSRV2008\MSSQL\DATA\OBERNET_DENEME.mdf" failed with
    the operating system error 3 (failed to retrieve text for this error.
    Reason: 15105).<br>
    Msg 3156, Level 16, State 3, Line 1<br>
    File 'OCEAN' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSRV2008\MSSQL\DATA\OBERNET_DENEME.mdf'. Use WITH
    MOVE to identify a valid location for the file.<br>
    Msg 5133, Level 16, State 1, Line 1<br>
    Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSRV2008\MSSQL\DATA\OBERNET_DENEME.ldf" failed with
    the operating system error 3 (failed to retrieve text for this error.
    Reason: 15105).<br>
    Msg 3156, Level 16, State 3, Line 1<br>
    File 'OCEAN_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSRV2008\MSSQL\DATA\OBERNET_DENEME.ldf'. Use WITH
    MOVE to identify a valid location for the file.<br>
    Msg 3119, Level 16, State 1, Line 1<br>
    Problems were identified while planning for the RESTORE statement. Previous messages provide details.<br>
    Msg 3013, Level 16, State 1, Line 1<br>
    RESTORE DATABASE is terminating abnormally.</em></p>
  </blockquote>