search

Teutenberg / DBAid2

SQL Server administrative support database
MIT License
1 stars 1 forks source link

Transaction Log Backup Not Performed Within x Hours #18

Closed thecosmictrickster closed 4 years ago

thecosmictrickster commented 4 years ago

For databases in bulk or full recovery mode, we sometimes want to be alerted if a transaction log backup has not started within a given period.

Transferred from DBAid issues.

Teutenberg commented 4 years ago

Transaction log backups should raise an event if not backed up within 1 hour.

https://github.com/Teutenberg/DBAid2/blob/master/database/checkmk/procedures/check_backup.sql#L60 https://github.com/Teutenberg/DBAid2/blob/master/database/checkmk/tables/config_database.sql#L18