Making backups (and testing those backups) is vital to every company and should be a part of your regular business practices. At a minimum, you should create a backup before an upgrade, before and after processing year end, and before any major system changes - like system integration, or module installation.
Here's how to create - and restore - database backups in your Sage 300 ERP system.
How to CREATE a Database Backup
Note: You will need the Admin Password to create a backup. No other users can log into Sage 300 ERP while these utilities are in use.
3. Click to highlight the database that you want to Dump. Click the Set Directory button to enter the location where you want to save the files.
Database Dump creates a control file with filename extension .DCT in the folder you specify, and puts the actual extracted data in a subfolder of the same name as the DCT. The default location of the folder is . . .\Sage Accpac\Runtime. The name of the control file is the database ID with the .DCT extension.
5. Click the Dump button to proceed. A confirmation message will appear
6. Click OK to continue.
7. A Dataset Description screen will display in which an optional description of the database may be entered.. Enter a description, then click Done.
How to RESTORE a Database Backup
Note: When storing extracted data you must retain both the control file and its associated folder.
Note: Database Load takes a dataset (extracted data) and loads it into your Sage 300 ERP database. Any data already in the database will be deleted.
2. Enter the password for the Admin user, then click OK. The Datasets window lists the Sage 300 ERP datasets available for loading.
4. Click the Details button if you want further information about a highlighted dataset. The load utility will allow you to select, in turn, each of the databases you want to load.
5. Click Next. The next window lists the databases existing on your system.
Highlight the target database that you want to load into, then click Next.
6. Highlight the target database that you want to load into, then click Next.
7. Make sure you select the correct database. The Load will delete all existing tables in the database you select and replace all existing data.
8. Click Next to load another dataset. After you have selected as many datasets as you wish for this load, the Load Data window reappears, displaying the databases ready to be loaded.
Note: that the dataset we used in our example has now been loaded, and the list is empty.
Need Sage 300 Support?
Complete Guide to Sage 300 Keyboard Shortcuts and Hotkeys
How to Download and Install a Sage 300 Hotfix
How to Backup Your Sage 100 Company Database
Sage 300 Product Info and Features
Please share with your friends and co-workers: