Software Suite for Microsoft SQL Licenses User guide

RMSql analyze
SYNTAX
RMSql analyze -s <SQL server> [-sync] [-f]
DESCRIPTION
The RMSql analyze command validates all virtual copy records by matching virtual copies in
the HP 3PAR Storage System against records in the Recovery Manager for SQL repository. If any
existing virtual copies in the system are missing from the repository, Recovery Manager for SQL
displays them as out-of-sync records. Likewise, if any existing virtual copies in the repository are
missing from the system, Recovery Manager for SQL also displays them as out-of-sync records.
PARAMETERS
The following options are supported:
-s <SQL Server> The SQL server to which the database belongs.
-sync Optional. Remove out-of-sync virtual copies from the repository. If not
specified, out-of-sync virtual copies remain in the repository.
-f Optional. Forcefully remove out-of-sync records from the repository. You
must use this option in conjunction with the -sync option. If not specified,
the system requires you to confirm the removal of out-of-sync virtual copies.
NOTE: When you use the -f option, Recovery Manager automatically removes out-of-sync
records without prompting for confirmation.
EXAMPLES
The following example validates all virtual copies under the specified SQL server.
RMSql analyze -s <SQLserver>
Recovery Manager Commands 43