QuickBooks Auto Data Recovery

If you happen to be the owner of the QuickBooks Pro, Premier, or enterprise software, you would have noticed an additional folder named ‘QuickBooks Auto Data Recovery’ at some point in time. The Auto Data Recovery of the ADR is a feature provided by Intuit that works for the creation and backup and replicating the original files and recalling these replicated filed files in case there is a need. In the essence, QuickBooks Auto Data Recovery is a brand new feature that was brought into the picture by Intuit back in the year 2010. That year, QuickBooks started its implementation of the Auto Data Recovery or the ADR feature it was initially introduced in the QuickBooks Desktop versions of Pro and Premier but was later added to the QuickBooks Desktop version of Enterprise as well later in the year 2012. The feature basically makes use of two different technologies from Sybase, that is,

Recover lost data with QuickBooks Auto Data Recovery
  • Auto-Replication, and
  • Auto Recovery.

To be really honest, QuickBooks Data Services can also be helpful when it comes to data loss or corruption of data. It can help in case of data recovery almost every time. However, since the process of data recovery is a tedious one, the process may take time and that might result in you not being able to use the QuickBooks software for a period of time. This is where QuickBooks Auto Data Recovery comes handy. The ADR feature can cut this relapse time by almost full and prevent any further loss in terms of time and business. There is one thing that you might want to know, that is, you should approach the Auto Data Recovery as the last resort after you have tried and tested all the other available solutions.

The two technologies are designed by Sybase. Sybase is a popular software company that designs and creates database management systems or DBMS, among other middleware products. The software firm was founded in 1984 in California. The auto replication technology creates duplicate files for the original QuickBooks Transaction Log file (.QBW.tlg) and the QuickBooks company file (.QBW). On the other hand, the auto recovery feature was designed to assist in the recovery of all the QuickBooks data that ever existed. No, this can be done in either of the two ways –

  • Recreating the corrupt or lost transactions by utilizing the QuickBooks Transaction Logs files (.QBW.tlg) along with the previous copy of the QuickBooks Company file (.QBW).
  • Recreating every transaction except the ones made in the final few hours along with the copy of both the QuickBooks Transaction Log file (.QBW.tlg) and the QuickBooks Company file (.QBW).

Things To Note Take Note Of About Auto Data Recovery (ADR)

  • The Auto Data Recovery feature is exclusively available for the QuickBooks Desktop versions of Pro, Premier, and Enterprise.
  • QuickBooks Accountant versions do not enjoy the availability of QuickBooks Auto Data Recovery.
  • The Auto Data Recovery feature can accommodate a backup of up to 1.5 GB of data. Therefore, if your backup data is more than 1.5 GB in terms of data, the backup file will not be created. For this, you have to take the necessary steps and make sure that the QuickBooks data files do not exceed the data limit of 1.5 GB.
  • Like any other feature, the Auto Data Recovery feature too functions on the framework provided by the QuickBooks software. Therefore, the best thing you can do in order to achieve optimal performance is that you can make sure that the QuickBooks software is updated regularly and has all the latest features provided by Intuit.

Recovering Latest Transactions Utilizing The Actual .tlg Files Along With The .qbw.adr File

Making use of the actual transaction log file (.tlg) and the Auto Data Recovery version of the transaction log (.qbw.adr) in order to recover all the lost QuickBooks transactions. Follow the steps –

  • Make a new folder on the desktop and name it ‘QBTest’.
  • Access the folder where the QuickBooks company file is saved.

Note: Simply press the keys F2 and Ctrl+1 on the keyboard in order to check the location of the company data file that is on the ‘Product Information’ screen and on the ‘No Company Open Window’.

  • Search your company files folder and locate the transaction file (.tlg). It will have the same name as the company data file.
  • In case you are not able to identify the transaction log file with the file extension .tlg, you need to perform these steps –
    • Press on Windows+E in order to start the File Explorer on the computer system.
    • Click on ‘Organize’ and then select ‘Folder and search options’. In case you are using Windows version 10,8, or 8, select ‘view’. And then select the option ‘file extension name’.
    • Now, select the option, ‘Hide extensions for known file types’.
    • Choose the option ‘Apply’ and then ‘OK’.
  • Proceed by copying the corresponding transaction log file with the file extension .tlg of your company file, and then carry on by pasting it to the QBTest folder on your Desktop.
  • Access the folder named ‘QuickBooksAutoDataRecovery’. The location of this folder is the same as that of the location of the QuickBooks company data file.
  • Now, proceed by copying the Auto Data Recovery file of the QuickBooks company data file with the extension .qbw.adr and then paste it in the folder named ‘QBTest’. Before proceeding further, you need to have a file with the extension .qbw.adr and a file with the extension .tlg inside the QBTest folder.
  • Once in the QBTest folder, proceed by right clicking on the .qbw.adr file and choose the option ‘rename’.
  • Now, proceed by deleting the ‘.adr’ part from the end of the file name.
  • Now, open the QuickBooks software.
  • Proceed by accessing the company data file that is saved in the QBTest folder. Now, verify all the previous transactions by making use of the account register.
  • Once all this is done, choose File>>Utilities>>Verify Data in order to check the integrity of the recovered data files.
  • If the copy of the recovered company file is good and operational, you may proceed to move the damaged or corrupt company data file to a different location and then transferring the newly created copy from the folder QBTest to the actual designated location.

