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

Inspector - Add extra control over backup thresholds #296

Closed
Adedba opened this issue Sep 29, 2021 · 0 comments · Fixed by #301
Closed

Inspector - Add extra control over backup thresholds #296

Adedba opened this issue Sep 29, 2021 · 0 comments · Fixed by #301

Comments

@Adedba
Copy link
Collaborator

Adedba commented Sep 29, 2021

It would be good to be able to set backup thresholds at a database level as well as having global thresholds for the server.

For example:

You may want to set the global threshold to warn if a full backup has not been taken for 7 days but you may be running nightly system database backups so you actually want to have a separate threshold for your system databases.

Ideally we should have a thresholds table that allows the user to add a servername/database name combination along with the relevant thresholds for FULL, DIFF and LOG. When the report runs it can check for existence of these thresholds first and use them for a given server/db otherwise default to the global values set in the main Settings table.

@Adedba Adedba self-assigned this Sep 29, 2021
Adedba added a commit that referenced this issue Oct 6, 2021
#296 Added Granular control over backup thresholds
Adedba added a commit that referenced this issue Oct 6, 2021
#296 Amended clustered index on new BackupCheckThreshold table
Adedba added a commit that referenced this issue Oct 12, 2021
#296 Changed IsActive column from Null to Not null and added missing Threshold column on the backups report.
@Adedba Adedba added this to To do in Inspector 2.7 Oct 31, 2021
@Adedba Adedba moved this from To do to Done in Inspector 2.7 Oct 31, 2021
@Adedba Adedba moved this from Done to Testing in Inspector 2.7 Oct 31, 2021
Adedba added a commit that referenced this issue Dec 1, 2021
#296 - fixed a bug where threshold was not being honoured for diffs
@Adedba Adedba moved this from Testing to Done in Inspector 2.7 Dec 6, 2021
@Adedba Adedba mentioned this issue Dec 6, 2021
Adedba added a commit that referenced this issue Dec 6, 2021
#296 - Altered backups check table tail text
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
No open projects
Development

Successfully merging a pull request may close this issue.

1 participant