How to set up an automated backup for Sage and MYOB accounting data to an external drive
Summary
This guide helps you troubleshoot and resolve: How to set up an automated backup for Sage and MYOB accounting data to an external drive. Follow the steps below to fix the issue.
Common Causes
Automating your Sage and MYOB accounting backups protects your financial records against hardware failure, accidental deletion, and ransomware. Scheduling regular backups to an external drive maintains a current copy of your company data without relying on manual intervention.
Before you begin
- Connect an external USB drive to the computer hosting your accounting software.
- Note the drive letter assigned in File Explorer (for example,
E:\). - Ensure the drive has sufficient free space for your company file and several weeks of backup history.
- Close all other applications to reduce the risk of file locks during the backup process.
Sage 50cloud: Configure scheduled backups
- Launch Sage 50cloud and open your company file.
- Navigate to File > Backup.
- Select Backup to external drive.
- Click Browse, select your external drive, and create a dedicated folder such as
E:\Sage Backups. - Select Schedule automatic backups.
- Choose Daily as the frequency and set a time outside of business hours.
- Enable Verify backup after completion if available.
- Click Save to activate the schedule.
Sage Business Cloud: Configure scheduled backups
- Log in to Sage Business Cloud and open your organisation.
- Go to Settings > Company settings > Backup.
- Select Download backup to local drive.
- Choose your external drive as the save location.
- Set the schedule to Daily and select a preferred time.
- Click Save schedule.
MYOB AccountRight: Native scheduling vs Windows Task Scheduler
Not all MYOB AccountRight editions include a native recurring backup scheduler. Use the section below that matches your version.
MYOB AccountRight editions with native scheduling
- Open MYOB AccountRight and open your company file.
- Go to File > Backup.
- Select Backup to a local drive.
- Choose your external drive from the destination list.
- Select Schedule this backup.
- Set the frequency to Daily and choose a time when the computer will be on and the file will not be in use.
- Click Finish to save the schedule.
MYOB AccountRight editions without native scheduling
If your version of MYOB AccountRight does not offer a recurring scheduler, use Windows Task Scheduler to launch the backup process. This does not back up the file automatically within MYOB itself, but it can trigger a backup routine or remind you to perform the backup at a set time.
- Press Windows key + R, type
taskschd.msc, and press Enter to open Task Scheduler. - In the Actions pane, click Create Basic Task.
- Enter a name such as MYOB Daily Backup Reminder and click Next.
- Select Daily and click Next.
- Choose a time outside business hours and click Next.
- Select Start a program and click Next.
- Browse to the MYOB AccountRight executable or a backup script and click Next.
- Review the settings and click Finish.
- Right-click the new task and select Properties.
- On the General tab, select Run whether user is logged on or not.
- On the Conditions tab, ensure Start the task only if the computer is on AC power is cleared if using a laptop.
- Click OK to save.
Verify backup integrity and test restores
- After the first scheduled backup, open File Explorer and navigate to your external drive backup folder.
- Confirm that a new backup file exists with today's date in the file name or timestamp.
- Open Sage or MYOB and use the Restore utility to point to the backup file on the external drive.
- Perform a test restore to a separate folder or test company file, not your live production file.
- Confirm that the restored data opens correctly and contains recent transactions.
- Repeat this restore test at least once per month.
Backup retention and drive management
- Accounting backup files can grow large over time. Set a retention policy, such as keeping daily backups for four weeks and monthly backups for twelve months.
- Manually delete older backup files from the external drive when it approaches capacity, or rotate between multiple drives.
- If the external drive fills up, scheduled backups will fail. Check drive space weekly.
- For ransomware protection, rotate external drives between the office and a secure offsite location so at least one backup copy is not permanently connected to the network.
Troubleshooting
External drive not detected
- Ensure the drive is securely plugged into a USB port.
- Check File Explorer to see if the drive letter is assigned.
- Try a different USB port or cable.
Backup fails with "Permission Denied" or file locked
- Close Sage or MYOB completely and ensure no other users are in the company file.
- Set the accounting software to single-user mode if supported.
- Ensure you are logged in as an administrator on the computer.
- Check that the external drive is not set to read-only.
Scheduled backup did not run
- Verify the computer was powered on at the scheduled time.
- Ensure the external drive was connected before the schedule started.
- Check the backup logs within Sage or MYOB for error codes.
- For MYOB tasks created in Windows Task Scheduler, open Task Scheduler and review the History tab for the task.
Backup file corruption
- Do not use a backup file that reports errors during verification.
- Restore from the previous known-good backup set.
- If corruption recurs, check the external drive for errors using File Explorer > Properties > Tools > Error checking.
- Contact support if the company file itself appears damaged.
External drive full
- Open File Explorer and check the free space on the external drive.
- Delete obsolete backup files according to your retention policy.
- Connect a second external drive and rotate drives weekly to maintain offsite copies.
- Re-run the backup after freeing up space.
If you continue to experience issues with your accounting backups, Open a Ticket with our Brisbane support team.
Still Having Issues?
💻 Open a Ticket