sql-server.databases.backup.age

[Sidanat]

Can I use the above metric to  build a dashboard and alert and if so what would the DQL look like. 

Get all databases that are in full recovery mode, filter the transaction log backups only and exclude some database out of the query and send an alert on any database that hasn't had a log backup in the last hour   

[AntonPineiro]

Hi,

You should be able to do it if that backup metric has recovery mode as dimension.

Best regards

[Sidanat]

Thanks for getting back to me is there a way to filter and alert on any database that hasn't had a backup for say 2 hours. Also I don't see a option for differential backups - only full - transactional - full copy-only    

[AntonPineiro]

Hi,

I would say checking metric "com.dynatrace.extension.sql-oracle.backup.time_since", different dimensions are there to apply filters:

Best regards