QuickBooks Auto Data Recovery Tool: How to Restore a Damaged Company File

Last reviewed 2026-07-17

When a QuickBooks Desktop company file (.QBW) becomes corrupted or unexpectedly loses recent transactions, the Auto Data Recovery (ADR) tool can often save the day. This built-in feature automatically creates local backups of your company file, allowing you to restore your data without needing a dedicated IT professional.

How QuickBooks Auto Data Recovery Works

ADR operates quietly in the background. It creates a backup of your company file under two specific conditions:

• Transaction Log File (.TLG): ADR logs every transaction you enter in real-time.
• Original File Copy: ADR takes a snapshot of the entire company file every 12 hours (or every 24 hours, depending on your version of QuickBooks).

If your main file fails, you can use these two components to rebuild your data up to the last few hours of use.

Locating Your ADR Backup Files

By default, QuickBooks stores ADR data in a hidden folder within the same directory as your primary company file. To find it:

1. Open the folder on your computer where your .QBW file is saved.
2. Look for a folder named exactly like your company file, but with the suffix .adr (for example, CompanyName.qbw.adr).
3. Inside this folder, you will typically find subfolders labeled by date and time, containing the .QBW.adr and .TLG.adr files.

Restoring Lost Transactions

If your company file is intact but you are missing recent transactions, you can use the ADR transaction log to recover them.

1. Open your QuickBooks folder and locate the .adr folder.
2. Find the most recent .TLG.adr file.
3. Copy this file and paste it into a new, empty folder on your desktop.
4. Rename the file by removing the .adr extension so it simply ends in .TLG.
5. Copy your primary .QBW file and paste it into the same desktop folder as the renamed .TLG file.
6. Open QuickBooks while holding down the Ctrl key to open the application in No Company Open mode.
7. Select Open or restore an existing company, navigate to your desktop folder, and open the .QBW file. QuickBooks will automatically read the .TLG file and integrate the missing transactions.

Recovering from a Corrupt Company File

If your main company file will not open at all, you can restore the 12-hour snapshot ADR took previously.

1. Navigate to the .adr folder in your QuickBooks directory.
2. Open the dated subfolder that contains the .QBW.adr file.
3. Copy the .QBW.adr file and paste it into a new folder on your desktop.
4. Rename the file by removing the .adr extension so it ends in .QBW.
5. Open QuickBooks in No Company Open mode (hold Ctrl while launching).
6. Choose Open or restore an existing company, locate the desktop file, and open it.

Once the file is open, run the Verify Data utility (under the File > Utilities menu) to ensure the restored file has no structural errors.

When ADR Fails: Next Steps

The ADR tool relies on your local hard drive, meaning severe hardware failures or deeply entrenched file corruption can render the ADR backups unusable. If the ADR files are missing, or if QuickBooks displays error codes when attempting to open the recovered file, the structural damage has likely spread to the backup itself. In these cases, you will need advanced data extraction methods to rebuild the database tables and recover the damaged QuickBooks company file safely. For a step-by-step triage of each ADR failure mode -- the .adr file that will not open, the 1.5 GB ceiling, a missing .TLG -- see what to do when Auto Data Recovery fails.