Performing SQL Maintenance Tasks

  • 發行項

適用於: System Center Data Protection Manager 2010

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 DPM to avoid backing up a database with corruption issues.