HP 3PAR Recovery Manager Software - Manual (Page 65)

HpRmCli Sql policy
SYNTAX
HpRmCli Sql policy -s <SQL server> [-i <SQL instance>] [-q] [-exp
<time>{h|H|d|D}] [-in <instance virtual copy limit>][-n <database virtual
copy limit>] [<-r>] [-retain <time>{h|H|d|D}] [-f]
DESCRIPTION
The HpRmCli Sql policy command sets the Recovery Manager policy at the instance and the
database level.
PARAMETERS
The following options are supported:
-s <SQL server> SQL server to which the database belongs.
-i <SQL instance> Optional. The SQL server instance to which
the database belongs. If not specified,
MSSQLSERVER (local) is used as the default.
-r Optional. Retain the oldest virtual copy even
when the number of virtual copies exceeds the
limit set by the Recovery Manager policy. If
you specify this option, Recovery Manager
cannot create new virtual copies after the
maximum copies allowed is reached (unless
you manually remove one or more older virtual
copies). If not specified, Recovery Manager
removes virtual copies.
-q Optional. Query current policy status. If not
specified, the current policy status is not
displayed.
-n <database virtual copy limit> Optional. The maximum number of
database-level virtual copies to retain. If not
specified, a maximum of 10 is used as the
default.
-in <instance virtual copy limit> Optional. The maximum number of
instance-level virtual copies to retain. If not
specified, a maximum of 10 is used as the
default.
NOTE: The sum of the values used for the
-n and -in options cannot exceed 500.
-exp <time>{h|H|d|D} Optional. If the policy is expiration-based, set
the expiration time to the specified time and
time unit. Valid values are:
•
To set the expiration time in hours:
1-43800h (or H)
•
To set the expiration time in days:
1-1825d (or D)
If not specified, the expiration time does not
change.
Recovery Manager Commands 65