- Veeam Support Knowledge Base
- How to exclude MS SQL Databases from SQL Log backup
How to exclude MS SQL Databases from SQL Log backup
| KB ID: | 2104 |
| Product: | Veeam Backup & Replication | 9.5 | 10 | 11 | 12 | 12.1 | 12.2 | 12.3 | 12.3.1 | 12.3.2 | 13 | 13.1 |
| Published: | 2016-03-01 |
| Last Modified: | 2022-09-09 |
| Languages: | FR |
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.
Challenge
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
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
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.