QuickBooks - Enterprise 7 - Backups
Quickbooks Enterprise Edition keeps a transaction log (.TLG) separate from the main company file (.QBW). A client with a comany file of about 490Mb had his transaction log grow to 1450Mb. This caused his automated nightly backup to take over 8 hours to finish and generated a backup file of about 1700Mb. After discussing the situation with a QB support guy, we decided to rename his log file to .OLD and try that. The company opened just fine and the next backup took only minutes with a file size of about 400Mb. One of my SQL customers has software that keeps only a daily transaction log so that you can rebuild the data if needed from the previous nights backup. There is no reason to keep transactions any longer than that. Until, I can find a better way to limit this file, I'll work on a script to delete or rename it every few days.
|Posted by John at 2:45:31 PM in Software (18)|