User's Manual

7.20
Recovery Manager Commands
3PAR Recovery Manager 3.0.2 for Microsoft SQL Server User’s Guide
3PAR Confidential
COMMAND
RMSql policy
SYNTAX
RMSql policy -s <SQL Server> [-q] [-i <SQL instance>]
[<-r>] [-n <database level policy>][-in <instance level policy>]
DESCRIPTION
The RMSql policy command sets the policy at instance and database level.
PARAMETERS
The following options are supported:
◆ -s <SQL Server> - The SQL server to which the database belongs.
◆ -i <SQL instance> - This is an optional argument: The SQL server instance to which
the database belongs. MSSQLSERVER (local) will be used, if the default is not specified.
◆ -r - Optional: Retain the oldest Virtual Copy when the number of Virtual Copies
exceeds the limit. Default is set to retain.
◆ -q - Query current policy status.
◆ -n <database level policy> - Maximum number of database level virtual copies to
be retained.
◆ -in <instance level policy> - Maximum number of instance level virtual copies to
be retained.
EXAMPLE
The following command maintains the maximum number of virtual copies to 5 at all times for
the default SQL instance:
RMSql policy –n 5 -s <SQL Server>
NOTE: The sum of -n and -in can not exceed 500.