How to Recover and Rename a SQL Database

  • 發行項

適用於: System Center Data Protection Manager 2010

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

  1. In DPM Administrator Console, click Recovery on the navigation bar.

  2. Using either the browse or search functionality, select the database to recover.

  3. 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.

  4. On the Recovery time menu, select the recovery point you want to use. Do not select Latest for the recovery point.

  5. In the Actions pane, click Recover.

    The Recovery Wizard launches.

  6. On the Review recovery selection page, click Next.

  7. Select Recover to any SQL instance, and then click Next.

  8. On the Specify recovery destination page, enter the path to recover the database to, and specify a new name for the recovered database.

  9. Specify recovery options for network bandwidth usage throttling, SAN-based recovery, and e-mail notifications, and then click Next.

  10. On the Summary page, review the recovery settings, and then click Recover.

另請參閱

概念

How to Recover a SQL Database to Its Original Location
How to Recover a Database to a Different Instance of SQL Server
How to Copy a SQL Database to a Network Folder
How to Copy a SQL Database to Tape
How to Recover a SQL Database and Allow Additional Log Backups