Export (0) Print
Expand All

SQL Server recovery issues

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

The following table provides troubleshooting guidance on recovery issues for computers running SQL Server.

SQL Server Recovery Issues

 

Issue Possible Cause Resolution

Unable to recover from secondary server because replica is in inconsistent state.

If the database you are trying to recover was collocated, and protection for one of them was stopped on the primary server and its data deleted, then you cannot recover the deleted database from the replica on the secondary.

Run a consistency check on the replica volume.

The database recovery fails.

If you recover a SQL Server database by selecting the latest recovery point and then perform another recovery using the latest recovery point, the database recovery will fail.

When you recover a SQL Server database using the latest recovery point, DPM performs the recovery using the SQL Server logs that are available on the protected server. After you recover the database, you cannot perform another recovery using the latest recovery point until you perform a synchronization with consistency check.

However, you can recover to a recovery point listed just prior to the latest recovery point. In this case, you will recover the database to the latest available recovery point on the DPM server; however, the logs on the SQL Server will not be utilized. This is because the logs on the SQL Server were already used as part of the latest point recovery that you performed earlier.

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