Microsoft KB Archive/298382

= How to Purge Old Data from the OnePoint Database =

Article ID: 298382

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Operations Manager 2000 Service Pack 1

-



This article was previously published under Q298382



SUMMARY
This article describes how to clear data from the OnePoint database without uninstalling and then reinstalling the OnePoint database.



MORE INFORMATION
It is not possible to purge the OnePoint database completely. However, you can configure grooming to remove old items. Follow these steps to adjust the Database Grooming function:
 * 1) In the Operations Manager Microsoft Management Console (MMC), expand Configuration, and then click Global Settings.
 * 2) In the right pane, right-click Database Grooming, and then click Properties. Click the Database Grooming tab.
 * 3) For each record type, select the record type, click Edit, and then change the grooming times to 24 hours or to one day.

NOTE: There are many jobs that have a run time of 24 hours or one day. It is not advisable to permanently configure the grooming time to less than 24 hours or one day.
 * 1) Stop the OnePoint service on the Consolidator computer.
 * 2) Start SQL Enterprise Manager, and under the (OnePoint) SQL Server, expand Management, expand SQL Server Agent, and then click Jobs.
 * 3) Right-click OnePoint - Groom Events, and then click Start Job.
 * 4) Let this process run to completion.
 * 5) Follow the same SQL steps for the OnePoint - Groom Alerts and the Groom Sampled Numeric Data options.
 * 6) Start the OnePoint service, and set Database Grooming to your preferred settings in the Operations Manager MMC.

Keywords: kbenv kbinfo kbpolicy KB298382

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.