HP StoreServ Application Suite for Microsoft SQL E-Media manual AltLocation -snap

Models: StoreServ Application Suite for Microsoft SQL E-Media StoreServ Application Suite for Microsoft SQL Media

1 136
Download 136 pages 3.05 Kb
Page 96
Image 96

3PAR Recovery Manager 3.0.2 for Microsoft SQL Server User’s Guide

COMMAND

RMSql restore

SYNTAX

RMSql restore -s <SQL Server> [-i <instance>] [-d <database>] -t <timestamp> [-ts <target server>] [-M <masterServer>]

[-a <altLocation>] [-snap]

DESCRIPTION

The RMSql restore command can be used to perform 3 different types of restore:

Media Restore. Using a backup entry that was previously created, the Recovery Manager issues a restore request to NetBackup. The image associated with this backup entry will be

restored to a location of user's choice. If no alternate location is specified, data will be restored to <SystemDrive>:\3parSnapshot.

File Copy Restore. Using a virtual copy that was previously created, the Recovery Manager mounts it, extracts out the database files, and copies them back to their original locations. This is a relatively slow but reliable way of restoring because the files are copied over one by one.

Volume Restore. Using a virtual copy that was previously created, the Recovery Manager removes the existing VLUNs, promotes the snapshot back to its base volumes, and re- creates the VLUNs back to the host. The volume restore is relatively fast. However, do not perform this restore if the base volumes being promoted contain data from other instances or databases.

NOTE: For more information about an instance level file copy restore in an MSCS environment, see SQL Instance Level File Copy Restore in an MSCS Environment on page 8.4.

NOTE: For more information about volume restore in an MSCS environment, see SQL Instance Level File Copy Restore in an MSCS Environment on page 8.4.

7.16

PARAMETERS

The following options are supported:

Recovery Manager Commands

3PAR Confidential

Page 96
Image 96
HP StoreServ Application Suite for Microsoft SQL E-Media manual AltLocation -snap