#1 Global Leader in Data Resilience

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
Veeam Agent for Microsoft Windows | 4.0 | 5.0 | 6.0 | 6.1 | 6.2 | 6.3
Published: 2016-03-14
Last Modified: 2024-07-10
Languages: DE | FR
mailbox
Get weekly article updates
By subscribing, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.

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

error icon

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.

Note:

  • 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 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

  1. Connect to the Veeam Backup Server.
  2. Close all open Veeam Backup & Replication Console windows.

    PowerShell Command:
Stop-Process -name veeam.backup.shell
  1. 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
  1. Open the Veeam Backup & Replication Console.
  2. In the Main Menu, you will find that the VM Exclusions option has been replaced with a Global Exclusions sub-menu.
  3. Expand Global Exclusions and select Database Exclusions.
DB Exclusions
  1. In the SQL Databses Exclusions window that appears, click Add.
add exclusion
  1. 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.

 

Exclusion Config
  1. 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 settings only affect Microsoft SQL Server databases.
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.

Spelling error in text

This site is protected by hCaptcha and its Privacy Policy and Terms of Service apply except as noted in our Privacy Policy.
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

Oops! Something went wrong.

Please, try again later.

You have selected too large block!

Please try select less.

KB Feedback/Suggestion

This form is only for KB Feedback/Suggestions, if you need help with the software open a support case

By submitting, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.
This site is protected by hCaptcha and its Privacy Policy and Terms of Service apply except as noted in our Privacy Policy.
Verify your email to continue your product download
We've sent a verification code to:
  • Incorrect verification code. Please try again.
An email with a verification code was just sent to
Didn't receive the code? Click to resend in sec
Didn't receive the code? Click to resend
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

error icon

Oops! Something went wrong.

Please, try again later.