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
-
From the CommCell Browser, expand Policies.
-
Right-click Monitoring Policies and then click New Monitoring Policy.
-
Follow the instructions in the New Monitoring Policy wizard.
-
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.
-
On the Please specify criteria page, select Specify criteria and then click Add:
In the Create Criteria dialog box, specify the filtering attributes:
-
For the Description filtering attribute, select the contains operator and type Database backed up. Database: master.
-
Click OK.
-
-
After completing the wizard, click Finish to create the monitoring policy.