Last post Jun 06, 2006 08:52 AM by bertcord
Jun 05, 2006 08:20 PM|lou|LINK
I noticed my performance on a DNN installation was problematic.
This was a test site which had a 10MB database file, and a 2 GB Log LDF file.
How does a site generate 2 GB of transactions when NO ONE USES IT ?
Jun 05, 2006 10:18 PM|walkerstewart|LINK
The log file of a database is used whenever a transaction to Insert, Update, or Delete a record is made.
It is likely that the log has grown to its size through the dnn logger (and other dnn tables) (which logs just about every interaction). When your dnn log reaches the max time period (e.g. 20 days), the log will cleared for records before this period.
Thus actual data is cleared, but the entries in the DB Log File still remain.
Other DNN Tables that apply this wonderful expansion are:
I learnt this the hard way by having lost nearly all my hard drive space (older pc) when a DB log file I was using hit 20GB (yes 20GB).
Easiest way to fix this is to apply a Shrink and Compress task to your database when it's scheduled backup occurs.
Hope this Helps,
Jun 06, 2006 08:52 AM|bertcord|LINK