HP 7450 Application Software Suite Microsoft SQL Media LTU manual

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