Recover lost data with QuickBooks Auto - QuickBooks Learn & Support

The Intuit Data Services team can often recover data in files that are damaged. However, it is often necessary to wait several days without QuickBooks for the team to recover the file. Auto Data Recovery was introduced in QuickBooks 2012 (and later) and QuickBooks Enterprise Solutions 13.0 R4 (and later), and may provide you with all or nearly all of your data right now. This solution should be used after all appropriate troubleshooting resources have been used.

Detailed instructions

Auto Data Recovery may help recover your data in one of two ways:

• Recreate lost transactions using your current Transaction Log file and a copy of your Company file.
• Recreate all but the last few hours of transactions with a copy of both your Company file and your Transaction Log file.

Follow the solutions in the order shown.

Note: The Auto Data Recovery is only available in QuickBooks Pro, Premier, and Enterprise Solutions for Windows at this time. The ADR file has a size limitation of 1.5Gbytes. If your backup file size is larger than 1.5Gbytes, an ADR file will not be created.

Solution 1: Use the original Transaction Log file with the Auto Data Recovery Company file to recreate all recent transactions.

1. Open the folder where the Company file is stored.
   1. Make note of the path in the No Company Open screen:
      
      

      
      
   2. Open that folder in Windows Explorer:
      
      

      
      
2. Make file extensions visible if necessary.
   

   
   

   1. Choose Organize > Folder and search options.
   2. Click the View tab.
   3. Click to clear the Hide extensions for known file types checkbox.
      
      
3. Make note of the size and date modified for:
   

   
   

   1. Company file (.qbw)
   2. Transaction Log file (.tlg)
      
      
4. Create a new folder, named Old Files.
5. Move the Company file to the Old Files folder
   

   
   
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:
   1. The 12 hour Auto Recovery files:
      1. Company file (.qbw.adr)
      2. Transaction Log File (.qbw.tlg)
   2. The 24 hour Auto Recovery files (these won't always exist):
      1. Company file (.qbw.adr.old)
      2. Transaction Log File (.qbw.tlg.old)
         
         
         
         

         
         

         
8. Right-click the copy of the Company file (.qbw.adr) and select Copy.
   

   
   
9. Go back up to the folder where the Company file is stored.
10. Choose Organize > Paste to copy the file to this folder.
    

    
    
11. Right-click the Company file (.qbw.adr) and choose Rename.
12. Delete the .adr from the end of the name of the file.
    

    
    
13. Open QuickBooks.
14. Open the Company file.
15. Use reports or account registers to verify that all transactions were restored.
16. Use the Verify Data utility.

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

Important: If you have tried Solution 1, Skip Steps 1-11 and proceed to step 12.

1. Open the folder where the Company file is stored.
   1. Make note of the path in the No Company Open screen:
      
      

      
      
   2. Open that folder in Windows Explorer:
      
      

      
      
2. Make file extensions visible if necessary.
   

   
   

   1. Choose Organize < Folder and search options.
   2. Click the View tab.
   3. Click to clear the Hide extensions for known file types checkbox.
      
      
3. Make note of the size and date modified for:
   

   
   

   1. Company file (.qbw)
   2. Transaction Log file (.tlg)
      
      
4. Create a new folder, named Old Files.
5. Move the Company file to the Old Files folder
   

   
   
6. Open the QuickBooksAutoDataRecovery folder. (It's in the same folder as the Company file.)
7. Right-click the copy of the Company file (.qbw.adr) and select Copy.
   

   
   
8. Go back up to the folder where the Company file is stored.
9. Choose Organize > Paste to copy the file to this folder.
   

   
   
10. Right-click the Company file (.qbw.adr) and choose Rename.
11. Delete the .adr from the end of the name of the file.
    

    
    
12. Go back to the QuickBooksAutoDataRecovery folder.
13. Right-click the copy of the Transaction Log file (.qbw.tlg.adr) and select Copy.
    

    
    
14. Go back up to the folder where the Company file is stored.
15. Choose Organize > Paste to copy the file to this folder.
    

    
    
16. Right-click the copy of the Transaction Log file (.qbw.tlg.adr) and select Rename.
17. Delete the .adr from the end of name of the file.
    

    
    
18. Open QuickBooks.
19. Open the Company file
20. Use reports or account registers to verify that all but the last 12 hours of transactions were restored.
    Important: Transactions created in the last 12 hours of using QuickBooks may need to be recreated.
21. Use the Verify Data utility. 

if you unable to recovery lost data with QuickBooks Auto data recovery. You call 800-518-1838 QuickBooks Customer Support Number with toll-free. Our customer support team ready to fix QuickBooks Data Recovery related problem and issue.

Ref Link: community.intuit.com