There are no Sage specific utilities to backup Sage 100 Premium (SQL) databases. Microsoft SQL Server and third-party tools can automate SQL database backups.

[BCB:2:Database warning:ECB]

Back up Sage 100 Premium

1. Get everyone out of Sage 100 Premium then stop the Sage 100 Application Service.
2. Make a backup\copy of the ...\MAS90\ folder.
3. Open SQL Server Management Studio.
4. Select the SQL instance for your Sage 100 installation.
5. Enter login credentials then select Connect.
6. Expand Databases.
7. Right-click the MAS_XXX database you’re backing up (XXX=company code).
8. Select Tasks.
9. Select Backup.
10. Verify the Backup type is Full.
11. Verify the Backup Component is Database.
12. In the Destination field, note the path and file name (.BAK file by default).
13. Click OK.
14. Repeat Steps 6 – 13 for each Sage 100 Premium database; this includes MAS_System.
15. Exit SQL Server Management Studio.

Restore Sage 100 Premium

1. Make sure ALL users are out of Sage 100.
2. (if applicable) Rename existing MAS90 folder then restore from backup.
3. Open SQL Server Management Studio.
4. Select SQL Server Instance for Sage 100 installation.
5. Enter Login credentials then select Connect.
6. Expand Databases.
    NOTE: Make sure you also have a copy of the current database before restoring from backup. In the next step, we’ll delete the existing copy of the database. 
7. (If applicable) Right-click the database you want to restore and select Delete. Click OK to delete the database.
8. Right-click Databases and select Restore Database.
9. Select Device under Source then select browse button (ellipses ‘…’).
10. Click Add, then browse to the location you saved your backup file.
11. Select the backup file then click OK twice.
12. On the Restore Database screen, select ‘Files’ from the left panel.
13. Verify the Restore path is correct. If the path is incorrect select ‘Relocate all files to folder’, and enter the desired path.
14. Select OK.
15. Right-click the restored Database and select Properties.
16. Select Files from the left panel.
17. Type ‘MAS_USER’ (without quotes) in the owner field.
18. Select OK.
19. Repeat Steps 6 – 18 for each Sage 100 databases you need to restore.
20. Exit SQL Server Management Studio.

Back up and restore data, program, and system files
Backup Sage 100 Standard or Sage 100 Advanced