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

c. If you want to restore the clone database to a location other than its parent location, enter
the directory path to the alternate database In the Alternate Path text box. Note that if
you enter an alternate location, you must enter an alternate name in the Database Name
text box.
If you leave this text box blank, the clone database is restored to the parent location of
the original virtual copy.
d. To use the point-of-failure recovery method to restore the database, check the No Recovery
checkbox. For more information about completing a point-of-failure recovery, see
“Recovering All Data with Point-of-Failure Recovery” (page 66) .
To use the auto-restore feature for restoring a database to the point of failure, select the
latest virtual copy and click the Point of failure radio button to proceed.
4. To confirm you understand the warning and the ramifications of proceeding with the restore,
check the Click to continue checkbox.
5. Click OK.
Depending on whether you restored the virtual copy to its parent location or created a clone
database, Recovery Manager does the following:
•
If you restored the virtual copy to its parent location, Recovery Manager completely
overwrites the instance or database with the virtual copy. The instance or database is
now restored.
•
If you restored the virtual copy with an alternate database name but you did not specify
an alternate database path, Recovery Manager copies the virtual copy to the specified
clone database name (at the parent location) and attaches the database.
•
If you restored the virtual copy with an alternate database name with an alternate database
path, Recovery Manager copies the virtual copy to the specified clone database name
at the alternate location and attaches the database.
6. To perform a selective database restore of an instance, locate the Virtual Copy Management
node under the node tree pane.
a.
Select the instance level timestamp of the virtual copy for restore and right-click.
b. Select Restore Using
→File Copy..
c. Deselect any applicable checkbox of databases not being restored before you proceed.
Restoring an Instance or Database from a Backup
You can restore backups to their original location (i.e., to the instance or database location of the
virtual copy that was used to create the backup, not to the original SQL database or instance
location), or you can specify an alternate location.
1.
Under the Backup Management node in the node tree pane, right-click the timestamp for the
backup you want to use for the restore, and select Restore.
By default, Recovery Manager restores the backed-up virtual copy to its original location,
which is displayed in the Alternate Location text box. The original location is either the directory
C:\3parSnapshot or F:\3parSnapshot, depending on your system drive.
2. If you want to restore the virtual copy to a different location, enter the alternate location in the
Alternate Location text box or select a location from the file chooser.
3. Click OK.
The backup software mounts the backup to the specified location as a virtual copy. To complete
the instance or database restore, move the virtual copy to the volume or database.
40 Using the Recovery Manager GUI