The transaction log file (.TLG) logs all changes to the company file before they are written to the file by the database manager. The transaction log file is named [company file name].qbw.tlg.
You cannot open the .TLG file, nor can you convert it into a company data file (.QBW).
The .TLG file is stored in the same folder as the QuickBooks company file (.QBW file) and should be kept there at all times. If you move or copy the .QBW file to another folder, copy or move the .TLG file with it.
If your data file loses connection to the .TLG file, QuickBooks will automatically create a new .TLG file. If part of a transaction was recorded to the company file but the whole transaction is present in the .TLG file, the transaction will be completed the next time the file is opened in QuickBooks.
If you need to restore an old backup of your company file, you can use QuickBooks Automatic Data Recovery to try to take the changes in the .TLG file (everything since the last successful backup) and enter them into the data file. When this is necessary, it is important that the .TLG file, and the most recent backup are preserved.
The .TLG file can be very large, much larger than the company file. Large .TLG files can have adverse effects on QuickBooks' performance.
QuickBooks will reset the .TLG file if:
- You make a local back up your data file and select Complete verification in the Backup Options window. There is no need for the transaction log to keep transactions that have already been recorded to the file and backed up. Note: The transaction log will not be reset when you make QuickBooks Scheduled or Online Backups.
- If you restore a portable company file (.QBM).
- Your company data file does not match the .TLG file. If you restore a backup with the same name of the original .QBW file in the same folder, the .TLG file will not match the older .QBW file and is therefore reset.
- You copy the .QBW file from a work computer, take it home to work on, and then take it back and copy it onto your work computer. The .TLG file will not match the modified data file. It is important to copy both the .QBW and .TLG files back and forth between the two computers in order not to lose the ability to recover data.