Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Backup thresholds (exclude databases) #1168

Open
FuriousDBA opened this issue Jan 3, 2025 · 1 comment
Open

Backup thresholds (exclude databases) #1168

FuriousDBA opened this issue Jan 3, 2025 · 1 comment

Comments

@FuriousDBA
Copy link

FuriousDBA commented Jan 3, 2025

Hi, can you please add feature to be able to set exceptions separately for full, diff, log backups?
Use case: I would like to exclude msdb from DIFF backups, but if I put msdb in exclude list I will stop monitoring FULL backups for msdb at the same time.
Additionally, is it possible to add wildcards in excluded DBs list?
Thanks

@DavidWiseman
Copy link
Collaborator

Willdcards are already supported - anything that works with LIKE.

As a workaround for this request, you could configure the threshold at the database level. This might be a bit painful to do in the UI, but you could use a script like the one below.

INSERT INTO dbo.BackupThresholds(InstanceID,DatabaseID,FullBackupWarningThreshold,FullBackupCriticalThreshold,ConsiderPartialBackups,ConsiderFGBackups,ExcludedDatabases)
SELECT InstanceID,DatabaseID,10080,14400,0,0,''
FROM dbo.Databases D
WHERE name = 'msdb'
AND IsActive=1
AND NOT EXISTS(SELECT 1 
				FROM dbo.BackupThresholds BT
				WHERE BT.InstanceID= D.InstanceID
				AND BT.DatabaseID = D.DatabaseID
				)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants