The Database has grown very large, how can I fix it?
NS 6.0, all service packs
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.
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.Purging can then be verified by running the attached SQL again.