Fog Creek Software
Discussion Board

Huge fogbugz_log.ldf

OK.. this thing is starting to get huge.  it's 996 MB now.  Do I need this for something important?

I had a mail retrieval problem for a few days (a 5MB email was sent to the email account) -- does the excessive size of the log have somthing to do with that?

As a side note, it wouldbe nice if fogbugz would notify me (via email maybe) if it times out on retrieving an email -- it was nearly bringing the server to a halt, as it was making the DLLHOST take about 400MB of memory, and dispacho was taking about 200... the server only has 512MB.

Eric Vitiello
Sunday, November 16, 2003

ok. nevermind.  I realized that it was the transaction log.  I set the truncate on checkpoint option, and shrunk the database -- it's down to 20MB now :).  Apparently because of the huge email it was trying to receive, it was loading the log up.

Eric Vitiello
Sunday, November 16, 2003

Your regular backups of the database should shring the .ldf file automatically to a decent size.

Torben Koch
Wednesday, November 19, 2003

*  Recent Topics

*  Fog Creek Home