Specifying policy binding statements

Bind policy statements to associate Microsoft SQL Server backups to a management policy.

About this task

A default policy binds any backups that are not explicitly bound to a named policy. Policy binding is available in environments with or without a Tivoli® Storage Manager server.

Procedure

Specify the policy-binding statements to use to bind snapshots to a policy. Manually add the binding statements in the respective configuration file that defines the policy statements.

The way that you set policy is different for VSS and legacy backups:

VSS backups: Specify the VSSPOLICY statement in the Data Protection for SQL Server configuration file. By default, the configuration filename is tdpsql.cfg.
Legacy backups: Specify the INCLUDE and EXCLUDEstatements in the Data Protection for SQL Server options file. By default, the options filename is dsm.opt.

Policy-binding statements in the Data Protection for SQL Server configuration files might look similar to the information in the following table.

VSSPOLICY	`<server name>`	`<object name>`	`<backup type>`	`<backup dest>`	`<mgmt class>`
`VSSPOLICY`	`*`	`acctdb1`	`FULL`	`LOCAL`	`MC_1`
`VSSPOLICY`	`SERVER_3`	`hrdb`	`INCR`	`LOCAL`	`MC_6`