title: Is it possible to restore a SQL Server database from a virtual drive?
body: <p>In SQL Server Management Studio, if I attempt to restore a database from a backup file with a command like:</p>
  
  <pre><code>RESTORE DATABASE somedatabase FROM DISK = '&lt;virtual disk&gt;:\&lt;path&gt;\&lt;backup file&gt;';
  </code></pre>
  
  <p>I get a "file not found" error.  I'm creating  with the "subst" command.  But if I replace  with a physical disk and  with the complete path, the command works just fine.</p>
  
  <p>Is there any way at all to restore a database from a path that starts with a virtual disk?  If so, what is it?  If not, how might I work around this issue?</p>
  
  <p>As an aside, the reason for using virtual disks in the first place was to insulate the script from differences across development environments (I'm trying to develop an MSBuild script to automate the creation of local databases for testing.)</p>