title: Restore .bak file to remote database
body: <p>I have a <code>test.bak</code> file in my local machine. I need to restore this file to remote machine's database. How do I do that?</p>
  
  <p>When I try this, the remote database throws an error that it is not able to find <code>test.bak</code> on the local filesystem.</p>
  
  <p><strong>Query</strong></p>
  
  <pre><code>RESTORE DATABASE TESTPROJECT 
  FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.ICON3\MSSQL\Backup\test.bak'
  </code></pre>
  
  <p><strong>Error</strong></p>
  
  <pre><code>Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.ICON3\MSSQL\Backup\test.bak'. Operating system error 2(The system cannot find the file specified.).
  </code></pre>
  
  <p>How can I  achieve this? I am using Microsoft SQL Server 2008.</p>