All that you need to know about QuickBooks Auto Data Recovery

Intuit’s accounting software QuickBooks have gained immense popularity over the past few years. As it has some powerful features like handling finances, raising invoices, managing payments, storing critical accounting data and more, small and medium sized businesses have started heavily depending on it. Being a software, this application is not immune to any errors or technical problems. Often users face various issues that stalls their business operations. A common problem that users face is losing their data. When you use this software, you might come across an extra folder having new folders. This is the QuickBooks Auto Data Recovery folder which basically takes a backup of all your company files. In case you lose all your data this tool will help in recovering all your important information. So, in this blog we will in details discuss how QuickBooks Auto Data Recovery works.

What is Auto Data Recovery function in QuickBooks?

ADR is a very important tool that helps in taking backup of your data. The loss of your data can severely affect your business operations and that’s when this tool comes to your rescue. The Auto Data Recovery feature uses your current Transaction Log file and a copy of your company file to restore back all the lost transaction except the ones done in the last few hours. ADR can help you in recovering the lost file by:

  1. Restoring the lost transactions using the current Transaction log file and a copy of the company file.
  2. Also, restoring all but the last few hours of transactions with a copy of both the company file and the transaction log file.

There are numerous other facts associated with QuickBooks Auto data recovery. So, if you are eager to unleash those facts, then make sure to read carefully this blog post till the end, or you can also get in touch with our QuickBooks support team by dialing 1-800-761-1787. Our executives will connect you with our experts in the least possible time and your queries will be answer within a few seconds.

You may also like: What are the steps to resolve QuickBooks error h505?

Points to remember before using QuickBooks Auto Data Recovery Tool

  • If you have QuickBooks Pro, Premier, or Enterprise Solutions for Windows, then only you can use Auto Data Recovery tool.
  • The QuickBooks Auto Data Recovery Tool (ADR) is not available in Accountants Edition.
  • You can take backup of maximum file size of 1.5 Gigabytes. In case, the file size is more that 1.5 Gigabytes, then QuickBooks will not be able to create the Auto Data Recovery file.
  • To get the maximum efficiency from the tool try using the latest updated version of QuickBooks.

How to use the QuickBooks Data Recovery Tool?

The below mentioned solutions will help you in recovering your lost data by using the QuickBooks Auto Recovery Tool:

Solution 1: Recover lost data using the original .TLG file with .QBW.adr.file

The original Transaction Log file and the current version of ADR can be used to recover the recent transactions that you have lost. Follow the below steps for the same:

  1. Create a new folder on your desktop and name it QBTest.
  2. Open the folder where you have saved the company file. You will find the company file location on Product Information screen and No Company Open Window. (Note: To open the Product information Press F2 or Ctrl+1 keys on your keyboard).
no company open-screenshot
  1. Search for the .tlg file on your company file’s folder. The company file that you are looking for will have the same name as your company file.
  2. Just in case, you aren’t able to identify the .tlf file then you have the follow the below mentioned steps to Show File Extension:
    • At first hit a click on Windows +E keys to open File Explorer.
    • Select Organize option and then choose Folder to search for options (Windows 10,8.1 and 8) to move further.
    • Choose View option to choose the File Name Extension.
    • Next, select the Hide Extensions for Known file types option.
    • Once you have selected the promoted option, click on Apply and then on OK button.
  3. Once you have found the .tlg file, copy and paste it in the QBTest folder that you had created earlier on your desktop.
Auto data recovery - Screenshot
  1. Open QuickBooksAutoRecovery folder. You will find it in the same location where your company file is stored.
Auto data recovery 2- Screenshot
  1. Now open the QBTest folder and right click on .QBW.adr file and the select on Rename option.
  2. Choose the .adr option which is located at the end of the file name and delete it.
Auto data recovery 3- Screenshot
  1. In QuickBooks, open the company file that you have stored in the QBTest folder.
  2. Check and confirm of All transactions are there in the file by using the account register.
  3. Follow the given series of action to make sure the data integrity: File >> Utilities >> Verify Data.
Verify hosting data - Screenshot
  1. You can now move the damaged file to some other location and replace it with the copied file that you saved in QBTest folder to the original location.

Read Also: What is QuickBooks abort error?

Solution 2: Recover recent transactions using the .QBW. adr and .TLG.adr files

Do note that this method of QuickBooks Auto Recovery can take up to 12 hours to recover the lost data:

  1. Firstly create a new folder on your Desktop and name it QBTest.
  2. Now by using the QuickBooks company file feature, open the QuickBooksAutoDataRecovery.

It is recommended to check the location of the company file on the product information screen, by pressing F2 keys or Ctrl + 1 keys and No company open window.

  1. Access the .TLG.adr and .adr files. These files have the same name as your company file. Show file extensions. In case, you are unable to identify the .TLG.adr and .QBW.adr files, then these steps should be performed to show the file extensions.
    • Initially open File Explorer by pressing Windows + E keys on your keyboard.
    • Choose Organize and then then choose the Folder and search options.
    • Now select View option and then choose File name extension.
    • Choose Hide extensions for known file types and finally choose Apply, then OK button.
  2. Copy the .TLG.adr and .QBW.adr files and also paste them to the QBTest folder.
  3. Opt for the two files and paste them in the QBTest folder and then delete .adr
  4. You will have then have to open QuickBooks.
  5. Open the company file saved on the QBTest folder. It is recommended to use the account register to verify the transactions.
  6. Follow the listed series of actions to verify if the integrity of data is intact- File >> Utilities >> Verify Data.
Verify hosting data - Screenshot
  1. If the recovered data is not damaged in any way then you can copy it from the QBTest folder and paste it in the original QuickBooks company file folder.

See Also: How to Verify and Rebuild Data Utility in QuickBooks Desktop?

To Wrap it Up!

With the help of QuickBooks auto data recovery you can easily get back your lost data. In case, you aren’t able to restore them or have any queries regarding this tool then you can always take help from QuickBooks enterprise support team who are available all through the day to help you out. So dial hassle free on our helpline i.e. 1-800-761-1787 and get in touch with our experts today!


Other helpful articles to read:

How to Fix QuickBooks Error 502?

How to resolve QuickBooks error code 15215?

Need QuickBooks Help?

Error support Team

Fix Your Error & Issues Instantly

Get instant help from experienced and certified professionals. Our customer support representatives are readily available to help You!


    Request a Call Back!

    Our Support agents are available between 8.00 AM to 8.00 PM EST, for QuickBooks user’s based in the USA & Canada Only.


    This will close in 0 seconds