HP 3PAR Recovery Manager Software - Manual (Page 61)

HpRmCli Sql display
SYNTAX
HpRmCli Sql display -s <SQL server> [-rc <target server>] [-i <SQL
instance>] [-d <database>] [-t <timestamp>]
DESCRIPTION
The HpRmCli Sql display command displays all virtual copies in the server at a local site or
a remote site.
PARAMETERS
The following options are supported:
-s <SQL server> SQL server associated with the database.
-i <SQL instance> Optional. The SQL instance associated with the database. If not
specified, MSSQLSERVER is used as the default value.
-d <database> Optional. Display the virtual copies created for a given database.
If not specified, all database and instance virtual copies belonging
to the SQL server are displayed by default.
-rc <target server> Optional. The Remote Copy target server at secondary site. To use
this option, the Recovery Manager Backup Component server, with
HP 3PAR Recovery Manager for Microsoft SQL Server installed,
must be located at the secondary site. If not specified, the local site
is used as the default value. Availability Group information is not
displayed for virtual copies at a remote site.
-t <timestamp> Optional. Display detailed information about a specific virtual copy
in the local repository. If no virtual copy is specified, Recovery
Manager displays information about all virtual copies. For
availability database virtual copy with the timestamp, the availability
group information is not displayed when this option is specified. If
this option is not specified, availability group information is
displayed for all the availability database virtual copies listed by
the command.
NOTE: Recovery Manager does not support using the command HpRmCli Sql display -t
for display of information about a virtual copy that exists at a secondary site.
The following command displays the virtual copies for server1.
HpRmCli Sql display -s server1
NOTE: Use quotes ("") when an option value includes spaces.
NOTE: If you create an instance level virtual copy and then issue the HpRmCli Sql display
command, the Database column displays all to indicate that Recovery Manager has created
virtual copies of all databases except the Temp database.
Recovery Manager Commands 61