Currently there are some questions regarding what is the best practice of backing up SQL databases with DPM 2010. First we must clarify what modes a SQL databases could be in. SQL databases can be in the following recovery models:
The thing that differentiates the databases is that the simple database has no transactional log files and can therefore only use the Express-Full backup technique in DPM.
The best practice for SQL server databases is to run a weekly database consistency check (also called DBCC) for avoiding backing up a database with a corruption issues with DPM.
You should not run or use other backup applications on a SQL server that is protected with DPM. This will lead to that DPM will not be able to back up your databases. If you should use DPM to protect your SQL server databases use only DPM, nothing else.
Last but not least verify with the SQL Server administrator that the following task are not scheduled at the same time as the Express-Full backup is running:
• Check database integrity
• History cleanup
• Maintenance cleanup
• Rebuild index
• Reorganize index
• Shrink database
• Update statistics