HP Application Software Suite for Microsoft SQL manual RMSql policy, Database virtual copy limit

RMSql policy

SYNTAX

RMSql policy -s <SQL server> [-i <SQL instance>] [-q] [-exp <time>{hHdD}] [-in <instance virtual copy limit>][-n <database virtual copy limit>] [<-r>] [-retain <time>{hHdD}] [-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>	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
	-nand -inoptions cannot exceed 500.
-exp <time>{hHdD}	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