mom 2005 db

MOM Operations Database SDK Views
MOM Database Has Insufficient Allocated Space
SMS&MOM Troubleshooting MOM 2005 DTS Issues and Database Full Issues
OpsMgr, SCE And MOM Blog MOM Reporting database grooming settings tool

myITforum.com Inside MOM Database Maintenance, Part I Database Grooming

myITforum.com Inside MOM Database Maintenance, Part II Building a Data Warehouse

====================================================

Hi Norma, Unfortunately deleting data from the reporting database is not an easy task. You'll need to change the retention period using the following SQL script and then run the MOMXPartitioning and Grooming job to clear the data. I recommend only changing the retention days by a few days at a time or else the groom will fail. The SQL script is as follows: --- Update the SystemCenterReporting data retention period Declare @Groomdays int --Retain data for 180 days Select @Groomdays=180 exec p_updateGroomDays 'SC_SampledNumericDataFact_Table', @Groomdays exec p_updateGroomDays 'SC_AlertFact_Table', @Groomdays exec p_updateGroomDays 'SC_EventParameterFact_Table', @Groomdays exec p_updateGroomDays 'SC_AlertToEventFact_Table', @Groomdays exec p_updateGroomDays 'SC_EventFact_Table', @Groomdays exec p_updateGroomDays 'SC_AlertHistoryFact_Table', @Groomdays Hope this helps, Andy