HP 3PAR Application Software Suite for Microsoft SQL Licenses - Manual (Page 60)

RMSql restore
SYNTAX
RMSql restore -s <SQL server> [-i <instance>] [-d <database>]-t
<timestamp> [-ts <target server>] [-M <masterServer>] [-a <altLocation>]
[-snap] [-noemail] [-norecovery] [-clonedb] [-dp]
DESCRIPTION
You can use the RMSql restore command to perform 3 different types of restore:
•
Media Restore - Using an existing backup entry, Recovery Manager for Microsoft SQL Server
issues a restore request to the backup software in use (Symantec NetBackup or HP Data
Protector). The image associated with this backup entry is then restored to the location you
specify. If you do not specify an alternate location, data is restored to
SystemDrive:\3parSnapshot
by default.
•
File Copy Restore - Using an existing virtual copy, Recovery Manager for Microsoft SQL Server
mounts the copy, extracts the database files, and copies the files back to their original locations.
Because the files are copied over one by one, File Copy Restore is a relatively slow but reliable
way of restoring data.
•
Volume Restore - Using an existing virtual copy, Recovery Manager for Microsoft SQL Server
removes the existing VLUNs, promotes the virtual copy back to its base volume, and re-creates
the VLUNs back to the host. Volume Restore is relatively fast. However, you should not perform
this restore if the base volumes you are promoting contain data from other instances or
databases.
NOTE: For more information about performing an instance-level file copy restore in an MSCS
environment, see Restoring a SQL Instance in an MSCS Environment Using File Copy Restore.
NOTE: For more information about performing a volume restore in an MSCS environment, see
Restoring a Volume in an MSCS Environment Using Volume Restore.
PARAMETERS
The following options are supported:
-s <SQL server> The SQL server to which the database belongs.
-i <SQL instance Optional. The SQL server instance to which the database
belongs. If not specified, MSSQLSERVER is used as the
default.
-d <database> Optional. The database from which to create a virtual
copy. If not specified, an instance-level restore is performed
by default.
-t <timestamp> The timestamp for the virtual copy to restore.
-ts <target server> Optional. (Symantec NetBackup Media Restore only) The
target server for the restore request. If not specified, the
current server name is used as the default.
-M <masterServer> Optional. (Media Restore only) The Symantec NetBackup
master server name. Valid only if the backup software in
use is Symantec NetBackup.
Optional: If not specified, the current server name is used
as the default.
-a <altLocation> Optional. An alternate location to which to restore the
data. If not specified, data is restored to
<SystemDrive>:\3parSnapshot
by default.
60 Using the Recovery Manager CLI