- Veeam Support Knowledge Base
- How to Exclude Microsoft SQL Databases from Application-Aware Processing
How to Exclude Microsoft SQL Databases from Application-Aware Processing
| KB ID: | 2110 |
| Product: |
Veeam Backup & Replication | 7.0 | 8.0 | 9.0 | 9.5 | 10 | 11 | 12 | 12.1 | 12.2 | 12.3 | 12.3.1 | 12.3.2 | 13 | 13.1 Veeam Agent for Microsoft Windows | 4.0 | 5.0 | 6.0 | 6.1 | 6.2 | 6.3 | 6.3.1 | 6.3.2 | 6.3.3 | 13 | 13.1 |
| Published: | 2016-03-14 |
| Last Modified: | 2026-10-06 |
Get weekly article updates
Cheers for trusting us with the spot in your mailbox!
Now you’re less likely to miss what’s been brewing in our knowledge base with this weekly digest
Oops! Something went wrong.
Please, try again later.
Purpose
This article documents how to exclude a Microsoft SQL Database from being processed by Application-Aware Processing.
Limitations and Considerations
- Excluding a database from Application-Aware Processing only means it will not be processed as part of the VSS snapshot operation, and the database will not be frozen.
- The exclusions are per-server and are processed as the runtime component deployed within the Guest OS requests the VSS snapshot creation.
- The exclusion discussed in this article also affects Microsoft SQL transaction Log Backup Jobs. Transaction log backup relies on database information collected during Application-Aware Processing, so a database excluded from Application-Aware Processing will be skipped by log backup jobs as well.
Note: To exclude databases from Transaction Log Backup Jobs only, review: How to exclude MS SQL Databases from SQL Log backup. - The database files will still be backed up as part of the backup job if the disk(s) where the database is located are within the scope of the backup job.
- If you are only looking for a way to prevent the backup job from truncating the SQL Transaction Logs, consider instead changing the truncation setting within the backup job to copy-only.
Veeam Agent for Microsoft Windows Support
The feature documented in this article affects all VM backup jobs (vSphere and Hyper-v) and Veeam Agent Backup jobs operating in Managed by backup server mode. There is no equivalent option for standalone or Managed by Agent policies.
Solution
- Connect to the Veeam Backup Server.
- Close all open Veeam Backup & Replication Console windows.
PowerShell Command:
Stop-Process -name veeam.backup.shell- Create the following registry value:
Key Location: HKLM\SOFTWARE\Veeam\Veeam Backup and Replication\
Value Name: EnableDBExclusions
Value Type: Dword (32-Bit) Value
Value Data: 1
PowerShell command:
New-ItemProperty -Path 'HKLM:\SOFTWARE\Veeam\Veeam Backup and Replication\' -Name 'EnableDBExclusions' -Value "1" -PropertyType DWORD -Force- Open the Veeam Backup & Replication Console.
- In the Main Menu, you will find that the VM Exclusions option has been replaced with a Global Exclusions sub-menu.
- Expand Global Exclusions and select Database Exclusions.
- In the SQL Databses Exclusions window that appears, click Add.
- Enter the Database information.
- Specify the SQL Server's DNS name (case sensitive) or IP address, followed by the instance name (case sensitive) containing the database you wish to exclude from VSS Freezing and being Quiesced.
- Specify the name of the database (case sensitive) you wish to exclude from application-aware image processing.
A wildcard cannot be used. Only a single database can be excluded by each entry in the exclusions table.
- Press OK to close the Add database window, click Add to add another database, or click OK again to close the SQL Databases Exclusions window. During the next job run, the database(s) specified will not be included in Application-Aware Processing.
More Information
NOTE: The Database Exclusion setting only affects Microsoft SQL Server databases.
If this KB article did not resolve your issue or you need further assistance with Veeam software, please create a Veeam Support Case.
To submit feedback regarding this article, please click this link: Send Article Feedback
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.
