How to exclude MS SQL Databases from SQL Log backup

KB ID: 2104
Products: Veeam Backup & Replication
Version: 8.x, 9.x
Published:
Last Modified: 2016-08-24

Challenge

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

Solution

In Veeam Backup & Replication 8.x and 9.x, registry keys need to be created, specifying which combination of Instance/DB to exclude 
 
All keys need to be created inside "HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\Veeam Backup and Replication", on the server Veeam Backup and Replication is installed on.

SqlBackupInstanceDatabaseDelimiter
         Type: REG_SZ
         value: ":"

SqlBackupInstanceDatabasePairsDelimiter
         Type: REG_SZ
         value: ";"

SqlBackupDatabasesToSkip
         Type: REG_SZ
         value: "mysqlserver_instance:mydb;mysqlserver_instance:mydb2"


To exclude SQL databases from SQL logs backups, list databases and instances as following, with multiple combinations possible:  
sql_intance_name:db_name - skip everything containing specified instance and db name 
sql_instance_name: - skip all databases on this instance 
:db_name - skip all databases with this name, on all instances 
 

4 / 5 (3 votes cast)

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!

Orphus system