We looked at a client’s QuickBooks Enterprise 11 file this week that was mysterious — their TLG file was growing by more than 1GB every day.

But they weren’t entering or importing very many transactions…just a hundred or so per day. So why was their TLG file exploding on a daily basis? The client was having to manually delete the file every few days to keep it under control. But then QuickBooks would recreate it from scratch (which is normal) and quickly add a gigabyte or more of information to it within hours of normal use (not normal). Strange, eh?

(By the way, TLG stands for Transaction Log file, and is an auxiliary file that QuickBooks maintains along with your main QBW file. QuickBooks inserts new transactions into the TLG file. For that reason, the TLG file is sometimes helpful to us when we are helping clients recover from QuickBooks data crashes. The TLG is otherwise not necessary for the operations of QuickBooks.)

The company file verified and rebuilt without errors, and the client was not experiencing errors or crashes during normal QuickBooks operations.

We found some minor problems in the QBW file, and supercondensed their file for them. But we couldn’t find the source of the TLG growth issue.

Then we heard that that this issue is known by Intuit to occur in certain cases, and a resolution is expected in 2-4 weeks. So our client will continue to manually delete the file every few days until the fix from Intuit comes out.

This is the first time we’ve encountered a problem like this. Has anyone else seen it?

Please follow and like us:
error

10 thoughts on “The Case of the Exploding TLG File

  1. I am having the same problem.
    Only after upgrading to Quickbooks Enterprise 11.0

    The TLG file is so big it really slows down the operation of the program.
    I am deleting the the file every few days . I am waiting for Intuit to address this problem.

    Reply
  2. Jessica, thanks for the comment and link to Charlie Russell’s blog post on the TLG file. I know that doing the manual backup with verification will recreate the TLG file. Are you saying that it will do that, and make it so that the TLG doesn’t unreasonably anymore? I would think that if that were the fix, Intuit support would be telling users to do that…

    Reply
  3. A manual backup with verify does reset the TLG file but the problem we are experiencing with the TLG file growing, daily, in excess of 1GB remains, even after doing a backup with verify.

    Reply
  4. Shannon: No. We have not heard much of anything from Intuit on a resolution. But the list of users who are experiencing this same problem is growing. I do take some comfort that I am not the only one having this issue. What I do know is this issue affects users of Quickbooks Enterprise Editions only.

    Reply
  5. Our data file is 230MB and our .tlg log file grows 300MB per day causing QB’s performance to lag across our company LAN. We sent in our data file to QB’s support team for a rebuild hoping this would resolve the issue but no such luck. Manual backup’s do not reset the .tlg log file. There are allot of support blogs with screen grabs of technical how to’s although they are mostly bunk. A current solution we’ve adopted is to rename the .tlg file and cut/paste it to our desktop. Once QB starts it creates a new .tlg file, but unfortunately the newly created file becomes bloated within a short time period.

    Reply
  6. Peter, thanks! I posted a comment on your Intuit Community thread. Good detective work!

    Previous commenters on this blog: Please try out Peter’s workaround and then report back on your results.

    Reply
  7. Pingback: When a User Was the Best Troubleshooter of All | QuickBooks and Your Business

Leave a reply

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> 

required

This site uses Akismet to reduce spam. Learn how your comment data is processed.