Truncate Eventlog for DNN 7.4.0 and later (including DNN 9.x.x). Please use TruncateEventlog2.sql only, unless required differently.
- Download TruncateEventlog2.sql to your local hard disk
- in your DNN enter SQL Module in Host Menu (DNN 7 or 8) or in PersonaBar > Settings > SQL (DNN9)
- load the file and execute.
- You may need to repeat this frequently unless you are using latest DNN TurboScripts, which will take care of table sizes.