DB file fragment is basically a measurement of how much your company file changes. It reflects how much and how often QuickBooks messes with it. This is not something peculiar to QuickBooks files. With any file in Windows, as changes to the file happen on the hard drive, Windows sometimes keeps segments of data together, and sometimes Windows will assign segments of data somewhere else on the drive. That “somewhere else”, in QuickBooks, is a DB file fragment.
When you restore a portable copy, it basically plops your file’s data into as much contiguous hard drive as it can find. Then when you do stuff in QuickBooks, the data changes and expands as new records are added or even modified. So Windows pushes the file out into new sectors of the drive and creates a new 'file fragment'.Continue reading