Setting Up Routine Backup for Epicor Progress Database

    progress-database-adminLooking to set up and schedule a routine backup for your Epicor Progress database? How about one that will remove old backups after a specified number of days and compresses the backup file to save space?

    This week's Tech Toolbox has an example of a batch file that does just that. It also creates a database verification log to confirm the backup is executing successfully.

    Copy the text between the copy below/copy above lines into a text file with a bat file extension.

    < - - - - - - - - - - COPY BELOW THIS LINE - - - - - - - - - - >

    @ECHO off
    ::change the OEDIR value to the location of your oe102a\bin folder on your server. NOTE: You can determine where your oe102a folder is by navigating to Start > Programs > OpenEdge > PROENV. The DLC value listed will point to your oe102a folder.
    ::change the DBDIR value to the location of your Epicor database files; this is where the database where you want to backup resides.
    ::change DBBKUPDIR to the location where you want the backup files to go.
    ::change the DBKUPNAME value to the name of your backup files.
    ::change the TESTRESTORELOG value to the name of database verification log; this will end up in the same folder as the db backups themselves.
    SET OEDIR=e:\epicor\oe102a\bin
    SET DBDIR=e:\epicor905\db
    SET DBBKUPDIR=f:\epicorbackups
    SET DBBKUPNAME=Epicor905LiveBkup
    SET TESTRESTORELOG=dbverification.log
    ::this will keep the last 8 database backups and will delete the backup with 7.bkup at the end of the name before starting this process.
    DEL %DBBKUPDIR%\%DBBKUPNAME%7.bkup
    REN %DBBKUPDIR%\%DBBKUPNAME%6.bkup %DBBKUPNAME%7.bkup
    REN %DBBKUPDIR%\%DBBKUPNAME%5.bkup %DBBKUPNAME%6.bkup
    REN %DBBKUPDIR%\%DBBKUPNAME%4.bkup %DBBKUPNAME%5.bkup
    REN %DBBKUPDIR%\%DBBKUPNAME%3.bkup %DBBKUPNAME%4.bkup
    REN %DBBKUPDIR%\%DBBKUPNAME%2.bkup %DBBKUPNAME%3.bkup
    REN %DBBKUPDIR%\%DBBKUPNAME%1.bkup %DBBKUPNAME%2.bkup
    REN %DBBKUPDIR%\%DBBKUPNAME%.bkup %DBBKUPNAME%1.bkup
    ::the -com parameter will compress the database backup as it can reduce the size of the backup by 10 to 40 percent.
    ::the -Bp parameter will use private buffers instead of using the before image file.
    ECHO starting Online database backup
    CALL %OEDIR%\probkup online %DBDIR%\mfgsys %DBBKUPDIR%\%DBBKUPNAME%.bkup -com -Bp 10
    :: this will verify the backup and output the results to a log.
    ECHO starting database backup verification
    ECHO *********** >> %DBBKUPDIR%\%TESTRESTORELOG%
    ECHO %DATE% %TIME% >> %DBBKUPDIR%\%TESTRESTORELOG%
    CALL %OEDIR%\prorest %DBBKUPDIR%\testrestore %DBBKUPDIR%\%DBBKUPNAME%.bkup -vp >> %DBBKUPDIR%\%TESTRESTORELOG%

    < - - - - - - - - - - COPY ABOVE THIS LINE - - - - - - - - - - >

    Additional Information

    You should review the database verification log to confirm that it was successful. You should see an entry like the following below - a message of 6758 in the log means that the database passed verification (which is good):

    Fri 09/07/2012 17:25:37.36
    OpenEdge Release 10.2A03 as of Mon Mar 19 19:14:30 EDT 2012s
    This is a full backup of e:\epicor905\db\mfgsys.db. (6759)
    This backup was taken Fri Sep 07 17:24:52 2012. (6760)
    The blocksize is 4096. (6994)
    Partial verification successfully read backup volume. (6765)
    Verify pass started. (3751)
    Verified 478909 db blocks in 00:00:22
    Backup for e:\epicor905\db\mfgsys.db verified ok. (6758)

    Afterwards, you can execute this batch file on a schedule using a Windows Scheduled Task. To validate that the backup is working I recommend reviewing the verification log gives the above results and also doing a test restore to a test database.

    Please don’t hesitate to contact Datix if you have any questions or would like assistance setting this up!

    TJ McDowell

    TJ McDowell

    Datix's EVP of Software Development, TJ, is a veteran development leader with experience in ASP.NET, SQL Server, Project Management, and many other valuable technologies. TJ possesses the ability to quickly transform technical requirements into powerful business outcomes.

    Innovation Starts from Within: Why Datix Hired a LaunchCode Apprentice Configuring Default Site Address for Shipped Epicor Reports

    Contact Us

    Categories

    see all

    Recent Posts