HP 3PAR Application Software Suite for Microsoft SQL Licenses - Manual (Page 46)

RMSql create
SYNTAX
RMSql create -s <SQL server> [-rc <target server> [-w <waittime>]][-i
<SQL instance>] [-d <database>] [-noemail] [-exp <time>{h|H|d|D}]
[-retain <time>{h|H|d|D}] [-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>{h|H|d|D} 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
<time>{h|H|d|D}
Optional. Set or extend the retention time for the specified virtual
copy to the specified time. The virtual copy cannot be removed
during this time period.
46 Using the Recovery Manager CLI