2

I have a database UsageAndHealth which is growing fast, I have changed the retention to 3 but how can I purge the data that is already in the database? Can I delete as is or what is the best approach to do it?

I tried to change the max storage for the db but it is not possible until I reduce the size of it.

0

After change the retention period, run the “Microsoft SharePoint Foundation Usage Data Import” timer job and “Microsoft SharePoint Foundation Usage Data Processing” timer job manually via Central Administration -> Monitoring -> Configure Usage and health data collection-> Log Collection Schedule.

Then the only 3 days log is retained and database has released the space.

Check the blog for more information: How to reduce the size of logging database OR How to purge the old data from Logging Database

0

did you try to find out the primary source of this extensive growth? (ex., by selecting your logging Database in SSMS -> (Right Click) -> Reports- > Standard Reports -> Disk Usage by Top Tables.)?

  • I see in the top dbo.TaskUsage_Partition6 that should be unchecked in the monitoring services? – Carlos M Jul 16 '18 at 22:03
  • I wounder if you could provide a screenshot...? – Lachezar Stefanov Jul 18 '18 at 6:59
  • Sorry but I can't, I reduce the retention period and ran the timer job manually, it has reduced the size. – Carlos M Jul 18 '18 at 17:35
  • hello Carlos, I didn't mean reducing the retention period, just finding out the source of the extensive growth. – Lachezar Stefanov Jul 20 '18 at 8:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.