Recover Lost Data With QuickBooks Auto Data Recovery

QuickBooks Desktop comes with hundred of features that makes accounting easy and one such feature is Auto Data Recovery (ADR) that can be helpful for you in case of data loss or corruption. You can easily recover all your lost data using the QuickBooks Auto Data Recovery feature. This feature was first introduced in QuickBooks 2012 and QuickBooks Enterprise Solutions 13.0 and later versions.

Intuit Data Services can be helpful for you in recovering your data most of the time. Recovering process may take some time and it can even take several days depending upon the size of your data you are recovering. Using ADR can be a faster way to recover lost or corrupted data. It should only be used once you troubleshoot all the possible issues.

ADR can help you recover your lost file by:

  • Restoring lost or corrupt transactions by utilizing the current Transaction Log File and a copy of your Company File.
  • Restoring all except the last several hours of transactions along with a copy of your Company File and Transaction Log file

Before you proceed, a few reminders:

  • ADR can only be used in QuickBooks Pro, Premier, and Enterprise Solutions for Windows OS.
  • This feature can’t be used in the Accountant Editions.
  • The ADR file can’t exceed than 1.5 Gigabytes. If the file is heavier than 1.5 GB, then QuickBooks won’t generate an ADR file.
  • You need to be using the latest version of QuickBooks to maximize the ADR feature in QuickBooks.
  • Now, follow the provided solutions in this article to recover your data.

Recover recent transactions using the original .TLG file with .QBW.adr file

Use the original transaction log file and ADR version of your QuickBooks company file to recover all your recent transactions.

  • Create a new folder on the Desktop and name it QBTest.
  • Navigate to the folder where your QuickBooks Company File is located. Tip: You can see the company file location from the Product Information window (Press F2 key while being on the home page).
  • Locate the .tlg file from the company file’s folder. This file will have the same name as your company file but with a different extension.
  • If you couldn’t locate the .tlg file, perform the following steps to show file extensions:
    • Press the Windows + E keys to open the Windows Explorer.
    • Go to Organize option and select Folder and search options. For Windows 10, 8.1 & 8 Users: Select View and then click on File name extension.
    • Click on Hide extensions for known file types.
    • Select Apply and OK.
  • Create a copy of the .tlg file from your company file folder and paste it the the QBTest folder you created on the Desktop.
  • Go to the QuickBooksAutoDataRecovery This file can be found in the same location as your company file.
  • Create a copy of the .QBW.adr file and paste it to the QBTest folder as well. Now, you will have a .QBW.adr and .tlg file in the same QBTest folder.
  • Now, right-click on .QBW.adr file and click on Rename from the drop-down list.
  • Remove .adr at the end of the file.
  • Now, run QuickBooks.
  • Open the company file form QBTest Use your account register to verify all the transactions.
  • From the main menu of QuickBooks, go to File > Utilities > Verify Data to verify the data integrity of the file you recovered.
  • If the file is healthy then you can change location of damaged company file and transfer the copy from QBTest to its original location.

Recover recent transactions using .QBW.adr and .TLG.adr files

This solution will use the ADR version of .QBW and .TLG files both. Doing this will recover all but the last 12 hours of transactions.

  • Create a new folder on the Desktop and name it QBTest.
  • Navigate to the folder where your QuickBooks Company File is located. Tip: You can see the company file location from the Product Information window (Press F2 key while being on the home page).
  • Now locate the QuickBooksAutoDataRecovery
  • Find the .TLG.adr and .QBW.adr These files will have the same name as your company file.
  • If you couldn’t locate the file then you need to perform the following steps to show file extensions:
    • Press the Windows + E keys to open the Windows Explorer.
    • Go to Organize option and select Folder and search options. For Windows 10, 8.1 & 8 Users: Select View and then click on File name extension.
    • Click on Hide extensions for known file types.
    • Select Apply and OK.
  • Create a copy of the .tlg.adr and .qbw.adr files from your company file folder and paste it the QBTest folder you created.
  • Now, remove the .adr extension from the file name. Now, you should have a .qbw and .tlg files on the QBTest
  • Now, run QuickBooks.
  • Open the company file form QBTest Use your account register to verify all the transactions.
  • From the main menu of QuickBooks, go to File > Utilities > Verify Data to verify the data integrity of the file you recovered.
  • If the file is healthy then you can change location of damaged company file and transfer the copy from QBTest to its original location.

Solutions For QuickBooks Data Damage and Corruption Issues

Hopefully, you find this article helpful and you have a clear idea about the processes of QuickBooks Automatic Data Restoration feature. It allows you to recover your damaged and lost data so that you can keep working on your company files. However, as we have already said that it is a bit time taken process or sometimes it can even fall into several errors as well. If you are facing any kind of difficulties while restoring your last or corrupted data then you can contact us at our toll-free QuickBooks Support Phone Number +1888-396-0208 for an instant technical support.