How to Set Up Automated Backups for Sage and MYOB Accounting Data to Prevent Financial Loss
Summary
This guide helps you troubleshoot and resolve: How to Set Up Automated Backups for Sage and MYOB Accounting Data to Prevent Financial Loss. Follow the steps below to fix the issue.
Common Causes
Set Up Automated Backups for Sage and MYOB Accounting Data
Accounting data is the backbone of any small business. Losing access to your Sage or MYOB files due to hardware failure, accidental deletion, corruption, or ransomware can cause significant operational disruption and financial loss. This guide walks you through configuring automated backups for Sage and MYOB accounting software to ensure your financial records remain secure and recoverable.
Before You Begin: Multi-User Environment Warning
If your business uses Sage or MYOB in a multi-user environment, all users must log out of the company file or the software must be placed in single-user mode before performing file-level backups. Backing up an active, in-use database file can result in corrupted backups or incomplete data captures. Software-native scheduled backups handle this process more safely than manual file copies.
1. Locate Your Accounting Data File
Before automating backups, identify exactly where your company file is stored.
- MYOB AccountRight: Typically found in
C:\Users\[YourName]\Documents\MYOBor a custom folder specified during installation. - MYOB Essentials: Data is stored in the cloud; use MYOB's native export and backup functions rather than attempting to copy local database files.
- Sage 50: Usually located in
C:\ProgramData\Sage\Accountsor within yourDocumentsfolder, depending on version and installation choices. - Sage Business Cloud: Data is hosted by Sage; use the platform's built-in backup and export tools rather than local file copying.
Open your accounting software, go to File > Open, and note the full file path of your active company file.
2. Configure Software-Native Scheduled Backups (Recommended)
Use the accounting software's built-in backup utility as your primary method. These tools are designed to handle locked database files correctly and minimise the risk of corruption.
MYOB AccountRight
- Open MYOB AccountRight and open your company file.
- Go to File > Backup Company File.
- Select Schedule Backup.
- Choose a backup destination, such as an external drive or network location.
- Set the schedule to run daily, preferably after business hours when no users are logged in.
- Save the schedule and confirm the settings.
MYOB Essentials
MYOB Essentials is cloud-based. Use the File > Export function to regularly export reports and data files to a secure local or network location. Schedule this export as part of your weekly financial administration routine.
Sage 50
- Open Sage 50 and open your company data.
- Go to File > Backup.
- Select Schedule Backup or Backup Settings, depending on your version.
- Configure the backup to run automatically at a set time each day.
- Choose a destination outside the live data folder, such as an external drive or NAS.
- Enable verification if available to confirm the backup completed successfully.
Sage Business Cloud
Sage Business Cloud stores data on Sage's servers. Use the platform's Backup or Export options within File or Settings to download periodic copies of your financial data. Store these exports on an encrypted local drive or secure cloud backup service.
3. Secondary Method: Windows Task Scheduler with Robocopy
Use Windows Task Scheduler only as a fallback when the software's native backup tool is unavailable. Because robocopy copies files at the file-system level, it risks copying locked or in-use database files. Always ensure all users are logged out and the software is closed before the scheduled task runs.
- Press
Windows Key + R, typetaskschd.msc, and pressEnter. - In the right-hand pane, click Create Basic Task.
- Enter a name such as
AccountingDataBackupand click Next. - Select Daily as the trigger and set a time when the computer is on but the accounting software is closed (for example, 6:00 PM).
- Choose Start a program and click Next.
- In the Program/script box, enter
robocopy. - In the Add arguments box, enter your source and destination paths. Example:
"C:\Users\YourName\Documents\MYOB" "E:\Backups\MYOB" /E /ZB /R:3 /W:5 - Click Finish to save the task.
4. Backup Destinations: External Drives, NAS, and Cloud
Store backups on a separate device from your live accounting data. Suitable destinations include:
- External USB hard drive (rotate drives weekly for added protection).
- Network-attached storage (NAS) device on your local network.
- Encrypted, versioned cloud backup service.
5. Backup Frequency and Retention
For accounting data, follow these minimum recommendations:
- Frequency: Back up at least daily. High-volume businesses processing many transactions should consider more frequent backups during the business day.
- Retention: Keep daily backups for at least one month, weekly backups for at least three months, and monthly backups for at least one year.
- Compliance: Australian businesses must keep financial records for at least five years to meet ATO and ASIC requirements. Ensure your retention policy supports audit and compliance needs for this period.
6. Verify Your Backups
A backup is only useful if it can be restored successfully. Implement a regular verification routine:
- Monthly restore test: Restore a backup to a test computer or separate folder and open it in Sage or MYOB to confirm the file is readable and complete.
- File integrity: Review backup logs after each scheduled run to confirm success. Do not assume a backup completed because no error appeared on screen.
- Documentation: Record the date, result, and any issues from each restore test. Keep these records with your compliance documentation.
- Locate your most recent verified backup file or folder.
- For software-native backups, open Sage or MYOB and use File > Restore to restore from the backup file.
- For file copies, copy the data back to the original accounting data directory, then open the software and use File > Open.
- Always test restoration on a separate computer or in a test environment before relying on your backup strategy in production.
- Ensure the computer is not in Sleep mode at the scheduled time.
- Check that the user account running the task has permission to access the source folder.
- Verify the destination drive is connected and has sufficient space.
- Review Windows Task Scheduler history for specific error codes.
- Do not overwrite your last known good backup with a failed or corrupted file.
- Attempt to restore from an earlier backup date.
- Contact your IT support provider if multiple consecutive backups fail verification.
- Confirm the backup user account has read access to the source accounting folder and write access to the destination.
- Check NAS share permissions and NTFS folder permissions separately; both must allow the backup operation.
- Test manual file copying from source to destination using the same user account to isolate permission issues.
- If using OneDrive, Google Drive, or similar sync services, look for conflicted copies or sync error icons.
- Exclude active accounting database files from sync folders to prevent corruption from simultaneous sync and write operations.
- Use a dedicated backup application with versioning instead of sync for accounting data.
- Close Sage or MYOB completely before the scheduled backup time.
- Ensure all users have logged out of the company file in multi-user environments.
- Use the software's internal backup feature instead of a file copy, as it handles locked files correctly.
7. Restoring from a Backup
Troubleshooting
Backup Task Fails to Run
Backup Verification Fails or File is Corrupted
Insufficient Permissions on Network Drives or NAS
Cloud Sync Conflicts
File is "In Use" and Cannot Be Copied
For further assistance with configuring your backup strategy, please Open a Ticket.
Still Having Issues?
💻 Open a Ticket