Here’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.
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)
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.
Disable the scheduled backup in SQL Studio Management. This will allow DPM to successfully backup the SQL database.
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