the database transaction log is filled by SQL Server, if you set the recovery model of the database to 'Full". The transaction log will enable rollback to any point of time in the past.. The transaction log is emptied when the database is properly backed up

For the average dnn site, this is not really necessary, setting the recovery model to "Simple" will suffice.

You cannot clear the log through host > sql (well, you probably can, but i dont know the sql for that to do it). If you set the recovery model to Simple and do a Shrink Database after that, your transaction log will be empty

DNN Blog | Twitter: @erikvb | LinkedIn:

In case your transaction log is full, use the following code from the Host - SQL:

(change db_Name to your db name)

Lines 2 and 3 are not needed but I found that in cases that site is stalled it is a good way to add them too.

BACKUP LOG db_Name WITH TRUNCATE_ONLY
TRUNCATE TABLE eventlog
TRUNCATE TABLE sitelog
DBCC SHRINKDATABASE (db_Name);

If you can't access the SQL page then you have to do it from the DB itself.

T.