FAQShop.com : Monitoring for Successful SQL Backups

Monitoring for Successful SQL Backups

I’m able to Monitor SQL Backup failed events but I’m unable to monitor SQL backup Successful events. When I see the SQL Management rules database the file backed up rule is existing. When I take a backup its writing into the Event log but not showing in the MOM console.

Contributed By: Tom Keane (MSFT)
The SQL Server Management Pack does not have any rules out of the box which will alert on the successful completion of a backup.

Assuming you are using SQL Server 2000, you can create a new rule to alert on the successful completion of a backup. A successful backup will log an event to the Windows Event Log which can be collected by MOM. The new rule should be a standard Event Collection Rule, with the following properties:

Provider Name - Application

Provider Type - Windows NT Event Log

Criteria: (note all criteria will need to be defined using the Advanced button)
-Event Number
--Matches Boolean Regular Expression
---17052|17055

-Source Name
--Matches Wildcard
--- MSSQL*

-Description
--Matches Boolean Regular Expression
--- ((^.*18264 and (not ^.*\n.*18264)) or
(^.*18264.*\n.*18264)) AND (NOT ^.*[0-9]+.*18264) AND
(NOT ^.*18264[0-9]+)

If you would like this rule to alert, you can define an alert and alert severity in the rule properties in MOM.