We are running DNN 4.7.1 on a Windows Server 2003 machine. The database is on a SQL 2005 server (separate machine). Currently, the mdf file of our database is around 30-40 GB while the ldf has grown to 140 GB. We committed the transactions and cleaned the ldf file:

When the ldf file was regenerated, it was 20 GB. By the next day, it had grown to be over 100 GB. We have mulitple portals (20-30) on this DNN installation, with one of the sites averaging 30-40 page views a day. We have already turned off the site log for this site and are limiting the site log to 60 days for everyone else. I periodically clear out the event log. Is there any reason why the ldf is growing this large? It is eating up all the space on our sql server. Any suggestions to reduce the size? We need to figure this out ASAP.

Thanks!
Dave

Also, I would take a look at the sizes of the tables and watch how they grow, the SiteLog can REALLY pound a DB server....I NEVER use it on any client sites..