Recover a Damaged QuickBooks Company File with Auto Data Recovery
A QuickBooks Desktop company file that will not open after a crash, or one missing recent transactions, can often be restored without a backup file.
A crash or a power cut can leave a QuickBooks Desktop company file refusing to open, throwing a -6000 or C= error, or opening with the day's entries gone. Intuit built a safety net into the Windows editions of Pro, Premier, and Enterprise: Auto Data Recovery. It keeps a second copy of the file and a running log of everything entered since. Restored the right way, that pair can bring the books back without touching your last backup.
What does Auto Data Recovery actually keep?
The recovery data lives beside your live file, in the same folder, on the machine hosting it. It has two parts. The first is a snapshot of the company file, stored with .qbw.adr on the end of its name. The second is a companion log, ending in .tlg.adr, which records every entry made after the snapshot.
The snapshot refreshes roughly every twelve hours, and only while the file is open in QuickBooks. You may find two generations on disk. The newer pair holds the most data; try it first. The older pair is the fallback. The feature is Windows-only; Mac and Online editions do not create it.
Before you start
Close QuickBooks on every machine that reaches the file. If the file still opens, switch to single-user mode first (File, then Switch to Single-user Mode), then close it. Work at the host computer, the one where the .qbw physically sits; a mapped drive on a workstation may not show the recovery files.
Copy the whole company folder to an external drive before changing anything. The original .tlg beside the damaged file may hold transactions newer than the recovery set contains. A careless rename can destroy that evidence. Finally, turn on file extensions in Windows, or the renaming step will misfire.
Restoring the recovery copy
- Open the folder that holds the damaged company file.
- Find the newest matching pair: the file ending in .qbw.adr and the file ending in .tlg.adr.
- Create a fresh folder somewhere harmless, such as the desktop, and copy both files into it together. Never restore inside the original folder.
- Rename the copied .qbw.adr so it ends in .qbw. Rename the .tlg.adr so it ends in .tlg. The base names must match each other exactly, or the log will not replay.
- Double-click the renamed .qbw. QuickBooks loads the snapshot, finds the log beside it, and replays the recorded transactions. Large files can take several minutes.
- If QuickBooks offers to update the file to your current version, accept.
How do you confirm the file is whole?
Press F2 and check the Product Information screen: the counts of names and transactions should sit near what you expect. Then run Verify Data from the File menu, under Utilities. If Verify flags damage, run Rebuild on this recovered copy; that is precisely what it is for.
Next, compare the books against paper. Open the check register, a profit and loss, and your receivables. Confirm the last entries you remember making are present. When everything ties, take a real backup at once. Keep the damaged original aside until you have worked a full day in the recovered file.
If the damage runs deeper than the recovery copy
Two failures are common at this point. The first: the restored pair throws the same errors as the live file. That points to damage on the disk itself, and the older generation will usually fail the same way. The second: the file opens, but the newest transactions are still missing.
Those missing entries were probably made after the last log update. The only place they may still exist is the original .tlg beside your damaged file. That log can be replayed against your newest real backup, which is the core of our QuickBooks TLG transaction log recovery service.
Where no recovery copy behaves and the file will not open at all, the database itself needs rebuilding at the transaction level. Our engineers handle that as part of QuickBooks data recovery for a file that will not open. Until you decide, image the folder and stop retrying; each failed open risks the copy you still have.