HP Application Software Suite for Microsoft SQL manual RMSql display -s server1

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 -tfor 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.

50 Using the Recovery Manager CLI