Page 1 of 2
MS SQL 2008 backup monitoring via Nagios
Posted: Wed Jun 19, 2013 7:53 am
by inderraw
Dear Team,
I am taking ms sql 2008 automation backup, i want to monitor via nagios, is my backup either success or failure and as well notification.
Regards,
Inder Singh Rawat
Re: MS SQL 2008 backup monitoring via Nagios
Posted: Wed Jun 19, 2013 12:14 pm
by abrist
How are you backing up the db? A custom script? Is it scheduled?
Re: MS SQL 2008 backup monitoring via Nagios
Posted: Wed Jun 19, 2013 12:56 pm
by inderraw
Dear Team,
Db backup is schedule via ms sql managment studio, i have to just monitor via Nagios , is it successfull and failure backup.
Regards
Inder Singh Rawat
Re: MS SQL 2008 backup monitoring via Nagios
Posted: Wed Jun 19, 2013 1:05 pm
by abrist
Is the backup getting logged to the event log, or a separate file?
Re: MS SQL 2008 backup monitoring via Nagios
Posted: Thu Jun 20, 2013 1:17 am
by inderraw
Yes, it is getting logged in event log and backup happening in seprate drive.
Regards
Inder Singh
Re: MS SQL 2008 backup monitoring via Nagios
Posted: Thu Jun 20, 2013 9:23 am
by slansing
Have you tried using NSclient++ with their Event Log module?:
http://www.nsclient.org/nscp/wiki/Check ... k_eventlog
Another possibility would be this:
http://exchange.nagios.org/directory/Ad ... og/details
Though it can be difficult to configure properly.
Re: MS SQL 2008 backup monitoring via Nagios
Posted: Tue Jun 25, 2013 7:12 am
by inderraw
Dear Team,
From where i can download patch for mssql database.
Regards
Inder Singh Rawat
Re: MS SQL 2008 backup monitoring via Nagios
Posted: Tue Jun 25, 2013 9:42 am
by slansing
What patch are you referring to?
Re: MS SQL 2008 backup monitoring via Nagios
Posted: Fri Jun 28, 2013 2:14 am
by inderraw
Dear Team,
I am looking for patch, what i have to install in MSSQL server to monitor that.
(I have to monitor MSSQL backup success or failure).
Regards,
Inder Singh Rawat.
Re: MS SQL 2008 backup monitoring via Nagios
Posted: Fri Jun 28, 2013 9:27 am
by slansing
I am looking for patch, what i have to install in MSSQL server to monitor that.
We need a bit more detail than this, we need to know if you are trying to patch MSSQL, if you are trying to monitor for new patches, or if you are trying to monitor when it has been patched.