Monitoring MS SQLSERVER Backup


#1

Hi,

I’m using Nagios to monitoring some machines and one of them had deploy a MS SQLSERVER database. Now, I’m monitoring this service, but I would like to monitor if backup was occured well and no errors happend.
I still making some researches on Internet, but it was unsuccessfully.
Anyone can help me giving some idea?


#2

You can run a query that check the sql job status if that is what you are after.

You can run the query directly from nagios if you install an MSSQL plugin or you can can create e.g. a vbs file locally on the sql server and execute it with NRPE via NSCLIENT++. I do the latter. The advantage is that I dont have to store the user /pwd on the nagios server. The vbs script use a udl file to access the database.