HP 7450 Application Software Suite Microsoft SQL Media LTU manual RMSql analyze, SQL Server, Sync

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 -syncoption. If not specified,
	the system requires you to confirm the removal of out-of-sync virtual copies.

NOTE: When you use the -foption, 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