« New QuickBooks Training Opportunities | Main | QuickBooks: Can You Explain the Difference Between a Sales Order and a Sales Receipt? »

December 13, 2012


Feed You can follow this conversation by subscribing to the comment feed for this post.

Hi Greg:

Indeed, your comments are spot-on. Sadly, this is an issue that many businesses aren't even aware of when it comes to QB, and they don't find out until the TLG file size jumps up and bites them.

I am not a technical guy by any stretch - are you familiar with how other databases "clean themselves up" like the backup routine does with QB?

I have to believe there are systems out there that are somewhat self-maintaining in this area that don't need the administrative attention that QB does. But maybe I'm wrong too.

Scott Gregory

Hi Janet:

It is best to actually do the backup of the QB data file on the server (but it can be done to other computers if necessary).

However, in addition to that, it is essential that the server then be backed up and a copy of the server data (which includes the QB backup) be stored off the server (i.e. external drive, cloud backup service, etc.)

Hope this helps!

Scott Gregory

Is it ok to actually do the backup with the quickbooks files on the server? I thought I had read somewhere that you needed to copy files to an individual computer.

Scott, this is something that STILL amazes me about Quickbooks...there is no effective way to automate a complete backup and take care of the TLG file.

So even with Quickbooks Enterprise we need to sign in off-hours, switch to single-user mode, and run a manual backup. We actually take a weekend now and call it "Quickbooks Backup Weekend," prepare the remote sessions and run 'em in line for half a day.

It's maddening that there is no automated way to do this in 2012. And no automated way for QB to clean up its own transaction log. And no manual way for us to clean up the t-log while the server is running.

The comments to this entry are closed.

Follow Scott


Site Meter