Friday, August 31, 2007

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.


-- Add Your Comment --

Email address is not published
Remember Me

Write the characters in the image above

Things to Do
John's business web site
Google RSS and Gadget

Visit or Join Blog Catalog
Things to Buy

Nice tool to speed up your PC

Look for Pocket Controller Pro
Things to Read
Mezzanine View
Politics - Environment - Technology
Bridging the Gap...
to better writing
Autorotate's Flying Circus
Politics with humor - enjoy
Things to Buy

Best for Windows on Mac

Great backup software - low price
'Who sent you' top 10
Shameless Plugs
VBS Reachout Adventures
Vacation Bible School Program
Keep'n' Safe
Good deals on gun safes
Screw Outfitters
Complete line of Faspac fasteners
Tom Haseltine Photography
Note cards and more
East Point Seafood
Order canned seafood from cannery