SQL Monitoring
SQL Monitoring
Is there a way to monitor the last backup status of SQL?
Re: SQL Monitoring
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.
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/
https://www.mcapra.com/
-
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: SQL Monitoring
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