Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to Recover a Database to a Different Instance of SQL Server

Updated: November 1, 2013

Applies To: System Center 2012 - Data Protection Manager, System Center 2012 R2 Data Protection Manager, System Center 2012 SP1 - Data Protection Manager

To recover a database to a different instance of SQL Server, you 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.

noteNote
When recovering a databases to a different instance of SQL Server

  • You cannot recover a database from an instance of SQL Server on a computer running Windows Server 2008 to an instance of SQL Server on a computer running Windows Server 2003.

  • You cannot recover a SQL Server 2008 database to a SQL Server 2005 instance.

To recover a database to a different instance of SQL Server

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

  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, the actions you can take depend on the version of SQL Server database:

    • If you are recovering a database created by SQL Server 2000, specify the alternate instance of SQL Server to which the database should be recovered. The database must use the same complete path that it used in its original location.

    • If you are recovering a database created by SQL Server 2005, specify the alternate instance of SQL Server to which the database should be recovered. You can also specify a path for the database that differs from the path that it used in its original location.

  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.

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.
-----
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.