#1 Global Leader in Data Protection & Ransomware Recovery

How to exclude MS SQL Databases from SQL Log backup

KB ID: 2104
Product: Veeam Backup & Replication | 9.5 | 10 | 11 | 12 | 12.1
Published: 2016-03-01
Last Modified: 2022-09-09
Languages: 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.

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 Value (REG_SZ)
Value Data: InstanceName:DatabaseName;InstanceName:DatabaseName

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

Notes: 

  • This exclusion registry value is not server-specific and will apply to every SQL server processed by any SQL Transaction Log Backup.
  • Do not include the server name in the registry value, only the Instance Name and the Database Name.
  • The default SQL Instance, MSSQLSERVER, must be added to the rule as simply the word default.
     

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 any instance with the specified instance name.
  • InstanceName: 
    will skip all databases in any instance with the name specified.
  • :DBname 
    will skip databases with the specified name in any instance

 

Advanced example:

Exclude all databases named "Scratch" in any instance, all databases inside any instance named "DevTest", and the database "ProdMig" in the instance "SQLMigTest"

:Scratch;DevTest:;SQLMigTest:ProdMig
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 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.

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