HP 7450 Application Software Suite Microsoft SQL Media LTU manual RMSql create

RMSql create

SYNTAX

RMSql create -s <SQL server> [-rc <target server> [-w <waittime>]][-i <SQL instance>] [-d <database>] [-noemail] [-exp <time>{hHdD}] [-retain <time>{hHdD}] [-f]

DESCRIPTION

The RMSql create command creates a virtual copy of a SQL database or databases under an instance on the primary host where the SQL server instance is running. (The virtual copy can be mounted to a host later for off-host processing.)

The RMSql create command also allows the user to create a synchronization in periodic mode to a Remote Copy volume group where a single SQL database or all of the SQL databases under an instance are defined, and create another virtual copy at the secondary site as a backup.

As with Recovery Manager for SQL Server itself, this command only supports the online backup of an entire SQL database. Therefore, you must make sure the database is online before creating a virtual copy.

PARAMETERS

The following options are supported:

-s <SQL server>	SQL server to which the database belongs.
-i <SQL instance>	Optional. SQL server instance to which the database belongs. If
	not specified, MSSQLSERVER is used as the default.
-d <database>	Optional. The database from which to create a virtual copy. If not
	specified, the instance level of the virtual copy is used as the default.
-w <waittime>	Optional. Wait time in seconds. Recovery Manager uses this wait
	time to poll the status of the remote copy before creating a virtual
	copy at the secondary site. If not specified, the wait time is 120
	seconds by default.
-rc <target server>	Remote Copy target server. To use this option, the Recovery
	Manager Backup Component server, with Recovery Manager for
	SQL Server installed, must be located at the secondary site.
-noemail	Optional. Do not send an email notification even if configured for
	this operation. If not specified, Recovery Manager sends an email
	notification of the virtual copy creation if configured. For more
	information, see Configuring Email Notifications.
-exp <time>{hHdD}	Optional. Set the expiration time for this virtual copy to the specified
	time and time unit. Valid values are:
	• To set the expiration time in hours: 1-43800h (or H)
	• To set the expiration time in days: 1-1825d (or D)
	• To remove the expiration period: 0
	To use this option, the Recovery Manager for SQL policy must be
	set to an expiration-based policy.
	If not specified, Recovery Manager for SQL creates the virtual copy
	using the expiration time specified in the current policy.
-retain	Optional. Set or extend the retention time for the specified virtual
<time>{hHdD}	copy to the specified time. The virtual copy cannot be removed
	during this time period.

46 Using the Recovery Manager CLI