.png)
How to Recover and Rename a SQL Database
Updated: January 15, 2013
Applies To: System Center 2012 - Data Protection Manager, System Center 2012 SP1 - Data Protection Manager
To recover and rename a database, use the Recover to any SQL instance option. This option is unavailable if you select Latest as the recovery point from which to recover the database.
To recover and rename a database
-
In DPM Administrator Console, click Recovery on the navigation bar.
-
Using either the browse or search functionality, select the database to recover.
-
On the calendar, click any date in bold to obtain the recovery points available for that date. The Recovery time menu lists the time for each available recovery point.
-
On the Recovery time menu, select the recovery point you want to use. Do not select Latest for the recovery point.
-
In the Actions pane, click Recover.
The Recovery Wizard launches.
-
On the Review recovery selection page, click Next.
-
Select Recover to any SQL instance, and then click Next.
-
On the Specify recovery destination page, enter the path to recover the database to, and specify a new name for the recovered database.
-
Specify recovery options for network bandwidth usage throttling, SAN-based recovery, and e-mail notifications, and then click Next.
-
On the Summary page, review the recovery settings, and then click Recover.
See Also
-----
For additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
