User's Manual

7.10
Recovery Manager Commands
3PAR Recovery Manager 3.0.2 for Microsoft SQL Server User’s Guide
3PAR Confidential
COMMAND
RMSql analyze
SYNTAX
RMSql analyze -s <SQL Server> [-sync] [-f]
DESCRIPTION
The RMSql analyze command validates all snapshot records by matching virtual volumes in
the InServ Storage Server against records in the Recovery Manager repository. If any existing
virtual volumes in the InServ are missing from the repository, they are displayed as out-of-sync
records. For any records in the repository, if their corresponding virtual volumes are no longer
in the InServ, they will also be displayed as out-of-sync records.
PARAMETERS
The following options are supported:
-s <SQL Server> - SQL server to which the database belongs.
-sync - Optional: with this flag, out-of-sync snapshot records in the repository will be
removed.
-f - Optional: when this flag is used in conjunction with -sync, out-of-sync records in the
repository will be forcefully removed.
EXAMPLES
The following example validates all snapshots under the specified SQL server.
RMSql analyze -s <SQLserver>
NOTE: When the -f parameter is used, Recovery Manager automatically starts
removing out-of-sync records without prompting for any confirmation. Please use
this parameter with caution.
NOTE: If the Backup server has a mixture of instance level snapshots and database
level snapshots within the same instance, user is expected to see out-of-sync VV
list caused by the snapshots taken at different level.