To ensure the safety and continuity of your organisation's operations, it’s essential to back up your system regularly. Backups help protect your data against unexpected loss, system failures, or cyber threats.
We’ve outlined below the simple steps with video guides to conduct a full backup of your system, video guides, along with key best practices to help you maintain a secure and reliable backup strategy. Please share with your technical team(IT) if you are a non-technical person.
1. Application-Level Backup (Database Dump)
- Access Database Dump: Log in as an admin user to your company in Sage 300. Navigate to Administrative Services and select Database Dump.
- Choose Company and Destination: Select the specific company you wish to back up and then specify the destination where you want to save the backup file.
- Export Data: The system will then export all data from Sage 300 as application-level files to your chosen location.
- Repeat for Multiple Companies: If you manage more than one company, you will need to repeat this process for each company individually to ensure all data is backed up.
CLICK LINK TO VIDEO GUIDE -------> How to Backup Your Sage 300.mpeg
2. SQL Server Backups
- One-Off SQL Backup
This is useful for a quick, manual backup directly from SQL Server Management Studio.
- Right-Click Database: In SQL Server Management Studio, locate and right-click on the specific database you want to back up.
- Select Tasks and Backup: From the context menu, go to Tasks and then choose Backup.
- Specify Location: Provide a location on your server or network drive where the backup file should be saved, and then click OK.
- Scheduled Nightly Backups (Maintenance Plan Wizard)
This method allows for automated, regular backups, which is crucial for data integrity and disaster recovery.
- Access Maintenance Plans: Open SQL Server Management Studio. In the Object Explorer, navigate to Management and then expand Maintenance Plans.
- Start Plan Wizard: Right-click on Maintenance Plans and select Plan Wizard to begin setting up a new maintenance plan.
- Schedule Backup:
- Click "Next" in the wizard.
- Click "Change" to set up a schedule for your backups.
- Choose daily backups and set a specific time, such as 1 AM, when system usage is typically low.
- Select Backup Type: Choose Full Backup as the type of backup you want to perform.
- Select Databases:
- Specify which Sage companies you want to back up (e.g., "Sam Inc," "Sam Ltd").
- It is also highly recommended to back up the system database, as it contains crucial security and multi-currency information.
- Alternatively, for maximum safety, you can choose to back up "everything."
- Set Destination and Retention:
- Designate a specific destination folder for your backup files.
- Under "Options," configure the retention period for your backups (e.g., one or two weeks) to manage hard drive space efficiently.
- Configure Reporting (Optional): You can set up email notifications to receive confirmation that the backup process has completed successfully each night.
- Finish: Click "Finish" to finalise and set up the maintenance plan. SQL Server will then automatically perform the backups at your scheduled time.
CLICK LINK TO VIDEO GUIDE -------> How to Backup Your Sage 300 - MSSQL.mpeg
🛡️ Backup Best Practices:
- Automate Regular Backups: Set up scheduled backups (daily, weekly, etc.) to reduce the risk of human error.
- Use the 3-2-1 Rule: Keep 3 copies of your data, on 2 different media, with 1 copy stored off-site.
- Encrypt Sensitive Data: Protect your backup files using encryption, especially for cloud or external storage.
- Test Your Backups: Periodically restore data from backups to confirm that recovery works.
- Document the Process: Maintain clear records of backup procedures, schedules, and storage locations.
- Limit Access: Restrict backup access to authorised personnel only to avoid tampering or accidental deletion.