Rmsql restore – HP 3PAR Application Software Suite for Microsoft SQL Licenses User Manual
Page 60
RMSql restore
SYNTAX
RMSql restore -s
[-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
The SQL server to which the database belongs.
-i Optional. The SQL server instance to which the database -d Optional. The database from which to create a virtual -t The timestamp for the virtual copy to restore. -ts Optional. (Symantec NetBackup Media Restore only) The -M Optional. (Media Restore only) The Symantec NetBackup Optional: If not specified, the current server name is used -a Optional. An alternate location to which to restore the by default. 60 Using the Recovery Manager CLI
belongs. If not specified, MSSQLSERVER is used as the
default.
copy. If not specified, an instance-level restore is performed
by default.
target server for the restore request. If not specified, the
current server name is used as the default.
master server name. Valid only if the backup software in
use is Symantec NetBackup.
as the default.
data. If not specified, data is restored to