1-800-691-1991 | 9am - 8pm ET
EN

How to exclude MS SQL Databases from SQL Log backup

KB ID: 2104
Product: Veeam Backup & Replication
Version: 8.x and higher
Published: 2016-03-01
Last Modified: 2021-09-10
Languages: FR

Challenge

It is necessary to exclude specific databases on one or more Microsoft SQL Server instances from Veeam SQL Transaction Log backup processing. 
 

Solution

The following registry value is used to exclude databases from SQL Transaction Log backup. The exclusion will take effect during the next SQL Transaction Log Backup session.
 
Create this registry value on the server where Veeam Backup and Replication is installed.

Key Location: HKLM\SOFTWARE\VeeaM\Veeam Backup and Replication
Value Name: SqlBackupDatabasesToSkip
Value Type: String Vale (REG_SZ)
Value Data: InstanceName:DatabaseName;InstanceName:DatabaseName

Take note of the formating, the registry value is using a colon between the instance name and the database name, and a semicolon is used to separate sets of instance and database pairs.

Note: This exclusion registry value is not server-specific and will apply to every SQL server processed by SQL Transaction Log Backup.
 

Example:

The database "EDSHSD" in the instance named "SQLInstance" becomes SQLInstance:EDSHSD

example of registry value and outcome in SQL Transaction Log Backup session report
Click to Enlarge

Advanced Exclusion Techniques:

  • InstanceName:DBname 
    will skip databases with the specified name in an instance with the specified instance name.
  • InstanceName: 
    will skip all databases in an instance having the name specified.
  • :DBname 
    will skip any database with the specified name in any instance
KB ID: 2104
Product: Veeam Backup & Replication
Version: 8.x and higher
Published: 2016-03-01
Last Modified: 2021-09-10
Languages: FR

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.
Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

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 Policy.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Thank you for your interest in Veeam products!
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.