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

Page 56

Advertising
background image

HpRmCli Sql backup

SYNTAX

HpRmCli Sql backup -s <SQL server> [-i <SQL instance>] [-d <database>]

[-t <timestamp> | -r ] [-ts <target server>][[-p <policyName> -u

<scheduleName> -M <masterServer>]|[-dl <datalistName>]|[-be mediaserver

<mediaservername> -device <devicename>]] [-noemail]

DESCRIPTION

The HpRmCli Sql backup command backs up a virtual copy to the specified media. The backup
can be an existing virtual copy, or it can be a new virtual copy created by this command.

PARAMETERS

The following options are supported:

-s <SQL Server>

The SQL server associated with the database.

-i <SQL instance>

Optional. The SQL server instance associated with the database.
If not specified, MSSQLSERVER (local) is used as the default value.

-d <database>

Optional. The database for the virtual copy. If not specified, the
instance for the virtual copy is used as the default value.

-t <timestamp>

Optional. The timestamp of the virtual copy to back up. If not
specified, the system creates a point-in-time virtual copy, uses it to
create the backup, and then removes this virtual copy after the
backup is complete. If specified, the system retains this timestamp
value after the backup is complete.

-r

Optional. Retain the virtual copy. Valid only if you do not use the
-t

option. If not specified, the virtual copy is deleted after backup

is complete.

-ts <target server>

Optional. Target Server for the backups if the -r option is not
specified. To use this option, the following must be located at the
secondary site:

Recovery Manager Backup Component server, with HP 3PAR
Recovery Manager for Microsoft SQL Server installed

Symantec NetBackup client or HP Data Protector

If not specified, the local system is used as the default value.

-p <policyName>

Symantec NetBackup policy name. Only valid if Symantec
NetBackup software is in use.

-u <ScheduleName>

Name of the NetBackup backup schedule. Only valid if Symantec
NetBackup software is in use.

-M <masterServer>

NetBackup master server name. Only valid if Symantec NetBackup
software is in use.

-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 backup if configured. For more information, see
Configuring Email Notifications.

-dl <DataListName>

Specifies the data list name (also called as the backup specification
name) and indicates that the backup software in use is HP Data
Protector.

Optional: If not specified, Recovery Manager proceeds as if the
backup software used is Symantec NetBackup.

56

Using the Recovery Manager CLI

Advertising