A backup policy determines how backup versions are retained.
You can add, update, delete, or change the processing order of existing
binding statements.
Procedure
- From the Management Console, select the SQL
Server instance from the tree view.
- On the Protect tab, click Properties in
the Action pane.
- Select VSS Policy Binding from the
list of available property pages.
- 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.
- 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.
- Save any new or changed binding statement.
- Optional: Verify new or updated policies and
bindings.
- Run one or more test backups.
- In the Recover tab, verify the
management classes that are bound to your test backups.