MS SQL 2008 backup monitoring via Nagios

[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

[abrist]

How are you backing up the db? A custom script? Is it scheduled?

[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

[abrist]

Is the backup getting logged to the event log, or a separate file?

[inderraw]

Yes, it is getting logged in event log and backup happening in seprate drive.

Regards
Inder Singh

[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.

[inderraw]

Dear Team,

From where i can download patch for mssql database.

Regards
Inder Singh Rawat

[slansing]

What patch are you referring to?

[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.

[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.