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

Page 63

Advertising
background image

HpRmCli Sql mount

Verify that the following conditions are complete before performing the mount operation:

•

The SQL server must be in healthy state for attach operation

•

The disk residing on the database must be online and visible

•

The original database must be online for the attach operation to succeed

•

The name of target server and the SQL server must be same for attach operation to succeed

•

The secondary database files (.mdf), as a part of original database, are also available in the
attached database

•

If an SQL instance is running in a clustered environment, the snapshots of databases taken
from a particular SQL instance cannot be attached to the SQL instance running on the cluster
environment.

NOTE:

You cannot attach a data onto a cluster SQL instance because the data is on a separate

disk.

SYNTAX

HpRmCli Sql mount -s <SQL server> -t <timestamp> [-m <mount point>]

[-ts <host name>] [-a <attachDatabaseName> -i <instanceName> -d

<OriginalDatabaseName> ]

DESCRIPTION

The HpRmCli Sql mount command mounts a virtual copy created by the HpRmCli Sql
create

command.

To mount a virtual copy, you must create an available mount point on the NTFS volume before you
execute the command.

If necessary, use -a option to attach a database to the SQL server.

PARAMETERS

The following options are supported:

-s <SQL server>

The SQL server associated with the database.

-i <SQL instance>

Optional. SQL server instance belonging to the specified database. If
not specified, MSSQLSERVER (local) is used as the default and valid
only if –a option is specified.

-d <database>

Optional. Original Database to be attached. Valid only if –a option is
specified.

-t <timestamp>

The timestamp for the virtual copy to be mounted.

-m <mount point>

Optional. The mount point for virtual copy devices. If not specified,
%SystemDrive%\3parSnapshot

is used as the default mount point.

-ts <hostname>

Optional. The name of the host on which to mount the virtual copy. If
not specified, the local host is used as the default mount point.

-a <attach

database>

Optional. New name of the database to be attached.

WARNING!

If you mount a volume with the HpRmCli Sql mount command, you must unmount

the volume with the HpRmCli Sql unmount command. Do not manually unmount a volume that
was mounted with the HpRmCli Sql mount command.

Recovery Manager Commands

63

Advertising