Forum Discussion

liuyang's avatar
liuyang
Level 6
9 years ago

BE 15 does not exclude SQL DB files from backups

Hi, our customer is using BE 15 on Windows Server 2008 R2 as the backup server. They have a few MS SQL servers (MS SQL 2008/2014 on Windows Server 2008 R2). These servers have two types of BE backups...
15
Backing Up
Backup and Recovery
Backup Exec
Windows Server (2003-2008)
  • VJware's avatar
    VJware
    9 years ago

    For SDR enabled backup, is the Microsoft SQL instance selected in the backup job ?

    Also, is this key present on the BE server - https://www.veritas.com/support/en_US/article.TECH92375

    Lastly, verbatim from https://www.veritas.com/support/en_US/article.HOWTO24057

    For example, .MDF and .IDF files should not be part of the backup because they are opened for exclusive use by the SQL system. These files will be automatically excluded for backup by a feature called Active File Exclusion. If this exclusion did not happen during a non-snapshot backup, these files would appear as in use - skipped. If this exclusion did not happen during a snapshot backup, the files would be backed up in a possible inconsistent state, which could create restore issues.

    As per the last 2 lines, exclusion may not happen.

VJware's avatar
VJware
Level 6
9 years ago

For SDR enabled backup, is the Microsoft SQL instance selected in the backup job ?

Also, is this key present on the BE server - https://www.veritas.com/support/en_US/article.TECH92375

Lastly, verbatim from https://www.veritas.com/support/en_US/article.HOWTO24057

For example, .MDF and .IDF files should not be part of the backup because they are opened for exclusive use by the SQL system. These files will be automatically excluded for backup by a feature called Active File Exclusion. If this exclusion did not happen during a non-snapshot backup, these files would appear as in use - skipped. If this exclusion did not happen during a snapshot backup, the files would be backed up in a possible inconsistent state, which could create restore issues.

As per the last 2 lines, exclusion may not happen.