Home › Knowledgebase › KB-895

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.

Quick Tip: Need immediate assistance? 💻 Open a Ticket

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.

Important: Before initiating any backup, ensure Sage or MYOB is in single-user mode and that no other users are accessing the company file. Accounting files are often locked while the application is open. Attempting to back up an active, multi-user file can result in backup failure or a corrupted backup set.

Before you begin

Sage 50cloud: Configure scheduled backups

  1. Launch Sage 50cloud and open your company file.
  2. Navigate to File > Backup.
  3. Select Backup to external drive.
  4. Click Browse, select your external drive, and create a dedicated folder such as E:\Sage Backups.
  5. Select Schedule automatic backups.
  6. Choose Daily as the frequency and set a time outside of business hours.
  7. Enable Verify backup after completion if available.
  8. Click Save to activate the schedule.

Sage Business Cloud: Configure scheduled backups

  1. Log in to Sage Business Cloud and open your organisation.
  2. Go to Settings > Company settings > Backup.
  3. Select Download backup to local drive.
  4. Choose your external drive as the save location.
  5. Set the schedule to Daily and select a preferred time.
  6. Click Save schedule.
Note: Sage Business Cloud backups are initiated through the cloud interface. If your organisation requires the backup file to reside on a local external drive, ensure the scheduled download completes successfully each day and verify the file in File Explorer.

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

  1. Open MYOB AccountRight and open your company file.
  2. Go to File > Backup.
  3. Select Backup to a local drive.
  4. Choose your external drive from the destination list.
  5. Select Schedule this backup.
  6. Set the frequency to Daily and choose a time when the computer will be on and the file will not be in use.
  7. 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.

  1. Press Windows key + R, type taskschd.msc, and press Enter to open Task Scheduler.
  2. In the Actions pane, click Create Basic Task.
  3. Enter a name such as MYOB Daily Backup Reminder and click Next.
  4. Select Daily and click Next.
  5. Choose a time outside business hours and click Next.
  6. Select Start a program and click Next.
  7. Browse to the MYOB AccountRight executable or a backup script and click Next.
  8. Review the settings and click Finish.
  9. Right-click the new task and select Properties.
  10. On the General tab, select Run whether user is logged on or not.
  11. On the Conditions tab, ensure Start the task only if the computer is on AC power is cleared if using a laptop.
  12. Click OK to save.
File lock warning: Windows Task Scheduler can launch MYOB or a backup routine, but it cannot force other users out of the company file. Ensure all users have logged out of MYOB before the scheduled time, or the backup may fail because the company file is locked.

Verify backup integrity and test restores

  1. After the first scheduled backup, open File Explorer and navigate to your external drive backup folder.
  2. Confirm that a new backup file exists with today's date in the file name or timestamp.
  3. Open Sage or MYOB and use the Restore utility to point to the backup file on the external drive.
  4. Perform a test restore to a separate folder or test company file, not your live production file.
  5. Confirm that the restored data opens correctly and contains recent transactions.
  6. Repeat this restore test at least once per month.

Backup retention and drive management

Troubleshooting

External drive not detected

Backup fails with "Permission Denied" or file locked

Scheduled backup did not run

Backup file corruption

External drive full

If you continue to experience issues with your accounting backups, Open a Ticket with our Brisbane support team.

Still Having Issues?

Need more help? If the issue persists after trying these steps, please open a support ticket and our team will assist you.

💻 Open a Ticket