How To Truncate Your DNN(Dot Net Nuke) Logs In Your MS SQL Database

How to Truncate your DNN Logs in your MS SQL Database

If you need to clear your DotNetNuke logs directly through the database please follow the steps below.  To perform these steps you will need Microsoft SQL Server Management Studio installed on your computer.  If you do not have Microsoft SQL Server Management Studio installed follow the instructions in the following article: Connecting your database with SQL Server Management Studio
  1. Open Microsoft SQL Server Management Studio
  2. Click New Query button
  3. Paste the following Script into the New Query page replacing [database name] with the name of your database
    use [database_name]
    truncate table sitelog
    truncate table eventlog
    truncate table schedulehistory
  4. Click Execute
This will clear your DNN site log, event log, and schedule history.

Add Feedback