Follow

Restore Sage 300 Data using Database Load

Problem Details:

Need to restore from backup.  The backup was done using Database Dump.

 

Solution:

In order to restore from a dbdump backup, the Database Load process must be used.  While it is possible to restore a database from within the program, it is recommended to run the Database Load function from outside Sage 300 to reduce chances of overwriting the wrong database. 

All users must be out of Sage 300 for the company being restored.  Go to Start, All Programs, Sage, Sage 300 ERP 2014, Tools and select Database Load.  The ADMIN password must be entered.  Datasets will be listed from the last directory specified from the last database dump.  If the dataset to be restored is not in this location, click on Set Directory and browse to the location of the correct file. Highlight the correct backup dataset and click Next.   Highlight the database that is to be restored (overwritten) and click Next.  Click Finish to start the process.  A warning message will appear "The database is not empty, existing data will be lost".  Click OK to continue or Cancel to go back to the selection screens.  The database will firstly be emptied of all data, and then the dbdump files will be loaded into the now empty database. 

As with the dbdump process, dbload  runs through the database tables in alphabetical order, and the user can use this information to have an idea of how far along the process is, and how much longer it may take. The order of the modules will be AP, AR, BK, CP, GL, IC, OE, PO, TX.  The length of time for dbload is dependent upon the size of the database, and environment variables, such as the speed of the network.  The dbload is a longer procedure than the dbdump. 

When the dbload has completed, the Load Data screen will be blank.  Click on Cancel to exit. 

Note that dbload can be used to restore an existing database, or it may be used to make a copy of an exisitng database by restoring (dbloading) into a different database than the dbdump came from. 

See Backup using DBDump for details on the dbdump function.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk