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

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 69) .
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.
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.
Analyzing and Synchronizing the Repository
You can use Recovery Manager to compare and synchronize virtual copies in the Recovery Manager
repository with the HP 3PAR Storage System.
1.
In the node tree pane, right-click the SQL production server, and select Analyze.
2. To automatically synchronize the HP 3PAR Storage System and the repository (if necessary),
check the Synchronize result with Repository checkbox.
To analyze the repository without synchronizing it, leave the Synchronize result with Repository
checkbox unchecked.
40 Using the Recovery Manager GUI