Oftentimes you will hear advice to backup your QuickBooks file on a regular basis. Unfortunately, the term “backup” is often used to mean different things. A QuickBooks Backup is not to be confused with any of the many options available to backup your data files, or entire data drives or system drives. These backups are NOT the same as a QuickBooks backup. Simply making a copy of the QBW data file does not insure that you can recover all elements of your QuickBooks installation.
Moreover, when the QuickBooks backup routine is activated, QuickBooks initiates a series of procedures that begin with a test the integrity of the data file and then collects all the information QuickBooks needs to restore the installation. Not all the active data is stored in the QBW file.
If, as Intuit recommends, the option is selected in the Backup Options menu to do a complete verification of the data file , QuickBooks will perform a test to insure that the data file’s integrity is ok. This file verification analysis can become crucial to maintaining the integrity of the database.
After the file verification is complete QuickBooks will flush out the “tlg” file - a temporary file created by QuickBooks that provides the information that Intuit’s Tech Support will need to help you restore a corrupt data file. This file contains all the transactions posted since the last full internal backup. If the tlg file is not flushed on a regular basis, however, it will continue to grow in size - often surpassing the size of the core QBW file and possibly slowing system performance. This tlg file is flushed automatically whenever a full internal QuickBooks backup is performed. It is NOT flushed when an external data or system backup is executed by some other program or process.
The final QBB backup file will contain all the information from the various QuickBooks data files that is needed to restore your QuickBooks installation. This includes the “lmr” file that contains the Loan Manager data, the various letter templates and other data which are not stored in the main QBW file. When using its Restore Utility, in addition to restoring the main QBW file, QuickBooks provides a separate “restore” directory that contains the files and instructions necessary for completing the restoration process.
There are some exceptions, of course, like the FAM module. If you use the Fixed Asset Manager to track assets and calculate depreciation, then you will need to perform the FAM backup from within the FAM module itself as well as any third-party add-on applications that manage separate data files.
When QuickBooks completes its internal backup process it produces a QBB backup file in the directory you selected earlier in the process. It is usually recommended that you store a second copy of this QBB backup file in an off-site location. This can serve as part of your disaster recovery plan should the main backup drives somehow become inaccessible or destroyed or simply fail mechanically – and as you know, all hard drives will eventually fail. Having two copies of the QBB backup file (with one in a separate location, off premises) helps protect your ability to easily recreate your QuickBooks records.
Intuit even offers a “cloud-based” online backup service (at an additional fee, of course) which may provide you with the additional data security you need. Or simply copy the QBB backup file to an external portable hard drive or “memory stick” and store it in an secure 0ff-site location.
You can even use the QuickBooks scheduled backup feature to automatically perform a backup on a regular basis from within your desktop QuickBooks.
More on setting up a backup schedule in my next post…
Back to SourceCFO