HP 3PAR Recovery Manager Software for Microsoft SQL Server Licenses - Manual (Page 50)

RMSql mount
Before you begin, verify 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 is 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 (.ndf) as part of original database is also available in the attached
database
•
If a SQL instance in 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
RMSql mount -s <SQL server> -t <timestamp> [-m <mount point>] [-ts <host
name>] [-a <attachDatabaseName> -i <instanceName> -d
<OriginalDatabaseName> ]
DESCRIPTION
The RMSql mount command mounts a virtual copy created by the RMSql 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 RMSql mount command, you must unmount the
volume with the RMSql unmount command. Do not manually unmount a volume that was mounted
with the RMSql mount command.
50 Using the Recovery Manager CLI