2 STEPS TO A HEALTHY QUICKBOOKS FILE:
1. Check for file damage, go to File > Utilities > Verify Data. The utility will tell if you the data file is damaged and lead you to the Rebuild utility. Do this repeatedly until the Verify Data tells you that there are no problems with data file integrity. (Verify and rebuild your company file)I followed Liz Fleming's advice in this Intuit "Friend to Friend" podcast, where she talks about keeping her client's data file fragments at less than 10.
2. Check for file fragmentation, press F2. The Product Information window will tell you the "DB File Fragments".If the DB Fragments are higher than 10, create and restore a portable company file
(Replace your company file with a restored portable company file)
How high can the BD File Fragments go before the file starts running slowly, or starts slowly losing data integrity? The answer depends on who you ask, in this Intuit online support article the author says "if the number of file fragments is greater than 100 it could indicate your hard drive is badly fragmented". (Defragment your Hardrive (these instructions are for Windows))
Verify and rebuild your company file
Replace your company file with a restored portable company file
Defragment your Hardrive (these instructions are for Windows)
Upgrading QuickBooks? Make sure your data file is healthy before you do it!