{"id":1682,"date":"2019-11-06T20:20:27","date_gmt":"2019-11-06T20:20:27","guid":{"rendered":"https:\/\/quickbookexperts.com\/Blog\/?p=1682"},"modified":"2021-10-27T02:18:57","modified_gmt":"2021-10-27T02:18:57","slug":"database-db-file-fragments","status":"publish","type":"post","link":"https:\/\/quickbookexperts.com\/Blog\/database-db-file-fragments\/","title":{"rendered":"Database (DB) file fragments"},"content":{"rendered":"

Excessive DB File Fragments will lower the performance of your system. Learn a lot of regarding once and the way to defragment your system to avoid performance problems in your QuickBooks Desktop.<\/p>\n\n\n\n
<\/td>\n\n
\n

What are DB File Fragments?<\/b><\/p>\n

\n

DB File Fragments are:<\/b><\/p>\n

    \n
  • Discrete blocks of your disc drive during which Windows is storing your data file.<\/li>\n
  • A normal part of the operation of any program running below a Windows OS.<\/li>\n
  • A perform solely of the disc drive on that your data file is hold on.<\/li>\n<\/ul>\n<\/div>\n
    \n

    DB File Fragments are not:<\/b><\/p>\n

      \n
    • Created by QuickBooks Desktop or by the data manager.<\/li>\n
    • Corrupted blocks of your company file.<\/li>\n
    • Causes or indications of harm in your data file (e.g., record out of balance).<\/li>\n
    • Related to QuickBooks Desktop users or how they log in to the data file.<\/li>\n<\/ul>\n<\/div>\n

      Quick Tip!<\/span> Press F2 (or Ctrl + 1) in QuickBooks Desktop, to ascertain your “DB File Fragments” count.<\/h3>\n

      For a lot of information, see Microsoft support center<\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      How do DB File Fragments have an effect on QuickBooks Desktop operation?<\/h3>\n
        \n
      • Fragmentation is neither explanation for nor an indication of damage in your company file.<\/li>\n
      • Fragmentation is not a reason to setup QuickBooks Desktop or to reenter information.<\/li>\n
      • Excessive fragmentation will compromise performance because QuickBooks Desktop (and alternative applications) must read multiple blocks on your hard drive to retrieve data from a single file. Some tips are:\n
          \n
        • DB Fragments fewer than 100 sometimes do not affect QuickBooks performance.<\/li>\n
        • If your DB Fragments are more than 100, you must defragment your server\/host hard drive.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

          Reduce DB file fragments<\/h3>\n\n\n\n
          <\/td>\n\n
          Caution:<\/b>\u00a0Do not use the procedures in this article if your server\/host has a solid state drive (SSD). This type of drive should not be defragmented.<\/span><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          Check if your computer has a Solid State Drive (SSD)<\/h3>\n

          Windows 10<\/b><\/p>\n

            \n
          1. From your keyboard, press the Windows logo.<\/li>\n
          2. Enter\u00a0Optimize<\/b>, then select\u00a0Defragment and Optimize Drives<\/b>.<\/li>\n
          3. The Optimize Drives window opens.<\/li>\n
          4. The\u00a0Media type<\/b>\u00a0column tells you if your computer is running SSD or HDD.<\/li>\n<\/ol>\n

            Windows 8.1\/ 8\/ 7\/ Vista<\/b><\/p>\n

              \n
            1. Go to\u00a0Computer<\/b>, then\u00a0<\/b>right-click your Local Disk drive (C:).<\/li>\n
            2. Select\u00a0Tools<\/b>, then choose\u00a0Optimize<\/b>.<\/li>\n
            3. The\u00a0Optimize Drives<\/b>\u00a0window opens.<\/li>\n
            4. The\u00a0Media type<\/b>\u00a0column tells you if your computer is running SSD or HDD.<\/li>\n<\/ol>\n

              Short Term: Manually defragment your server\/host hard drive<\/h3>\n

              Important:<\/b>\u00a0Disk Defragmenting can take a long time to complete, especially if the disk has not been defragged for a long time. It may be best to run it overnight or even over the weekend.<\/p>\n

                \n
              1. In your company file, press F2 and record the number of DB File Fragments.<\/li>\n
              2. Follow instructions at\u00a0Microsoft support center.<\/li>\n
              3. Repeat Step 2 then note the difference in the number of DB File Fragments.<\/li>\n<\/ol>\n

                Long term: Set your server\/host to defragment automatically.<\/h3>\n

                You can set most Windows computers to defrag automatically. For Windows 10, 8, and 7:\u00a0Microsoft support center.<\/p>\n

                Create and restore a Portable Company File (PCF)<\/h3>\n

                If you cannot defragment your server\/host hard drive (the server is too busy or you do not have permissions) you can Create and restore a Portable Company File (PCF).<\/p>\n

                This technique can reduce DB File Fragments because it creates a new copy of your company data file which Windows stores on the hard drive. Be aware that:<\/p>\n

                  \n
                1. If the new file is stored in a less-fragmented portion of your drive, the DB File Fragments could decrease.<\/li>\n
                2. If the new file is stored in a more-fragmented portion of your drive, the DB File Fragments could increase.<\/li>\n<\/ol>\n

                  You must create and restore the PCF on your server\/host, which means that you simply should have the total QuickBooks program put in on your server\/host, not simply the QuickBooks data manager. If you copy your file to a workstation, produce and restore the PCF, then copy your file back to your server\/host, then the DB File Fragments might not amendment.<\/p>\n","protected":false},"excerpt":{"rendered":"

                  Excessive DB File Fragments will lower the performance of your system. Learn a lot of regarding once and the way to defragment your system to avoid performance problems in your QuickBooks Desktop. What are DB File Fragments? DB File Fragments are: Discrete blocks of your disc drive during which Windows is storing your data file. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,1,6,8],"tags":[],"class_list":["post-1682","post","type-post","status-publish","format-standard","hentry","category-other-questions","category-quickbooks","category-quickbooks-desktop","category-quickbooks-mac-desktop"],"_links":{"self":[{"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/posts\/1682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/comments?post=1682"}],"version-history":[{"count":1,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/posts\/1682\/revisions"}],"predecessor-version":[{"id":2712,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/posts\/1682\/revisions\/2712"}],"wp:attachment":[{"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/media?parent=1682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/categories?post=1682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/tags?post=1682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}