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..

---

-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.


Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services