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.