Backup and restore data, program, and system files

Summary

Backing up and restoring system and data files for Sage 100.

Description

Before you begin

Back up regularly
- Include company data, system files, and program files in each backup
Have all users exit Sage 100 before backing up or restoring data
Stop services like Sage 100 Integration Engine, eBusiness Web Engine, and Sage 100 service or application
- Use Windows Task Manager to confirm all Sage-related processes have stopped
Contact your technician to choose the best backup method. Sage doesn’t endorse specific software or methods

Resolution

Make a backup

▼ Sage 100 Standard or Sage 100 Advanced

Use a reliable backup program and follow its instructions to back up Sage 100. Important notes about making a backup

Run full backups only. Don’t use incremental backups
- Avoid incremental backups to prevent missing files and possible program corruption
If using Symantec Backup Executive, exclude the ..\..\MAS90\HOME\LIB\KEYS directory. Symantec Backup Executive will deem the Activate.pvx file as corrupted or stop the backup. Save this file manually as it retains the keys to access data
Schedule backups before or after business hours
Ensure you back up the ..\..\MAS90 directory and all of its contents
Don't back up only dataset folders. Sage doesn't keep all the data for the customers within the dataset folder. There are also global files that live throughout the structure
If using Paperless Office, make sure to create backups of that directory as well. If the environment gets damaged by Ransomware that will be the first set of files that is affected
Store backups on a second server or external drives. Avoid storing backups on the same server as Sage 100
Protect backups from ransomware by using disconnected or offsite storage

▼ Sage 100 Premium

Sage 100 Premium

NOTE: Microsoft SQL Server and other third-party backup programs all automation of the backup of SQL databases.

Have all users exit Sage 100 Premium then stop the Sage 100 Application Service.
Make a backup or copy the ...\MAS90\ folder.
Open SQL Server Management Studio.
Select the SQL instance for your Sage 100 installation.
Enter login credentials and select Connect.
Expand Databases.
Right-click the MAS_XXX database to be backup (XXX=company code).
Select Tasks.
Select Backup.
Verify the Backup type is Full.
Verify the Backup Component is Database.
Note the path and file name in the Destination field (.BAK file by default).
Click OK.
Repeat Steps 7 – 14 for each Sage 100 Premium database, including MAS_System.
Exit SQL Server Management Studio.

Restore a backup

Restoring individual system data files isn’t a supported process with limited exceptions
- If you don't restore payroll with MAS_SYSTEM, they’ll be out of synchronization. This will cause errors and prohibit access
We recommend restoring the entire Sage 100 system, rather than just one or two modules. Restoring the entire "..\MAS90" folder and contents from your backup
- All modules post to General Ledger and some modules also post to other modules. It’s important to restore the entire Sage 100 system to prevent errors

▼ Sage 100 Standard or Sage 100 Advanced

Follow your backup provider’s method to restore the Sage 100 backup

▼ Sage 100 Premium

Make sure all users are out of Sage 100.
Rename the existing MAS90 folder if needed, then restore from backup.
Open SQL Server Management Studio.
Select SQL Server Instance for Sage 100.
Enter Login credentials and click Connect.
Expand the Databases folder.
NOTE: Ensure you have a copy of the current database before restoring.
If needed, right-click the database and select Delete. Click OK to confirm deletion.
Right-click Databases and select Restore Database.
Select Device under Source then select browse (...) button.
Click Add and browse to your backup file location.
Select the backup file then click OK twice.
On the Restore Database screen, select Files from the left panel.
Verify the restore path is correct.
If incorrect, select Relocate all files to folder and enter the correct path.
Select OK to start the restore.
Right-click the restored Database and select Properties.
Select Files from left panel.
Type MAS_USER in the owner field.
Select OK to save changes.
Repeat Steps 6 - 19 for each Sage 100 database you need to restore.
Exit SQL Server Management Studio.

Location of Files and Folders

Program and Data Files and Folders

Locate all files and folders under the live ..\MAS90 directory where Sage 100 is installed
If unsure of the install location, open Sage 100 Desktop
1. From the Sage 100 Desktop, select File, Run, and enter *INFO.
2. Note the directory path to the ..\MAS90 directory.
Reinstall the module and latest update if you have damaged program files and no backup exists

Company Data Folders and Files

Locate your data folders under a single folder for each Company Code
For example, ABC company data is in ..\MAS90\MAS_ABC
For Sage 100 Premium, the database name is MAS_ABC

Alternate Directories or Paperless Office

Alternate Directories or Locations
1. Open Library Master, Main menu, Company Maintenance.
2. Enter the company code.
3. Go to the Preferences tab.
4. Note the Data Location and Payroll Data Location.
  - Check if these paths differ from the default ..\MAS90\MAS_XXX path
5. Close Company Maintenance.
Paperless Office
1. Open Paperless Office, Set up menu, Paperless Office Options.
2. Note settings for Enable Electronic Delivery and PDF Storage.
3. Close Paperless Office Options.
4. Open Paperless Office, Set up menu, and each Maintenance task window. Review the settings below.
  - Journal and Register Maintenance
  - Period End Report Maintenance
  - Report Maintenance
  - Form Maintenance
5. Examine the Lists in each Maintenance task.
6. Note the PDF Directory path for each setting in each list.
7. Close each Maintenance window.

Folder names

Below is a grid of typical folders under the "..\MAS90" folder and their descriptions. This isn’t an inclusive list. Folders can be different for each version.

Two character folder names store program files
- For example, ..\MAS90\AP is for Accounts Payable module programs
Five character folder names store data files
- For example, ..\MAS90\MAS_ABC\APABC for Accounts Payable data files for the ABC company
Folders not matching these patterns are usually system folders
- For example, ..\MAS90\MAS_SYSTEM holds crucial system files, tax setup files and Paperless Office settings

Directory	Description
	Data Folders
\MAS_ABC	Main data folder for company ABC. Locate individual data folders under this folder (except for alternate directories)
\APABC	Accounts Payable data for company code ABC
\ARABC	Accounts Receivable data for company code ABC
\GLFDD	General Ledger data for company code FDD
\IMABC	Inventory Management data for company code ABC
\SOSYZ	Sales Order data for company code XYZ
\PRABC	Payroll data for company code ABC
	Program Folders
\AP	Accounts Payable program files
\AR	Accounts Receivable programs
\IM	Inventory Management programs
\GL	General Ledger programs
\VI	Visual Integrator programs and data files
\PR	Payroll programs
	System Folders
\BIExplorer	Business Insights views
\Ddicts	Data dictionary files
\Help	Help files
\Home	System program files and system data files
\HTMLOut	HTML files for Business Insights Dashboard
\Images	eBusiness Manager image files
\Launcher	Program and data files for the business desktopXXX
\Soa	System programs and system data files (legacy)
\MAS_System	System programs and system data files (Business Framework)
\Tutorial	Program files for tutorial
\Wksetup	Workstation installation files

Need more help?

Chat now