Home › Knowledgebase › KB-869

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.

Quick Tip: Need immediate assistance? 💻 Open a Ticket

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.

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

  1. Open MYOB AccountRight and open your company file.
  2. Go to File > Backup Company File.
  3. Select Schedule Backup.
  4. Choose a backup destination, such as an external drive or network location.
  5. Set the schedule to run daily, preferably after business hours when no users are logged in.
  6. 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

  1. Open Sage 50 and open your company data.
  2. Go to File > Backup.
  3. Select Schedule Backup or Backup Settings, depending on your version.
  4. Configure the backup to run automatically at a set time each day.
  5. Choose a destination outside the live data folder, such as an external drive or NAS.
  6. 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.

  1. Press Windows Key + R, type taskschd.msc, and press Enter.
  2. In the right-hand pane, click Create Basic Task.
  3. Enter a name such as AccountingDataBackup and click Next.
  4. 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).
  5. Choose Start a program and click Next.
  6. In the Program/script box, enter robocopy.
  7. 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
  8. Click Finish to save the task.
Caution: Do not rely on robocopy or simple file copies while Sage or MYOB is open and in use by multiple users. This can produce unusable or corrupted backups. Prefer the software's native scheduled backup feature.

4. Backup Destinations: External Drives, NAS, and Cloud

Store backups on a separate device from your live accounting data. Suitable destinations include:

Caution: Cloud sync services such as OneDrive or Google Drive are not a substitute for a true backup. Ransomware can encrypt files in your synced folder, and those encrypted versions will sync to the cloud, overwriting good copies. Use a dedicated backup solution with versioning and, ideally, immutability, rather than simple folder synchronisation.

5. Backup Frequency and Retention

For accounting data, follow these minimum recommendations:

Tip: Follow the 3-2-1 backup rule: keep three copies of your data (the original plus two backups), store backups on two different media types, and keep one backup off-site.

6. Verify Your Backups

A backup is only useful if it can be restored successfully. Implement a regular verification routine: