| | Backup and restore data, program, and system files |
| 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 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
- From the Sage 100 Desktop, select File, Run, and enter *INFO.
- 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
- Open Library Master, Main menu, Company Maintenance.
- Enter the company code.
- Go to the Preferences tab.
- Note the Data Location and Payroll Data Location.
- Check if these paths differ from the default ..\MAS90\MAS_XXX path
- Close Company Maintenance.
- Paperless Office
- Open Paperless Office, Set up menu, Paperless Office Options.
- Note settings for Enable Electronic Delivery and PDF Storage.
- Close Paperless Office Options.
- 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
- Examine the Lists in each Maintenance task.
- Note the PDF Directory path for each setting in each list.
- 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 | [BCB:155:Chat 100 US:ECB]
|
|