I have Backupexec running on Windows 2008 Domain Controller (named "DC1") and a Windows 2003 Server running Microsoft SQL database. I did not install Backup Exec software, but I thought all SQL database files were being backed up. The other day I discovered that I could not restore SQL database file "TMW_LIVE.mdf (17GB)". So I checked backup Job History from one random day and learned that these SQL database files were "skipped" because they are OPEN.
How do I need to do to close these SQL database files during the backup time and reopen them after the backup job is run?