Example: Creating a Monitoring Policy to Track SQL Database Backups

This sample covers creating a monitoring policy to receive email notifications when the master database of a SQL Server is successfully backed up.

The following is a sample line of a SQL log, confirming that the master database was backed up:

2014-09-11 16:03:30.65 Backup Database backed up. Database: master, creation date(time): 2014/09/06(12:02:17), pages dumped: 427, first LSN: 247:104:69, last LSN: 247:152:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{CE3D8C87-E6E4-41B2-939E-3AC982721737}5'}).

Procedure

  1. From the CommCell Browser, expand Policies.
  2. Right-click Monitoring Policies and then click New Monitoring Policy.

    Follow the instructions in the New Monitoring Policy wizard.

  3. On the Please select the type of monitoring policies you would like to create page, from the Please select the template list, select Simple Text Template.
  4. On the Please specify criteria page, select Specify criteria and then click Add.

    In the Create Criteria dialog box, specify the filtering attributes:

    1. For the Description filtering attribute, select the contains operator and type Database backed up. Database: master.
    2. To set the specified criteria as a minor event, under User Assigned Severity, select Information.
    3. Click OK.
  5. On the Alert Details page, click Add to set up an email alert using the monitoring criteria as the alert trigger.