Hprmcli sql create – HP 3PAR Recovery Manager Software User Manual

Page 57

Advertising
background image

-be

Backup software specified is Symantec Backup Exec.

Optional: If not specified, HP 3PAR Recovery Manager for SQL
proceeds as if the backup software used is Symantec NetBackup.

-mediaserver

<mediaservername>

Backup Exec media server name. Only valid if Symantec Backup
Exec software is in use.

-device <devicename>

Backup Exec device name configured for Backup. Only valid if
Symantec Backup Exec software is in use.

EXAMPLE

The following command performs a backup of virtual copy 020405162103 with the necessary
Symantec NetBackup parameters.

HpRmCli Sql backup -s inst1 -d test_db -t 020405162103 -p test -u full

-M host1

NOTE:

Use quotes ("") when an option value includes spaces.

NOTE:

During backup, snapshot volumes of the virtual copy are surfaced to the operating system

with a default mount point under the <SystemDrive>:\3parsnapshot directory. Therefore,
<SystemDrive>

must use NTFS in order to support the volume mount point.

NOTE:

You can execute concurrent backup jobs through multiple Recovery Manager CLI instances.

HpRmCli Sql create

SYNTAX

HpRmCli Sql 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 HpRmCli Sql 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 HpRmCli Sql create command used with –rc parameter synchronizes the volumes in
periodic Remote Copy group where a single SQL database or all of the SQL databases under an
instance reside and creates virtual copies at the secondary site as a backup.

As with HP 3PAR Recovery Manager for Microsoft 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

Recovery Manager Commands

57

Advertising