by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks Tip – File Size & DB File Fragments What Do They Mean?

Print Friendly, PDF & Email

The size of your QuickBooks file and the number of DB File Fragments determines the health of your QuickBooks company data file. Most people don’t periodically check the health of their QuickBooks file to help prevent data corruption – mainly because they don’t realize that they should or even how to go about it.

Monday’s blog post – Basic File Maintenance Before & After You Upgrade – talked about checking your current file size and health before before you upgrade to a new version of QuickBooks.  In reality, you should periodically check this information just to see how healthy your file is or isn’t.

To check the size of your own QuickBooks file – with QuickBooks open press the CTRL and the 1 keys at the same time OR press the F2 key at the top of your keyboard – this will open a Product Information window; similar to that shown below, paying close attention to the circled areas – file location, file size and DB (database) file fragments:

Right click on the image to enlarge it

The screenshot above provides the following information about our own company data file:

  • File Size 180932 K or roughly 180 megs which is a fairly large file; this is confirmed by the fact that there are 17583 total transactions in the file
  • DB File Fragments 3 – anything under 20 DB file fragments means that your file is pretty healthy, while anything over 20 means your file is sick!

There are some things that you can do to try and repair you QuickBooks file yourself:

  1. Rebuild you company data file and check the Product Information Window after to see if the number of DB file fragments has been reduced
  2. Create and restore a Portable company file {watch our YouTube video} and check your results
  3. Seek the help of a professional to repair your data file – such as or QB or not QB

Keeping your QuickBooks data file healthy means that it will perform better!

We hope you found this tip to be helpful, if so please take a moment to leave a comment or share it on your favorite social network.

About Your Host:

Nancy Smyth, Certified QuickBooks ProAdvisor

Nancy Smyth, Sunburst Software Solutions, Inc.
QuickBooks Construction & Payroll Expert

I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Top QuickBooks blogs to read in 2018
We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
Stay updated!

Sign up to receive our latest QuickBooks Tips, Tricks & News via email:

Enter your email address:

Delivered by FeedBurner

We promise NOT to sell, rent, or otherwise distribute your name and email address!

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

certified payroll requirements webinar
QuickBooks Training

Frustrated with QuickBooks?

QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

QuickBooks Time Tracking

Save 10%/FREE 14-day trial!

QuickBooks Time Tracker