Performing SQL Maintenance Tasks
Applies To: System Center 2012 - Data Protection Manager
Coordinate with the SQL Server administrator to ensure that the following tasks are not scheduled at the same time as the express full backup performed by DPM:
Check database integrity
History cleanup
Maintenance cleanup
Rebuild index
Reorganize index
Shrink database
Update statistics
Best practices for SQL Server include running a weekly database consistency check (DBCC). You should continue this practice for databases protected by System Center 2012 – Data Protection Manager (DPM) to avoid backing up a database with corruption issues.
-----
For additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----