Hprmcli sql mount – HP 3PAR Recovery Manager Software User 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
[-ts
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
The SQL server associated with the database.
-i
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
Optional. Original Database to be attached. Valid only if –a option is
specified.
-t
The timestamp for the virtual copy to be mounted.
-m
Optional. The mount point for virtual copy devices. If not specified,
%SystemDrive%\3parSnapshot
is used as the default mount point.
-ts
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 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 Recovery Manager Commands 63
was mounted with the HpRmCli Sql mount command.