Microsoft SQL Server and other third-party backup programs provide the ability to automate the backup of your SQL databases

• Backing 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 on the MAS_XXX database to be backed 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

Restoring 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 will 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 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 desired path
14. Select OK
15. Right-click the restored Database and select Properties
16. Select Files from 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