Unable to backup Reckon Accounts Premier Edition company file

  • 1
  • Problem
  • Updated 2 months ago
I seem unable to do a backup of our Reckon Accounts Premier Edition company file, as it has grown to a very large size (2.1 GB). When I do a backup, it gets to 71% (or thereabouts) and then shows a "Not Responding" message in the dialogue box, and never completes the backup. The .tmp file created in the process is about 1.9 GB, so it nearly gets there, but not quite. I ended up upgrading to 2018 without a backup, hoping that the 2018 version would fix the problem, but it hasn't. Any ideas appreciated! (I have tried closing off past years' transactions, but this has taken many hours and made no discernible difference to the size of the company file.)
Photo of Brad

Brad

  • 164 Points 100 badge 2x thumb

Posted 3 months ago

  • 1
Photo of John Peppas

John Peppas, Accredited Partner

  • 1,682 Points 1k badge 2x thumb
Hi

Run a full backup with full verification

Email me if further details are required

Admin@qldbc.com.au
Photo of John Graetz

John Graetz

  • 20,190 Points 20k badge 2x thumb
Hi Brad.  Are you doing a verify as part of your backup process?  How big is your .tlg file?  If you are not using verify, your .tlg file will grow very large and potentially larger than your data file.
As another possibility, have you tried doing a rebuild of your data file?
John L G
Photo of Brad

Brad

  • 164 Points 100 badge 2x thumb
Thanks Rav. They are interesting articles, and I certainly understand TLG files better now. However, unfortunately all of those solutions, and all the ones I seem to be coming across, involve doing a back-up as part of the process for fixing the problem, which is unhelpful when the problem I have is that I can't do a back-up!

I am now trying Linda's suggestion: I've just copied the qbw file and have managed to open it from the new location. I am going straight into a full backup (with verification) of this new file in the new location (with no associated TLG file) to see if this works. Will let you know how I go!

Thanks again for your help.
Photo of Brad

Brad

  • 164 Points 100 badge 2x thumb
Linda, you are a marvel!
I finally managed to shut down Reckon fully, copy just the qbw file to a new location, open it form this location, and then run a full back-up (with verification) from this new location. And it worked!!!
I've now move that file back to the original location, and got rid of the massive tlg file, and all is good again in the world. Reckon is working much faster, too, which is great.
Thanks heaps for your help. I will be sure to do regular verified back-ups from now on to keep the tlg file under control. 
Oh, and John, you were right - I think the problem was that I'd copied the qbw and the .nd file, and perhaps Reckon was running in the background when I did. When I followed Linda's recommendations and shut down Reckon completely, and just moved the qbw file, I was able to open it.
FYI I had previously done a verification (without backup) and it made no difference to the size of the tlg file. 
Thanks everyone!
Photo of John Graetz

John Graetz

  • 20,190 Points 20k badge 2x thumb
Great news, Brad.
John L G
Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,254 Points 10k badge 2x thumb
Hi Brad

Since Linda mentioned me earlier I thought I would move onto next steps for you.

At 2Gb plus, you need to consider a new datafile now.  With Single Touch payroll being implemented on the 1st July, this will be a crazy time for accredited partners. My advice would be to plan for a new file from 1 April.

Whilst I am all in favour of people having a go, a new file is a huge job.  I normally do a few steps and take a backup.  With most new files, I end up with 15-20 backups. There are a multitude of steps involved, the order things are done is critical, and there are issues that will trip you up. A new file usually takes me 8 to 12 hours.

My aim for clients is least possible disruption to normal business processing.   The process I use lets you use your file until the end of June, and invoicing in the new file on 1 July.

I would be happy to talk to you about the process and what's involved.

Graham 0409317366
graham@reckonhelp.com.au
Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,254 Points 10k badge 2x thumb
Hi Brad

Since Linda mentioned me earlier I thought I would move onto next steps for you.

At 2Gb plus, you need to consider a new datafile now.  With Single Touch payroll being implemented on the 1st July, this will be a crazy time for accredited partners. My advice would be to plan for a new file from 1 April.

Whilst I am all in favour of people having a go, a new file is a huge job.  I normally do a few steps and take a backup.  With most new files, I end up with 15-20 backups. There are a multitude of steps involved, the order things are done is critical, and there are issues that will trip you up. A new file usually takes me 8 to 12 hours.

My aim for clients is least possible disruption to normal business processing.   The process I use lets you use your file until the end of June, and invoicing in the new file on 1 July.

I would be happy to talk to you about the process and what's involved.

Graham 0409317366
graham@reckonhelp.com.au