title: T-SQL Backup Database command for file path with spaces?
body: <p>How do I write a T-SQL backup database command to specify a file containing spaces?
  Here is what I have:</p>
  
  <pre><code>BACKUP DATABASE AMDMetrics TO DISK = 'C:\Documents and Settings\daultrd\My Documents\DatabaseBackups\AMD_METRICS.DAT'
  </code></pre>
  
  <p>And this is the error I get:</p>
  
  <blockquote>
    <p>Msg 3201, Level 16, State 1, Line 1
    Cannot open backup device 'C:\Documents and Settings\daultrd\My Documents\DatabaseBackups\AMD_METRICS.DAT'. Operating system error 3(The system cannot find the path specified.).
    Msg 3013, Level 16, State 1, Line 1
    BACKUP DATABASE is terminating abnormally.</p>
  </blockquote>