toolsignHere’s an issue I ran into the other day and since I didn’t see a lot documented about it I thought I’d go ahead and post the fix here.

Symptoms

Using System Center Data Protection Manager 2010 to backup a SQL database fails with the following error:

Execution of SQL command failed for SQL Server 2005 database <name> on <serverFQDN>.  (ID 30173 Details: Internal error code: 0x80990D19)

Cause

There was a scheduled task in SQL Studio Management to back up the SQL database. The problem occurs if there is any type of backup other than DPM that is also being done on the protected database. In this case the backup job via SQL Studio Management was causing a conflict.

Resolution

Disable the scheduled backup in SQL Studio Management. This will allow DPM to successfully backup the SQL database.

More Information

DPM does not allow log, or incremental, backups for databases configured in the simple recovery model. Log backups are only allowed for databases configured in the full and bulk-logged recovery models. When the recovery model of a protected database is changed from simple to full or bulk-logged, DPM protection continues as configured. When the recovery model of a protected database is changed from full or bulk-logged to simple, express full backups will continue to succeed, but incremental backups will fail.

See http://technet.microsoft.com/en-us/library/bb808756.aspx for more details.

Shane Brasher | Senior Support Escalation Engineer

The App-V Team blog: http://blogs.technet.com/appv/
The WSUS Support Team blog: http://blogs.technet.com/sus/
The SCMDM Support Team blog: http://blogs.technet.com/mdm/
The ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
The SCOM 2007 Support Team blog: http://blogs.technet.com/operationsmgr/
The SCVMM Team blog: http://blogs.technet.com/scvmm/
The MED-V Team blog: http://blogs.technet.com/medv/
The DPM Team blog: http://blogs.technet.com/dpm/
The OOB Support Team blog: http://blogs.technet.com/oob/
The Opalis Team blog: http://blogs.technet.com/opalis
The Service Manager Team blog: http: http://blogs.technet.com/b/servicemanager
The AVIcode Team blog: http: http://blogs.technet.com/b/avicode
The System Center Essentials Team blog: http: http://blogs.technet.com/b/systemcenteressentials
The Server App-V Team blog: http: http://blogs.technet.com/b/serverappv

clip_image001 clip_image002