SQL Monitoring

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
wjoyner
Posts: 32
Joined: Thu Mar 22, 2018 7:28 am

SQL Monitoring

Post by wjoyner »

Is there a way to monitor the last backup status of SQL?
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: SQL Monitoring

Post by mcapra »

No, because SQL as a language doesn't have a concept of "backups".

If you're referring to Microsoft SQL Server backups, the check_mssql_health plugin can monitor "backup age" of standard SQL Server database backups:
https://labs.consol.de/nagios/check_mssql_health/
https://exchange.nagios.org/directory/P ... th/details

If you're referring to MySQL/MariaDB backups, it is generally possible but the solution would depend on your backup strategy and the tools involved.
Former Nagios employee
https://www.mcapra.com/
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: SQL Monitoring

Post by scottwilkerson »

if you are backing up MySQL/MariaDB then you may be able to us a tool like the Folder Watch Wizard to check count or update times
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
Locked