Article ID: 970642 - Last Review: September 11, 2011 - Revision: 2.0

Error when you use Data Protection Manager 2007 to protect a SQL Server database: "0x80990D11"

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Expand all | Collapse all

SYMPTOMS

When you protect a Microsoft SQL Server database by using Microsoft System Center Data Protection Manager 2007, the recovery point job fails, and the protection status for the SQL database is listed as "Recovery point creation failed."

Additionally, when you click the Alerts tab in the Data Protection Manager 2007 Administrator console, you see that the following error is logged:
Recovery point creation jobs for SQL Server 2005 database Server_name\Database_name on servername.domainname.com have been failing. The number of failed recovery point creation jobs = 1. If the datasource protected is SharePoint, then click on the Error Details to view the list of databases for which recovery point creation failed. (ID 3114) DPM tried to do a SQL log backup, either as part of a backup job or a recovery to latest point in time job. The SQL log backup job has detected a discontinuity in the SQL log chain for SQL Server 2005 database database Server_name\Database_name since the last backup. All incremental backup jobs will fail until an express full backup runs. (ID 30140 Details: Internal error code: 0x80990D11)
And when you click the Jobs tab in the Data Protection Manager 2007 Administrator console, you see that the following error is logged:
DPM tried to do a SQL log backup, either as part of a backup job or a recovery to latest point in time job. The SQL log backup job has detected a discontinuity in the SQL log chain for SQL Server 2005 database database Server_name\Database_name since the last backup. All incremental backup jobs will fail until an express full backup runs. (ID 30140 Details: Internal error code: 0x80990D11)
Back to the top

CAUSE

This problem occurs if backup software outside Data Protection Manager 2007 was used to back up the SQL database or databases, and the backup software was configured to perform a full backup.
Back to the top

RESOLUTION

If you must perform a backup of a SQL Server database by using backup software outside Data Protection Manager 2007, see the backup software documentation to learn how to configure a copy-only backup.

To correct the discontinuity in the SQL Server log chain, perform an express full backup. To do this, follow these steps:
  1. Open the Data Protection Manager Administrator console.
  2. Click the Protection tab.
  3. Right-click the SQL database that has a "Recovery point creation failed" protection status, and then click Create recovery point – Disk.
  4. In the Create recovery point dialog box, click Create a recovery point by using express full backup, and then click OK.
Note You must perform this procedure on all SQL databases that have a "Recovery point creation failed" protection status.
Back to the top

MORE INFORMATION

For more information about copy-only backups, visit the following Microsoft Web site:
http://msdn.microsoft.com/en-us/library/ms191495(SQL.90).aspx (http://msdn.microsoft.com/en-us/library/ms191495(SQL.90).aspx)
For more information about how to troubleshoot SQL protection issues, visit the following Microsoft Web site:
http://technet.microsoft.com/en-us/library/bb795744.aspx (http://technet.microsoft.com/en-us/library/bb795744.aspx)
For more information about System Center Data Protection Manager 2007, visit the following Microsoft Web site:
http://technet.microsoft.com/en-us/dpm/default.aspx (http://technet.microsoft.com/en-us/dpm/default.aspx)
Back to the top
APPLIES TO
  • Microsoft System Center Data Protection Manager 2007
Back to the top
Keywords: 
kbtshoot kberrmsg kbexpertiseinter kbsurveynew kbprb KB970642
Back to the top