When you install MOM Reporting, the MOM 2005 Setup program adds a row that contains the
TimeDTSLastRan value to the ReportingSettings table. If you remove MOM Reporting, the MOM 2005 Setup program deletes this row. If this row is blank in the OnePoint database, the MOMXGroomByDays stored procedure determines that MOM Reporting is not installed. Therefore, the MOMXGroomByDays stored procedure grooms the OnePoint database. If this row is present in the OnePoint database, the MOMXGroomByDays stored procedure compares the time that the DTS job last ran to the
number of days to retain data setting. From this calculation, the MOMXGroomByDays stored procedure determines whether to groom the OnePoint database. However, because the DTS job no longer runs after you remove MOM Reporting, the
TimeDTSLastRan value never changes. Therefore, the MOMXGroomByDays stored procedure does not groom the OnePoint database.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
899158 (http://support.microsoft.com/kb/899158/) How to troubleshoot DTS and database sizing issues in MOM 2005 Reporting