title: How to read backup name of a database in SQL Server
body: <p>When running the <code>BACKUP</code> command, like this:</p>
  
  <pre><code>BACKUP DATABASE dbname TO DISK ... etc.
  </code></pre>
  
  <p>You can specify a name for the backup with this option: </p>
  
  <pre><code>NAME = N'something'
  </code></pre>
  
  <p>I have many backup files and need to read the <code>NAME</code> property if there was specified one. How do I do it?</p>