There are different data or backup file formats in QuickBooks. Which ones do you need? Which ones should you use when you send data to your colleagues? Which ones do you want to backup to the cloud or offsite in case your drive crashes? Which ones would you send out for data repair in case of a data catastrophe?
QBW file. The first thing to understand is that your actual working data file is a QBW file. This is the most important QuickBooks data file you have on your system.
If you are looking at a QBW file in Windows, the Type is “QuickBooks Company File”. There will only be one of those for your company name.
Confusing: There is also a file called yourcompanyname.QBW, where the Type is “Data Source Name”. That file is not your actual data file.
QBB file. This is a regular backup file made within QuickBooks through the Backup Company / Create Local Backup command. It is often actually bigger than the main QBW file, and that’s normal. The QBB file contains the contents of the TLG file too, which makes it bigger.
QBM file. This is a portable file, a kind of backup file made with the QuickBooks Create Copy… / Portable company file command. This file is quite small compared to the main QBW file; it is often only 20% the size of the main QBW file. That’s because the indexing in the file is largely removed. But when you restore it, everything is there. So this file format is best for when you need to transfer QuickBooks data to your colleagues. This is the file format we request that clients upload to us for data repair, supercondense, or Enterprise downgrade work.
So which of these files should you upload to your cloud backup service, or offsite backup solution? Answer: All of them. If your system gets infected by malware, or your server drive goes down, or somebody accidentally deletes your files, you’ll want all the backups you can get, from as many recent dates as you can get, and in any format. To me, you can never have too many copies or backups of your accounting data.
Scenario: You find yourself in QuickBooks catastrophe mode: your server drive or local hard drive or RAID drive goes down. You don’t have the cloud or off-site backups you thought you did. Your IT pro recovers files from the crashed drive, including QuickBooks files. Yet, when you try to open the files, or restore backups, it fails. At that stage, only your QBW files might be salvaged. Damaged QBB or QBM files are not recoverable. But it might be possible to repair your damaged QBW file.
Bottom-line: When you are setting up your backup system, make sure you will be backing up everything in your \Company Files folder and subfolders under it. Or if you create or store your QBW, QBB or QBM files in a different folder, specify that folder to be backed up daily.