More a heads up than a question.
We have been using scheduled backups as soon as they became available. Having been a Sage 50 user for a long time, it was a feature long overdue, and it works beautifully.
However.....It stopped working sometime last week. I only knew because when I closed Sage when leaving work, it said I had not backed up in over a week. When I checked, there were no records of any previous automatic backups or data checks in the last 8 days. I came home, logged back on, and set to work, thinking a reinstall and restore may be the last resort If I cannot figure it out.
We had started seeing performance issues on the network. We also started seeing a message during daily use which none of us had seen before. During a customer search, we would see a very brief popup, "Automated backup in progress". The kind of popup with the progress bar. It was clearly linked to the issue.
I tied various things to get it working. When nothing worked, I was preparing to fully backup and perform a Clean install and restore. In the end I did not need to.
Manually, I could run a data check fine, and run the backup fine. Scheduled backup just would not work, to any location. Using Task Manager, I could see the scheduled process begin, but the file was never created. At this point I also noticed the the Sage 50 Accounts Service V29, had a LOT of disk usage, and more to the point, it never stopped using the disk until I stopped the service manually or rebooted. The disk usage would continue, even with Sage closed and no one logged in. This was the clue...
Knowing that the backup was first created in Windows/Temp, I opened that folder and watched the backup file be created, then disappear, then be created again, then disappear. It never stopped.
Going back into Sage, I noticed that my manual backups were for Data files only, whereas my Scheduled Backups contained Transactional & Customer record attachments. I then tried a manual backup using the same settings as the Scheduled backup, and the backup failed. "Error, unable to open file Customer xxxx/file xxx". Its been a very long time since we have had a backup error.
We keep PDF copies of PO`s in the customers records, as it makes thing easier come audit time. I could open the file (PDF) fine in Windows, but the backup did not like it. I re-saved the file with a different name and deleted the original. Set the scheduled backup and waited. Success.
In summary, the Attachment files are not checked by the "Check data" option, which is understandable.
But it would appear that the Scheduled Backup does not register the backup error. Instead, it just keeps trying, and trying, and trying to create the backup file as requested. No error messages, no indication anything is wrong, it just keeps going. This explains our performance issues. It even seems to start re-trying after a reboot. Maybe someone at Sage can confirm if this is correct, or whether we just had a glitch.
Apologies for the wall of text, but its used up all of my evening, and info like this can be invaluable. I know because I have been on the other end.
If it helps one person, it's been worth the waffle.
Its bed time.