• Skip to primary navigation
  • Skip to main content

QBGarage.com

The QuickBooks Specialists

  • Home
  • Blog
  • KnowledgeBase
  • Company
  • Show Search
Hide Search
You are here: Home / Archives for TLG file

TLG file

What Is the Transaction Log File?

Chief Mechanic · September 7, 2010 ·

The QuickBooks transaction log file is a log of all changes about to be made to the company file (.qbw) before they are actually recorded in the company file.  It is stored in the same folder as the company file itself.  It’s automatically created by QuickBooks.

The filename of the transaction log file is in the form:

[company file name].qbw.TLG

QuickBooks uses data written to the transaction log file to transparently complete the recording of transactions that were not completely recorded in the company file itself because a connection to the company file was lost.  The transaction log file can also be used in conjunction with a QuickBooks backup file (.qbb) to recover from a damaged company file.

The transaction log file is reset when:

  • you sucessfully complete a manual (not a scheduled or online) backup in QuickBooks
  • you restore a portable company file (.qbm)
  • the company file does not match the transaction log file

The company file may not match the transaction log file if you restore a backup of the company file using the same filename in the same folder or if you make a copy of a company file, take the copy to another computer and make changes, and put the changed copy back in the original location.  For example, if you want to make a copy of the company file and work on it on another computer, you need to copy both the company file itself and the corresponding transaction log file in order to preserve the data recovery benefits that the transaction log file offers.

Because the transaction log file is only reset under specific circumstances, it may grow in size and become larger than the QuickBooks company file itself.  Large transaction log files can have an adverse effect on overall QuickBooks performance, so it’s important to periodically cause the events that trigger a reset of the transaction log file.  If you perform a manual backup, it’s important to run the backup with some degree of verification enabled.  If you complete the backup without verification enabled, your transaction log file will be reset, and the unverified data in the backup may be unusable.

Additional information on the QuickBooks transaction log file can be found in this Intuit knowledge base article as well as our article on the file types used by QuickBooks.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

What Does Error Code -6000, -107 Mean?

Chief Mechanic · September 5, 2010 ·

According to Intuit, Error Code -6000, -107 “QuickBooks is unable to open company file” can occur when a user is attempting open a QuickBooks company file (.qbw) and the associated network data (.nd) or transaction log (.tlg) file is damaged.

To resolve this error, rename both of the files and re-start QuickBooks.  QuickBooks will recreate these files when it starts.

For more information on resolving Error Code -6000, -107, consult this Intuit knowledge base article.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...
  • « Go to Previous Page
  • Go to page 1
  • Go to page 2

Accounting

  • Financial Accounting Standards Board

Developer

  • Intuit Developer Network Forums
  • qbXML Onscreen Reference

Intuit

  • Enterprise Solutions
  • Intuit
  • Intuit Marketplace
  • QuickBooks
  • QuickBooks Online Community

QBGarage.com

Copyright © 2008–2023 QBGarage.com · Privacy · Terms & Conditions · Site Help