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

Accounting data is the backbone of any small business. Losing access to your Sage or MYOB files due to hardware failure, accidental deletion, or ransomware can cause significant operational disruption and financial loss. This guide walks you through setting up automated backups to ensure your financial records remain secure and recoverable.

Quick Fix Steps

1. Identify the location of your Sage or MYOB company data file.
2. Schedule automated backups using built-in software tools or Windows Task Scheduler.
3. Store backups on an external drive or cloud storage, not on the same drive as your data.
4. Verify that backups complete successfully and test restoration periodically.

Detailed Instructions

1. Locate Your Accounting Data File

Before automating backups, you need to know exactly where your company file is stored.

• MYOB: Typically found in C:\Users\[YourName]\Documents\MYOB or a custom folder specified during installation.
• Sage: Usually located in C:\ProgramData\Sage\Accounts or within your Documents folder.

Open your accounting software, go to File > Open, and note the full file path of your active company file.

2. Set Up Automated Backups Using Built-in Software Features

Both Sage and MYOB have internal backup utilities designed to handle locked database files correctly.

• MYOB: Go to File > Backup > Schedule Backup. Configure automatic backups to run when you close the company file or at a scheduled time.
• Sage: Use the Backup option within the File menu. Select Schedule to set up automatic backups at regular intervals.

For the best protection, configure the software to save backups to an external drive or cloud storage location.

3. Set Up Automated Backups Using Windows Task Scheduler (Alternative Method)

If you prefer to use Windows Task Scheduler to copy your data files, ensure the accounting software is closed during the backup to avoid file corruption.

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 software is closed (e.g., 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.

4. Follow the 3-2-1 Backup Rule

For critical financial data, follow the 3-2-1 backup rule:

• Keep 3 copies of your data (original plus two backups).
• Store backups on 2 different media types (e.g., external drive and cloud).
• Keep 1 backup off-site (e.g., cloud storage or external drive stored elsewhere).

Troubleshooting

Backup Task Fails to Run

• 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.

File is "In Use" and Cannot Be Copied

• Close Sage or MYOB completely before the scheduled backup time.
• If the software must remain open, use the software's internal backup feature instead of a file copy, as it handles locked files correctly.

Restoring from a Backup

1. Locate your most recent backup file or folder.
2. For internal software backups, open Sage or MYOB and use File > Restore to restore from the backup file.
3. For file copies, copy the data back to the original accounting data directory, then open the software and use File > Open.
4. Always test restoration on a separate computer or in a test environment before relying on your backup strategy.

For further assistance with configuring your backup strategy, please Open a Ticket.

Still Having Issues?