![](/images/new-backgrounds/1220471/220471105x1.webp)
RMSql policy
SYNTAX
RMSql policy
DESCRIPTION
The RMSql policy command sets the Recovery Manager policy at the instance and database level.
PARAMETERS
The following options are supported: |
|
| SQL server to which the database belongs. |
| Optional. The SQL server instance to which |
| the database belongs. If not specified, |
| MSSQLSERVER (local) is used as the default. |
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. |
Optional. Query current policy status. If not | |
| specified, the current policy status is not |
| displayed. |
| Optional. The maximum number of |
| |
| specified, a maximum of 10 is used as the |
| default. |
| Optional. The maximum number of |
| |
| specified, a maximum of 10 is used as the |
| default. |
| NOTE: The sum of the values used for the |
| |
| Optional. If the policy is |
| the expiration time to the specified time and |
| time unit. Valid values are: |
| • To set the expiration time in hours: |
| |
| • To set the expiration time in days: |
| |
| If not specified, the expiration time does not |
| change. |
Recovery Manager Commands 53