HP 3PAR Recovery Manager Software for Microsoft SQL Server Licenses User Manual
Page 50
2.
Under the Virtual Copy Management node in the node tree pane, right-click the timestamp of
the virtual copy you want to use for the restore, and select Restore Using
→File Copy.
NOTE:
The Vendor Restore Method field of the File Copy Restore dialog box automatically
displays Virtual Copy (File Copy).
By default, Recovery Manager restores the virtual copy to its parent instance or database
(specified in the Target Server field).
3.
To restore a virtual copy of a database to a database different from its parent database, you
can specify an alternate database as the target of the restore:
a.
In the Database Restore Option area of the File Copy Restore dialog box, select Clone
Database.
b.
In the Database Name text box, enter the name of the database to which you want the
virtual copy restored.
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, select No Recovery.
For more information about completing a point-of-failure recovery, see
Data with Point-of-Failure Recovery” (page 78)
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 that you want to continue with the restore process, select Click to continue.
5.
Click OK.
Depending on whether you restored the virtual copy to its parent location or created a clone
database, Recovery Manager does one of 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.
NOTE:
If the secondary replica node in the Microsoft SQL Server 2012 Availability Group
configuration becomes inaccessible during the restore process, then the user must manually
join the databases back to the Availability Group.
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.
Clear any applicable databases not being restored before you proceed.
50
Using the Recovery Manager GUI