title: Restore Database and change the location for MDF File
body: <p>I wont restore my database but the location path is not the same. How can i change this path(partition)? </p>
  
  <pre><code>RESTORE DATABASE [MY_DATABASE] 
  FROM  DISK = 'C:\Content.bak' 
  WITH  FILE = 1,  
  NOUNLOAD,  
  STATS = 10
  </code></pre>
  
  <p>Error Message:</p>
  
  <blockquote>
    <p>Msg 5133, Level 16, State 1, Line 1<br>
    Directory lookup for the file "F:....\Content01.mdf" failed with the operating system error 3(failed to retrieve text for this error.
    Reason: 15100).<br>
    Msg 3156, Level 16, State 3, Line 1<br>
    File 'Content01' cannot be restored to 'F:....\Content01.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 "H:....\Content01_log.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 'Content01_log' cannot be restored to 'H:....\Content01_log.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.</p>
  </blockquote>
  
  <p>THANKS.</p>