The Database has grown very large, how can I fix it?

Article Id: 179881

Status: Published

Updated On: 13-12-2007 15:32

Legacy Id: HOWTO3101

Products:

Management Platform (Formerly known as Notification Server)

Issue/Introduction:

Resolution:

Problem
The Database has grown very large, how can I fix it?

Environment
NS 6.0, all service packs

Cause

When the Purge Maintenance schedule executes, it usually times out due to the number of items it's trying to delete. The result is that nothing gets purged, and the Database Tables continue to grow.

Resolution
The first step to resolution is to find out which tables are taking up a lot of space in the Database. Run the attached SQL script in Query Analyzer to determine which tables are the largest.

Then use the ManualPurge process in KB 31988 to get Purge Maintenance to work properly to trim down the database.