HP 3PAR Application Software Suite for Microsoft SQL Licenses - Manual (Page 53)

RMSql policy
SYNTAX
RMSql policy -s [-i ] [-q] [-exp
{h|H|d|D}] [-in ][-n
copy limit>] [<-r>] [-retain {h|H|d|D}] [-f]
DESCRIPTION
The RMSql policy command sets the Recovery Manager policy at the instance and database
level.
PARAMETERS
The following options are supported:
-s SQL server to which the database belongs.
-i 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 Optional. The maximum number of
database-level virtual copies to retain. If not
specified, a maximum of 10 is used as the
default.
-in 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 {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 53