• Call Toll Free: 1-855-909-3300

Recover Lost Data with QuickBooks Auto Data Recovery

In this blog post we will understand how to use QuickBooks Auto Data Recovery options in situations where enterprise data gets corrupted or gets permanently deleted.

The presence of auto data recovery feature in QuickBooks is invaluable in handling data/loss failure proactively.

The Data Services team very often recovers data in files that are damaged.

But, it is often required to wait several days without QuickBooks for the team to recover the file.

The feature of Auto Data Recovery was introduced in QuickBooks 2012 (and later) and QuickBooks Enterprise Solutions 13.0 R4 (and later), and may offer you with all or nearly all of your data instantaneously.

This solution must be used after all probable troubleshooting resources have been utilized.

Please Note:

For QuickBooks Desktop 2014 (R11), 2015 (R9), 2016 (R5) the QuickBooks Desktop Auto Data Recovery (ADR) was deactivated and disabled for maintenance on May 23rd, 2016.

This did not impact scheduled backup of company files, set up by the user, that will continue to work as before.

This feature was still disabled in QuickBooks Desktop 2014, however, it is again offered in the with the latest updates to QuickBooks Desktop 2015, 2016 and 2017.

IMPORTANT: Ensure your product is selected. If not, select the blue “Change” link and choose your QuickBooks product.

Choose and follow the instructions given below:

● Select the ‘Update’ button to download the update file
● Select ‘Setup Automatic Updates’ to learn and understand how to set QuickBooks to automatically download and installing the current updates.

Detailed Procedures
Auto Data Recovery might help in recovering your data via two ways:

1. Recreate lost transactions via using your current Transaction Log file and a replica of your Company file.

2. Recreate all, however, the last few hours of transactions with a replica of both your Company file and your Transaction Log file.

Attempt the solutions in the sequence given below:

Kindly Note: The Auto Data Recovery is only present in QuickBooks Pro, Premier, and Quickbooks Enterprise Solutions for Windows at this time.

The ADR file has a size restriction of 1.5Gbytes. In case your backup file size is bigger than 1.5Gbytes, an ADR file will not be created.

Solution #1: For recreating all current transactions, use the original Transaction Log file with the Auto Data Recovery Company file.

1. Open that folder where the organizational file is located or stored.

a. Note the path of the No Company Open screen:

No Company Open screen - quickbooks

b. Open that folder present in the Windows Explorer:

Windows Explorer - quickbooks

2. Ensure to make file extensions visible (if needed).

a. Select Organize > Folder and the search options.

b. Select the View tab.

c. Click for clearing the Hide extensions for known file types checkbox.

search options - QuickBooks

3. Take note of the size and date modified for:

a. Company file (.qbw)
b. Transaction Log file (.tlg)

Company file - QB

4. Create a new folder with the name ‘Old Files

5. Shift the Company file over to the Old Files folder

Old Files - QB

6. Open the QuickBooksAutoDataRecovery folder. (It’s in the same folder as the Company file.)

7. Make note of the size and date modified for:

a. The 12 hour Auto Recovery files:

i. Company file (.qbw.adr)
ii. Transaction Log File (.qbw.tlg)

Recovery files - QB

b. The 24 hour Auto Recovery files (these won’t always exist):

i. Company file (.qbw.adr.old)
ii. Transaction Log File (.qbw.tlg.old)

8. Right-click on the replica of the Company file (.qbw.adr) and choose Copy.

Company file - QB7

9. Go back up on the folder where the organization file is stored or located.

10. Select Organize > Paste to replicate the file to this folder.

Select Organize - QB

11. Right-click on the Company file (.qbw.adr) and then select Rename.

12. Delete the .adr present at the end of the name of the file.

.adr present - QB9

13. First Open the QuickBooks.

14. Now Open the Company file.

15. Use reports or account registers to examine that all transactions were restored.

16. Make a Use of the Verify Data utility.

Solution #2: Utilize the Auto Data Recovery Company file and Transaction Log to recover and retrieve all but the last 12 hours of transactions.

Note: In case you have tried Solution #1, then you can Skip Steps 1-11 and proceed to step 12.

1. Open the folder where the Company file is located or stored.

a. Make a note of the path shown in the No Company Open screen:

Company Open screen- QB10

b. Now, Open that folder in Windows Explorer:

Windows Explorer - QB11

2. Ensure to make file extensions visible (if needed).

a. First Select Organize < Folder and the search options.

b. Now, Select the View tab.

c. Then, Click to clear the Hide extensions for known file types check box.

extensions - QB13

3. Kindly Make a note of the size and date of modification: a. Company file (.qbw) b. Transaction Log file (.tlg)

Transaction Log file - QB13

4. Create a new folder, and name it as ‘Old Files

5. Now, Shift the Company file to the Old Files folder

Old Files folder - QB14

6. Open the QuickBooksAutoDataRecovery folder. (It’s in the same folder as the Company file.)

7. Now, Right-click on the replica of the Company file (.qbw.adr) and then, select Copy.

Company file (.qbw.adr) - QB15

8. Again, go back up to the folder where the Company file is actually stored.

9. Now, Select Organize > Paste to copy the file to this folder.

Organize Paste - QB16

10. Right-click on the Company file (.qbw.adr) and select Rename.

11. Truncate or Delete the .adr from the end of the name of the file.

Truncate or Delete the .adr - QB17

12. Now, go back on to the QuickBooksAutoDataRecovery folder.

13. Then Right-click on the replica of the Transaction Log files (.qbw.tlg.adr) and choose Copy.

.qbw.tlg.adr - QB18

14. Again, go back up to the folder where the Company file is actually stored.

15. Select Organize > Paste to copy the file to this folder.

Paste to copy the file - QB19

16. Right-click the replica of the Transaction Log file (.qbw.tlg.adr) and choose Rename.

17. Delete or truncate the .adr from the end of the name of the file.

truncate the .adr - QB20

18. Now, Open QuickBooks.

19. Then, Open the Company file

20. Use reports or account registers to verify and examine that all but the last 12 hours of transactions were restored.

Note: Transactions created during the last 12 hours of using QuickBooks may require being recreated.

21. Finally, Use the Verify Data utility.

Author Profile

Angeela Palin
Angeela Palin
Angeela is Techarex Networks' Content Marketing Associate for Intuit products. She has worked as an eCommerce and Marketing Strategist for the last five years, helping businesses with software implementation for Customer Service, CRM and Email Marketing. Angeela thrives in helping companies find the right software solution for their projects. Aside from his obvious passion for Marketing, Angella admits to being a foodie and travel enthusiast.

Leave a Reply

Techarex NetWorks Products