Recovering The Latest Transactions Using The .tlg.adr Files And The .qbw.adr Files

The solution mentioned below will make use of the Auto Data Recovery version of both the .tlg and .qbw files. The solution will help you recover all except the last 12 hours of the transaction history.

  • Make a new folder on your computer system with the name ‘QBTest’.
  • Access the folder where the QuickBooks company file is saved and search for the folder named ‘QuickBooksAutoDataRecovery’.

Note: Simply press the keys F2 and Ctrl+1 on the keyboard in order to check the location of the company data file that is on the ‘Product Information’ screen and on the ‘No Company Open Window’.

  • Search your company files folder and locate the ADR version of the transaction log file (.tlg.adr) and the ADR version of the QuickBooks data file (.qbw.adr). It will have the same name as the company data file. In case you did not notice, these files have the same name as the company data file.
  • In case, you are not able to recognize the ADR version of the transaction log file (.tlg.adr) and the ADR version of the QuickBooks data file (.qbw.adr), you need to perform the steps mentioned below.
    • Press on Windows+E in order to start the File Explorer on the computer system.
    • Click on ‘Organize’ and then select ‘Folder and search options’. In case you are using Windows version 10,8, or 8, select ‘view’. And then select the option ‘file extension name’.
    • Now, select the option, ‘Hide extensions for known file types’.
    • Choose the option ‘Apply’ and then ‘OK’.
  • Proceed by copying the corresponding ADR versions of the transaction log file with the file extension .tlg.adr and the ADR version of the QuickBooks company data file with the file extension .qbw.adr, and then carry on by pasting it to the QBTest folder.
  • In the QBTest folder, remove the extension .adr from the end of the file names. This will eventually give you files with extensions .tlg and .qbw in the QBTest folder.
  • Now, access the QuickBooks software.
  • Access the QuickBooks company file that you saved in the QBTest folder. Proceed further by utilizing the account register in order to verify if all the transactions are present.
  • Now, if you wish the integrity of the data, go to the top left, choose File>>Utilities>>Verify Data.
  • In case the copy of the QuickBooks company data file is good enough, you may simply move the damaged company data file to a different folder and then copy the newly created ADR version of the files from the QBTest folder and paste in the actual folder.

The intriguing thing is that despite the huge user base of the QuickBooks software and the huge role that QuickBooks Auto Data Recovery or ADR plays, many users are still not aware of the functionality of ADR and how important it can be in the functioning of the business. The concept of QuickBooks Auto Data Recovery or ADR can be easily understood in three steps.

  • The QuickBooks Database
  • The QuickBooks Database Server
  • The QuickBooks Database Mechanics

QuickBooks Database

The QuickBooks software has three fundamental elements, that is, QuickBooks application, the QuickBooks company file (.QBW) which is essentially the file that is located in the computer system and that contains all the data about the company, and finally, QuickBooks Database Server, which in reality, is the Sybase Database Server. There is an array of other related files that are formed and stored on the computer system when the QuickBooks software is used. One of these files is the QuickBooks Transaction Log file (.QBW.tlg).

The QuickBooks Database Server

The QuickBooks Database offers two separate version of the database from Sybase. This database server is basically a personal form of database that I installed in the computer system when QuickBooks has been installed in the hard drive as a standalone software and when the QuickBooks company file and the QuickBooks software are on the same system. This form of the QuickBooks Database Server doesn’t support server and client communications on a LAN or local area network. The database server can be seen running on the computer system as a Windows process in the form of a ‘QBDBMGR.exe’ file whilst it is running in a single user mode.

However, the database server can also be installed on the computer system as a network database in case you choose to install the QuickBooks software in a way that you wish to host the QuickBooks data file for letting them being used by other computer systems. This will eventually enable the ever and client communications based on a local area network or LAN. This will also grant multi-user access. The Windows process that runs during operation is called QBDBMGRN.exe. You should take note that the ‘N’ here differentiates the running process from the one mentioned earlier.

QuickBooks Database Mechanics

When you shut down the QuickBooks software, the QuickBooks company file (.QBW) usually withholds an accurate and complete copy of all the data. The data is clearly stored on the hard drive. These are contrary to the ‘dirty pages’ that are stored in the computer system’s RAM buffer cache amidst the operations while the QuickBooks database server is still being used.

When the database server is started, and the users start to access all the tables of data for lists as well as transactions, the data itself is not usually current, instead, the database server starts reading out the apt pages from the QuickBooks file in to the RAM where all that data is held within the cache. While all this is happening, the QuickBooks database server makes a duplicate of the actual page.

These duplicate pages are written down in a checkpoint log that is located at the very end of the database file. New pages are added to the database’s checkpoint log as required by the QuickBooks software whilst the database is still being used.

At the same time, the QuickBooks transaction log is also recording the various activities of the database server as it relates to your transactions.

quickbooks software phone number