Enable SQL Database exclusions from application-aware image processing

KB ID: 2110
Product: Veeam Backup & Replication | 7.0 | 8.0 | 9.0 | 9.5 | 10 | 11
Published: 2016-03-14
Last Modified: 2022-01-18
Languages: DE | FR
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.

Challenge

This article provides information about excluding a SQL Database from being part of 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. The database files will still be backed up as part of the VM backup.

If you are using a third-party tool to manage the SQL Transaction Logs and want to prevent Veeam Backup & Replication from truncating the transaction logs, consider enabling the copy-only option within the Backup Job.

 

Solution

The solution below will instruct you on enabling and using the DBExclusion menu that is built-in to Veeam Backup & Replication v7 or newer.

  1. Connect to the server where Veeam Backup & Replication is installed
  2. Close any open Veeam Backup & Replication console windows.
  3. Open Regedit.exe
  4. Navigate to the key HKLM\SOFTWARE\Veeam\Veeam Backup and Replication\
  5. Add a new DWORD ‘EnableDBExclusions’
  6. Set the Value to 1
    User-added image
  7. Close the Registry Editor and open the Veeam Backup & Replication Console
  8. Open “Database Exclusions” in the Main Menu
    User-added image
  9. In the window that pops up, click Add.
  10. Specify the DNS name (case sensitive) or the IP address and the instance name (case sensitive) containing the data you wish to exclude from VSS Freezing and being Quiesced.
  11. Specify the Database name (case sensitive) that you wish to exclude from application-aware image processing.
    A wildcard cannot be used, a valid database name must be specified.User-added image

More information

NOTE: The Database Exclusion settings only affect Microsoft SQL Server databases.
Click here to send feedback regarding this KB, or suggest content for a new KB.
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 reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

Oops! Something went wrong.

Please try again later.

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 reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
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.