Export (0) Print
Expand All

Recover SQL Server data in DPM

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

When you recover SQL Server data, you can choose from the following options:

  • Recover the database to its original location

  • Recover the database with a new name to its original location or to a different instance of SQL Server

  • Recover the database to a different instance of SQL Server

  • Copy the database to a network folder

  • Copy the database to tape

When you recover a SQL Server 2000 database to a different instance of SQL Server, the recovery path on the new server must be the same as the path of the database when it was protected on the source server. For example, DB1 on D:\sample on server1 can be recovered only to D:\sample on server2. If you want to recover to a completely new path, then you will only be able to recover express full backups (typically one copy per day).

When you recover a SQL Server 2005 database to a different instance of SQL Server, you can recover the database to any chosen path on the new server. You can back up once every 15 minutes and recover to any point in time on the target SQL Server.

In both SQL Server 2000 and SQL Server 2005, you can rename the database and recover to the original SQL instance.

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 system database to a different instance of SQL Server.

In This Section

-----
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.
-----
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft