Rmsql display – HP 3PAR Recovery Manager Software for Microsoft SQL Server Licenses User Manual

Page 48

Advertising
background image

RMSql display

SYNTAX

RMSql display -s <SQL server> [-rc <target server>] [-i <SQL instance>]

[-d <database>] [-t <timestamp>]

DESCRIPTION

The RMSql display command displays all virtual copies in the server at a local site or 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
Recovery Manager for SQL Server installed, must be located at the
secondary site. If not specified, the local site is used as the default
value.

-t <timestamp>

Optional. Display detailed information about a specific virtual copy
in the local repository. If not specified, Recovery Manager displays
information about all virtual copies.

NOTE:

Recovery Manager does not support using the command RMSql 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.

RMSql 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 RMSql display command,

the Database column displays all to indicate that Recovery Manager has created virtual copies
of all databases except the Temp database.

48

Using the Recovery Manager CLI

Advertising
This manual is related to the following products: