QuickBooks Issue with backup sizes using Storagecraft SPX

QuickBooks Issue with backup sizes using StorageCraft SPX - SAFE Image

Problem

Storagecraft will sometimes generate big images when QuickBooks is installed on the target machine. The QuickBooks Transaction log (TLG file) can sometimes start to generate big files if it is not maintained properly which leads to the backup sizes increasing rapidly.

What is the QuickBooks Transaction log file?

The QuickBooks transaction log file is a log of all the changes that are about to be made to the company file (.qbw) before they are actually recorded in the company file.  It is stored in the same folder as the company file itself.  It is automatically created by QuickBooks.
The filename of the transaction log file is in the form:  [company file name].qbw.TLG
QuickBooks uses data written to the transaction log file to transparently complete the recording of transactions that were not completely recorded in the company file itself because a connection to the company file was lost.  The transaction log file can also be used in conjunction with a QuickBooks backup file (.qbb) to recover from a damaged company file.

The transaction log file is reset when:
  1. You sucessfully complete a manual (not a scheduled or online) backup in QuickBooks.
  2. You restore a portable company file (.qbm).
  3. The company file does not match the transaction log file.
Because the transaction log file is only reset under specific circumstances, it may grow in size and become larger than the QuickBooks company file itself.  Large transaction log files can have an adverse effect on overall QuickBooks performance, so it’s important that you take care of it. 

Recommended Procedure on how to fix the issue in QuickBooks:

  • Everyone apart from 1 user logout of Quickbooks
  • Switch to single-user mode on Quickbooks
  • Run a manual backup to a local destination with the option of “complete verification” selected [image backups won’t trigger this option]
  • Confirm TLG file has shrunk
  • Return back to multi-user mode on Quickbooks
  • Note that where Quickbooks Auto data recovery is active the *.ADR & *.ADR.OLD files take time to reflect the new sizes


    • Related Articles

    • Setting up StorageCraft SPX - Safe Image

      To install SPX and create a continuous backup job on a Windows system: Create a backup folder to act as a destination for backup image files. This destination can be an: External hard drive NAS system on the same network Backup/Disaster Recovery ...

    • StorageCraft Downloads - Safe Image

      Please Note: these download links are for our Safe Data Storage Clients only, and will only work with the product keys we issue. If you require a key for a trial or need our help setting this up then please contact us on 01689 661030. StorageCraft ...

    • How to Manually activate SPX - SAFE Image

      1. Go to https://www.storagecraft.com/activation 2. Fill in customer information and serial number 3. Stop SPX service 4 Start SPX service 5 in C:\ProgramData\StorageCraft\spx open license.activate in notepad and copy content to the activation form ...

    • System Requirements and Installation instructions of SPX for windows - Safe Image

      Windows Installation You can install the SPX console and SPX agent together or separately. System Requirements Component SPX Requirement CPU 300 MHz or higher Pentium-compatible CPU Memory The greater of 256 MB or the Operating System minimum Hard ...

    • How to restore single files from local StorageCraft Backups - SAFE Image

      SAFE Image Please Note: This article assumes you have ShadowProtect installed on the machine being used to restore. To restore files and folders from an image backup is very simple. Browse to your backup image path (in this example, our backup path ...