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.
-----