Backup Sage 300 data using database dump.
The Database Dump (dbdump) function is a backup and compression utility built into Sage 300. It is extremely handy because end-users can run the backup without having to involve any outside IT personnel, or without having to know SQL and without needing access to the server.
DBDump can be found in two places. From within the Sage 300 program, go to Administrative Services / Database Dump. The security rights granted to the user determine their access to the dbdump function, so no further password is needed. From outside the program, go to Start, All Programs, Sage, Sage 300 ERP 2014, Tools, Database Dump. From outside the program, the ADMIN password is required. It is not mandatory for all users to be out of the program while a dbdump is being run, however, if the backup is to be used for a potential restore, than this is recommended.
Select the database for the company that needs to be backed up. Set the directory location where the backup files should be stored. Provide a description for the backup and click Dump. If the dump process is being run from Administrative Services, there is an option to set a description for the backup before proceeding. If the dbdump is being run from the Tools menu, outside the program, the Description option does not come up until after the dump process has been completed.
A confirmation message will appear that says 'Any existing dump files will be deleted?' This means that any files of the same name, that have been previously dumped into that folder, will be deleted before the current backup is written. If you are backing up company ABCDAT and ABCSYS for example, they will not overwrite each other. But if the backup of ABCDAT is done every day to the same location, each days backup will overwrite the one that was there previously. To retain multiple backups for the same company, set the directory location to different folders each time the backup is run.
The dbdump process 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 dbdump is dependent upon the size of the database, and environment variables, such as the speed of the network.
When the process has been completed, a summary screen will display the number of tables processed, and the number of bytes of data.
For information on how to restore a dbdump backup file, see Restore using DBLoad