Example: Creating a Monitoring Policy to Track SQL Database Backups

This sample covers creating a monitoring policy to track 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.

3. Follow the instructions in the New Monitoring Policy wizard.

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

   We recommend that you create a template for SQL logs. To see a sample template for SQL logs, see Creating a Monitoring Policy Template for SQL Server Logs.

5. 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. Click OK.

6. After completing the wizard, click Finish to create the monitoring policy.