Quickbooks TLG File Not Resetting
Get professional support to fix the Quickbooks TLG File Not Resetting effectively
QuickBooks TLG file not resetting occurs usually after a system crash. Even after people restore their backups, they still get this error in which the transaction log file cannot be reset or recovered. QuickBooks company file has an extension of .qbw and the backup file has an extension of qbb. The TLG file stores the info of all the transactions in your accounting software. So if you cannot recover or reset your transaction log file, then you will keep getting the same error over and over again.
When you want to fix the QuickBooks TLG File not resetting error, you need to restore the backup first so that quickbooks can then automatically reset the log file and you can get back to work. You can also rely on the auto data recovery feature that is present in QuickBooks. The tool automatically makes a local backup and then tries to restore it so that even if your files get damaged, you have a recent copy available for restoration. This feature is available in pro, premier and enterprise solutions.
In this post, you’ll learn how to fix QuickBooks TLG File not resetting error.
Error: QuickBooks TLG File not resetting
Reasons for QuickBooks TLG File not resetting:
Why is the QuickBooks TLG File Not Resetting?
QuickBooks TLG file not resetting error relates to the transaction log file which contains the information about individual transactions that aren’t yet completed in the company file. You need to restore a backup of your company file so that you can start off with an error free transaction log file.
Simple Solutions for QuickBooks TLG File not resetting
When QuickBooks is not able to rename the tlg file, you can use the following solutions to fix the problem and get through the error.
Solution #1: Restore backup
You can create a backup of your company file so that if the file gets damaged in any case you have the option to recover the most recent copy using the latest backup. The backup can be restored within minutes using the restore backup utility available in the accounting software.
Here are the steps to fix QuickBooks TLG File by restoring a recent backup of company file:
- Go to the File menu.
- Choose Open or Restore Company, then Restore a backup copy.
- Click on Next, then Local Backup.
- Choose Next.
- Choose the backup file by clicking on the browse option.
- Click on Open.
- Choose Save.
It may take a few minutes for the backup file to restore your accounting data. But once it’s done, you can try to launch QuickBooks and check the validity of the TLG file. If you still cannot reset it, you can use the next method that focuses mainly on fixing the TLG file.
Solution #2: Use the Auto Data Recovery Tool
You can also use the auto data recovery utility available in the desktop version of the accounting software. This utility is very useful in cases of company file corruption or data loss. This feature enables you to recover all of your data from the last backup file created using the same software.
Auto Data Recovery tool can be used for:
- Restoring the Transaction Log File
- Restoring the Company File
- Restoring lost entries from the Company File or the Transaction Log File.
The tool is only available in Pro, Premier and Enterprise, but not the Accountant edition of QuickBooks. Further, the tool limits the data file recovery to 1.5 GB which exceeds the size of most company files by a huge margin.
To recover recent transactions in .QBW and .TLG file, follow these steps:
- Go to the Desktop.
- Right Click and Choose New > Folder.
- Name the folder QBTest.
- Find the location of your company file and open the folder there.
- Find the .TLG file in the company file folder. TLG Files have the same file name as the company file, but a different extension.
- Copy the relevant .TLG file and paste it in the QBTest folder that you created in the first step.
- Launch the QuickBooksAutoDataRecovery folder. This folder is stored in the company file folder.
- Right click on the .QBW.adr file, and click on Copy.
- Paste the file you copied in the previous step in the QBTest folder.
- Right click on the .adr file, then choose Rename and remove the ADR extension from the end.
- Launch QuickBooks desktop on your system.
- Launch the company file saved in the QBTest folder.
- Enter the login credentials for the company file.
- Go to Utilities, then Verify Data.
- Once data is verified, you can copy the recovered company file from the QBTest folder to the main company file folder.
Note: You can also rely on the Intuit data services which automatically create a backup of your company file and store the backup on a remote server to keep it safe from any kind of damage. However you have to purchase this service additionally because it is not available by default in books desktop.
QuickBooks TLG File not resetting requires you to rely on the auto data recovery tool that is already available in the company file folder. This tool can help you recover missing or lost transactions from your company file or the transaction log file.
Frequently Asked Questions (FAQs)
I ran into problems while restoring the backup file and resolving the TLG error. What should I do now?
Several errors can occur while you try to restore a backup file because of interference from other software. If you rely on add-on services, then you are at a higher risk of getting such errors. You may get the message that the file is missing or that the payroll data isn’t compatible. Further it may end up creating duplicate transactions that create additional errors in your company file.
Is the Auto Data Recovery Tool available for free?
Yes, the auto recovery tool is available for free because it is a utility provided in the accounting software to recover any lost transaction or deleted transaction from the log file or the company file. You can go to the folder containing the company file and then launch the tools specifically for that particular company file. When a new company file is created, you can replace the old one and get all of your data back.
Does the newly created company file contain all the data from the old one as well?
Depends on the recovery process entirely. If you have recovered your data using a backup copy then all the data entered after the creation of the backup won’t be available in the new company file. However, if you rely on the auto data recovery tool, then you can get most of the recent transactions recovered easily, but you won’t have any other data recovered using this tool.