HP 3PAR Recovery Manager Software - Manual (Page 63)

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