title: How can I tell if a SQL Server database is being backed up
body: <p>Is there a way to programmatically determine if a SQL Server backup is currently being performd on a particular database?</p>
  
  <p>We have automated database backup scripts for both data and log files, where the databases are backed up nightly and log files are backed up every 15 minutes, 24 hours a day.  However, we think that the log file backup job is failing if it runs the same time as the full backup is being run.</p>
  
  <p>What I'd like to do is to make a change to my transaction log script to not run a transaction log backup while the full backup is being run.</p>
  
  <p>If there a DMV or a system table that I can query and work this out?</p>