Solved

How to exclude a SQL database from getting backed up so there won't be failed email messages

3 years ago
February 3, 2022
3 comments
4549 views

BassFisher
Not a newbie anymore
3 comments

I am just starting out doing Veeam SQL backups and one thing I found is I need to be able to exclude certain dBs from getting backed up in Veeam. The dBs that I do not want backed up are for dev and the dB is restored to a different server nightly so when a Veeam SQL log backup happens I’m getting the error “Collected SQL Server transaction logs do not match any existing database backup: DatabaseName” which is 100% accurate.

I do not take full backups every day so when the logs are getting backed up this particular dB does not have a full associated with the log backups.

This dB would not need to get backed up at all.

Best answer by MattM

You can exclude SQL DBs from application aware processing and/or SQL Log backups but be aware that the databases will still be included in the image backups. So you will not see a reduction in the image backup sizes when excluding DBs from processing.

Description of how exclusions can be configured:

Enable SQL Database exclusions from application-aware image processing

How to exclude MS SQL Databases from SQL Log backup

View original

Did this topic help you find an answer to your question?

+2

MattM
Experienced User
53 comments
Answer
3 years ago
February 3, 2022

You can exclude SQL DBs from application aware processing and/or SQL Log backups but be aware that the databases will still be included in the image backups. So you will not see a reduction in the image backup sizes when excluding DBs from processing.

Description of how exclusions can be configured:

Enable SQL Database exclusions from application-aware image processing

How to exclude MS SQL Databases from SQL Log backup

+21

Chris.Childerhose
Veeam Legend, Veeam Vanguard
9396 comments
3 years ago
February 3, 2022

Hi @BassFisher

This should help enable the DB Exclusion option if not already shown in Veeam and then you can specify databases to exclude from being backed up like the DEV one you mentioned.

KB2110: Enable SQL Database exclusions from application-aware image processing (veeam.com)

Hope this helps.

This is what shows when enabled -