What drives the log backup alert in SQL Monitor 9?

sheldonhull

I'm having a ton of false alerts from log backups being overdue while the log backups have been performed. 

We are currently using Cloudberry SQL backup on a few of these servers. It seems to happen on newly created databases that get backed up within minutes, but still all are reporting no log backups. 

Cloudberry uses native sql backups to my knowledge, but I'm not seeing the backup entry show up in the msdb backup details. 

Is there something that could be preventing the backups from being properly captured by SQL Server in the msdb tables, which I assume drive the alert logic?

Russell D

Yeah we grab this information from msdb.dbo.backupset, msdb.dbo.backupmediaset and msdb.dbo.backupmediafamily so if the backup isn't there then we'll think it doesn't exist, hence the alerts.