Sage 300 Database Load and Database Dump functions can

• Create backups of Company or System databases
• Create copies of companies
• Prepare data to submit to for review of a technical issue
• Restore companies from backups

Using the Database Dump Utility (Backup)

1. Open the Database Dump from the Sage 300 Admin Utilities.
2. Login using the Sage 300 admin user password.
3. Highlight the database that you want to dump.
4. Use the Set Directory button to enter the location where you want to save the files.
5. Click the Dump button to proceed. A confirmation message will appear.
6. After the dump, a Dataset Description screen appears. Here you enter a description of the backup.
7. A summary message displays.
8. Click Close to end the session.

Using the Database Load Utility (Restore)

Database Load takes the Dataset (extracted data) and loads it into a Sage 300 database. The database entry must exist and in Database Setup. 

1. Open Database Load from the Sage 300 Admin Utilities.
2. Login using the Sage 300 admin user password.
3. Use the Set Directory button to select the location of the backup that you want to restore.
4. Highlight the backup dataset to restore.
5. Use the Details button if you want further information about the highlighted dataset.
6. Click Next.
7. Highlight the database that you want to load the data into and click Next.
8. Make sure you select the correct database. The Load will delete all existing tables in the database you select and replace all existing data.
9. Click Finish to load the data. If the target database contains data, a warning message will appear.
10. Click Cancel to end the session.