As your Configuration Manager 2007 site performs the tasks that you schedule and configure, site components continually add data to the site's database. As the amount of data grows, database performance declines.

Predefined maintenance tasks target the Configuration Manager 2007 site database and continually remove out-of-date data. Reducing the size of the database by removing unnecessary data improves the performance and the integrity of the database, which increases the efficiency of the site.

Primary sites have all of the predefined maintenance tasks available as listed below. The only predefined maintenance task available for secondary sites however, is the Backup Site Server maintenance task.

Note
Predefined maintenance tasks log their activity to the SMS_SQL_Monitor log file (SMSdbmon.log).

The Delete Aged Delete Detection Data maintenance task does not provide functionality in Configuration Manager 2007.

If you are using the out of band management feature, see the following for information about the Evaluate Provisioned AMT Computer Certificates and Reset AMT Computer Passwords maintenance tasks: How to Customize Maintenance Tasks for Out of Band Management.

In This Section

Backup ConfigMgr Site Server Task Overview

Backs up a Configuration Manager 2007 site, including the site database, files, registry keys, and system configuration information
Clear Install Flag Task Overview

Flags uninstalled clients as uninstalled in the site database to allow them to be reinstalled by the client push installation method.When enabling this task, set the client rediscovery period to an interval longer than the heartbeat discovery schedule.
Important
Because this task relies on heartbeat discovery, you should disable this task if heartbeat discovery has not been enabled.
Delete Aged Client Access License Data Task Overview

Deletes aged Client Access License (CAL) data from the site database.
Delete Aged Collected Files Task Overview

Deletes aged collected files data from the site database.
Delete Aged Computer Association Data Task Overview

Deletes Operating System Deployment computer association data from the site database after it has been deleted as part of user state restore.
Delete Aged Configuration Management Data Task Overview

Deletes outdated configuration item definitions and any associated configuration item compliance history data from the site database.
Delete Aged Discovery Data Task Overview

Deletes aged client discovery data from the site database.
Delete Aged Inventory History Task Overview

Deletes all client hardware inventory history data older than the number of days specified from the site database.
Delete Aged Software Metering Data Task Overview

Deletes all client software usage data older than the number of days specified from the site database.
Delete Aged Software Metering Summary Data Overview

Deletes all software metering summary data older than the number of days specified from the site database.
Delete Aged Status Messages Task Overview

Deletes aged status messages from the site database.
Delete Inactive Client Discovery Data Task Overview

Deletes inactive client records from the site database.
Delete Obsolete Client Discovery Data Task Overview

Deletes obsolete client records from the site database.
Monitor Keys Task Overview

Monitors the integrity of site database primary keys.
Rebuild Indexes Task Overview

Rebuilds indexes used by the site database.
Summarize Client Access License Weekly Usage Data Task Overview

Summarizes CAL usage and creates a weekly data point for long term trending.
Summarize Software Metering File Usage Data Task Overview

Summarizes software metering file usage data from multiple records into one general record to compress the amount of data stored in the site database.
Summarize Software Metering Monthly Usage Data Task Overview

Summarizes detailed software metering usage data from multiple records into one general record to compress the amount of data stored in the site database.This task can be used with the summarize software metering file usage data maintenance task to summarize software metering data and to conserve space in the site database.

See Also