1. You have created an application-aware backup plan for Microsoft SQL Server.
2. Backup completes with this warning message:
SQL Server database <database_name> of instance <instance_name> has not been backed up because the database files are not included in the single-pass backup.
1. The folder with the database files is excluded from the backup.
2. AUTO_CLOSE property of SQL database is turned on. When enabled, the AUTO_CLOSE property shuts down the database after the last user exits. The database automatically reopens when a user tries to use the database again. When enabled, this option interferes with backup workflow: SQL Server SQLWriter currently doesn't handle AUTO_CLOSE databases correctly in third-party VSS backup requests. Disable AUTO_ClOSE to allow database backup.
1. Make sure that backup plan file filters do not exclude the folder with the database files you want to back up. Go to backup plan options > File filters and make sure that physical path to the database files is not specified in `Do not back up files matching the following criteria`input field:
2. Run command line as administrator and issue:
mountvol.exe "<path to the database file>" /L
This command lists the mounted volume name for the specified folder. If the location of the database files turns out to be a mount point, include the actual location of the database files into the backup plan.
3. Set the AUTO_CLOSE Database Option to OFF as described in Microsoft documentation.