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

Binding backups to a policy

A backup policy determines how backup versions are retained. You can add, update, delete, or change the processing order of existing binding statements.

Procedure

  1. From the Management Console, select the SQL Server instance from the tree view.
  2. On the Protect tab, click Properties in the Action pane.
  3. Select VSS Policy Binding from the list of available property pages.
  4. Add, update, delete, or change the processing order of existing binding statements.
    Tip:
    You can use a wildcard character (*) to mean "all". For example, specify a wildcard character (*) in the Server field to bind the policy to all SQL servers.
  5. Optional: Use Move Up and Move Down to modify the processing order. Policies are processed from the bottom up and processing stops at the first match. To ensure that more specific statements are processed at all, the more general specification should be listed before the more specific ones, so as to be processed after the more specific specifications. Otherwise, the more general specification will match the target before the more specific specifications are seen.
  6. Save any new or changed binding statement.
  7. Optional: Verify new or updated policies and bindings.
    1. Run one or more test backups.
    2. In the Recover tab, verify the management classes that are bound to your test backups.


Feedback