I recently was alerted to a problem with some QuickBooks Enterprise users where their TLG file is increasing in size at an alarming rate each day. This issue is causing concern because it is rapidly chewing up available hard drive capacity in some cases.
As mentioned in the above post on the Intuit Community, a working theory right now is that the new Search feature in QuickBooks 2011 may be one of the reasons for the explosive growth in the TLG files. There may certainly be other factors in play in this situation too that just have not been identified yet.
WHY YOU SHOULD CARE ABOUT THIS
As a quick refresher (and before your eyes glaze over from "geek-speak"):
- Every QuickBooks company file has an associated "TLG" file with it (the TLG is short-hand for Transaction LoG file) - here is a graphic that shows some (but not all) of the files associated with a QuickBooks company file, including the TLG file:
- The TLG file is located in the same place as your main QuickBooks company file. So, if your QuickBooks company file is on the "Public" drive of the server for example, the corresponding TLG file will be there too.
- The TLG file is an essential tool in helping with reconstucting QuickBooks company files in the event that some data corruption occurs.
- The TLG file is supposed to reset itself to a very small size when a QuickBooks backup is performed (via File > Create Backup) with the "complete verification" option turned on. If a backup is only being done via a server, the TLG file continues to grow and grow until it is reset via the File > Create Backup option.
- A TLG file that gets too big can wreak havoc with available disk space and it can also cause performance issues with QuickBooks company files as well. In addition, it may interfere with the upgrade from an older version of QuickBooks to a new version and slow the process down significantly.
For many QuickBooks users, this whole concept of TLG files is out of their sight and out of their mind since they don't have to mess with it on a daily basis.
However, it is essential to monitor the size of this file to ensure it is not getting too big for its' britches. This is especially true if you are working on an older computer or network where disk space is not as plentiful as it once was.
I'm sure there will be more information forthcoming from Intuit about the problems that have been identified with the TLG files. For now, I wanted you to be aware of this issue that some are experiencing.