IBM Tivoli Storage Manager for Databases, Data Protection for Microsoft SQL Server, Version 7.1

Policy binding statements

Policy binding statements associate SQL backups to a management policy.

About this task

Although Tivoli® Storage Manager policy determines how Data Protection for SQL Server backups are managed on Tivoli Storage Manager storage, backup retention on local shadow volumes is determined by version and time-based policies. Ensure that sufficient local storage space is available on local shadow volumes for a VSS backup. Ensure that there is enough available storage space assigned to the volumes to accommodate your backup operations. The shadow copy volume that is the storage destination of a snapshot must have sufficient space for the snapshot. Environment and storage resources also affect how many backup versions are maintained on local shadow volumes. The amount of space required is dependent on the VSS provider that is used.

Specify policy binding statements to use for binding snapshots to a policy. You can specify policy binding statements by using the GUI or by manually adding binding statements to the configuration file. 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.

A policy statement is defined in the respective configuration file. For example:
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


Feedback