Application Log Table Cleanup

The Application Log table, dbo.ApplicationLog, is growing larger than you want and needs to be cleaned up.

The Application Log table tracks ever time there is a change to content, either it being added, updated, or deleted, there is a log entry added to the table. If there are a lot of changes happening to content this can cause the table to swell fast. You can safely remove any or all data from the table, but we do recommend keeping the last 30 days of information in case you need to revert to an earlier version of content. If you need to clear it out you can use the below SQL script as either a one time run or as part of your maintenance plan. Please make a backup of your database first. 

DELETE FROM dbo.ApplicationLog
WHERE Created < DATEADD(day, -30, GETDATE());