Page 1 of 1
SQL Monitoring
Posted: Mon Jun 25, 2018 2:12 pm
by wjoyner
Is there a way to monitor the last backup status of SQL?
Re: SQL Monitoring
Posted: Mon Jun 25, 2018 3:25 pm
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.
Re: SQL Monitoring
Posted: Mon Jun 25, 2018 3:57 pm
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