HP 10400 Application Software Suite for Microsoft SQL Media LTU manual RMSql restore, AltLocation

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