How to reduce the size of logging database OR How to purge the old data from Logging Database

Run the same Power Shell command again to cross check "Get-SPUsageDefinition" and check the Retention period is changed or not.

After that we need to run the two timer jobs to clean the old data ‘Microsoft SharePoint Foundation Usage Data Import‘ and ‘Microsoft SharePoint Foundation Usage Data Processing‘.

Go to Sharepoint Central Administration -> Monitoring -> Configure Usage and health data collection-> Log Collection Schedule.

And it will take you to the timer jobs.

 Now Click on both the Job Definitions one by one and hit ‘Run Now‘ to run the timer jobs

Once the timer jobs is run you can check and confirm database has released the space.

How to reduce the size of logging database OR How to purge the old data from Logging Database,布布扣,bubuko.com