Database Backup

We use a batch file with the following contents:

REM
REM BATCH program to backup progress database without having to stop it
REM
REM Created 4/8/08 by CRK, from Epicor example
REM

Rem set your Progress directory, using only the physical path
SET XPrgsDir=e:\epicor\oe101b

Rem set your Database file, using only the physical path
SET XDbFile=e:\epicor\mfgsys803\db\mfgsys

Rem set your backup file and backup log file, using only a physical path
SET XBackupFile=e:\epicor\DB_Backup\Live\LiveBkup.1
SET XBackupLogFile=e:\epicor\DB_Backup\Live\LiveBkupLog.wri

Rem Run the progress backup utility
%XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% -verbose -com -red
5


This batch file is called by our network backup program (Symantec
BackupExec) at the begining of the nightly server backup. The last line
does all the work. all the SET lines just define some values used by
the probkup program. This batch file can be run while users are logged
in. However, if a user has a record locked, it may stall the backup
until the user unlocks the record.

By the way, THIS IS ONLY FOR THE PROGRESS DATABASE, SQL WILL NEED A
DIFFERENT PROCEDURE!!!

Calvin


--- In vantage@yahoogroups.com, "empedole" <empedole@...> wrote:
>
> Hello everyone;
>
> We have been having issues with backing up the test database that we
> are currently working on. Anyone have an idea how to write the batch
> file? We are using ver. 8.03.404.Here is the step that i think we are
> stuck on.
>
> "3. Create a batch file to run the online Progress db backup
> ==============================================
> Use the attached batch file MfgSys_backup.txt (it is attached as an
> alphanumeric text file, rename accordingly), and edit the SET
> statements to match your installation
> The first two SET statements need to be set correctly for your
> installation, the second two SET statements are arbitrary but need to
> refer to directories that exist
> Rem Edit below -----------------------------------------------
> Rem set your Progress directory, using only the physical path
> SET XPrgsDir=d:\epicor\oe100b
> Rem set your Database file, using only the physical path
> SET XDbFile=d:\epicor\mfgsys803\db\mfgsys
> Rem set your backup file and backup log file, using only a physical
path
> SET XBackupFile=d:\backups\Live\LiveBkup.1
> SET XBackupLogFile=d:\backups\Live\LiveBkupLog.wri"
>
> So my problem is how i can compile the codes on the .txt file. I know
> all our paths and everything.
>
> Thanks in advance.
>
> Erdal
>




[Non-text portions of this message have been removed]
Hello everyone;

We have been having issues with backing up the test database that we
are currently working on. Anyone have an idea how to write the batch
file? We are using ver. 8.03.404.Here is the step that i think we are
stuck on.

"3. Create a batch file to run the online Progress db backup
==============================================
Use the attached batch file MfgSys_backup.txt (it is attached as an
alphanumeric text file, rename accordingly), and edit the SET
statements to match your installation
The first two SET statements need to be set correctly for your
installation, the second two SET statements are arbitrary but need to
refer to directories that exist
Rem Edit below -----------------------------------------------
Rem set your Progress directory, using only the physical path
SET XPrgsDir=d:\epicor\oe100b
Rem set your Database file, using only the physical path
SET XDbFile=d:\epicor\mfgsys803\db\mfgsys
Rem set your backup file and backup log file, using only a physical path
SET XBackupFile=d:\backups\Live\LiveBkup.1
SET XBackupLogFile=d:\backups\Live\LiveBkupLog.wri"

So my problem is how i can compile the codes on the .txt file. I know
all our paths and everything.

Thanks in advance.

Erdal
The backup file that epicor wrote for us looks like this:

@echo off
rem Epicor BACKMFG.BAT created:07/98 JE - edited: 11/20/02
rem
rem This .bat script requires modification by the system
administrator
rem to include the correct paths and dirctory locations.
rem
rem NOTE:
rem Drive letter of database be a physical drive, not mapped.
rem Drive letter of backup copy can be physical or mapped,
rem on server or across network.
rem
rem General syntax of BACKMFG.BAT does the following:
rem 1) Surpress screen display (echo off)
rem 2) Drive letter locating the MFGBKUP.BAT file.
rem 3) Directory path to the MFGBKUP.BAT file.
rem 4) Call of MFGBKUP to do the backup "online"
rem of c:\path\mfgsys.db database to c:\backupdir\backup.file.
rem
rem System admin should EDIT the following:
rem a) Change DRIVE LETTER to drive where
rem directory PRGS91D\BIN\MFGBKUP.BAT is located.
rem b) Verify path to Mfgsys60\prgs91d\bin and edit if necessary.
rem c) Edit drive letter and path to database location.
rem d) Edit drive letter and path to where back should be placed
rem e) Create the BACKUP directory where backup file will be placed
rem f) copy the BACKMFG.BAT file OUT of the Mfgsys60 folder and
paste
rem it into any other directory were it will be called on.
rem (i.e. Backup, Prgs91d\Bin, scripts, etc.)

echo Running Backup...
@echo off
e:
cd \epicor\oe100b\bin
mfgbkup online e:\epicor\test80\db\mfgsys e:\backup\test80.1


You may need to change the drive letters based on where your test
database is installed.

Brad

--- In vantage@yahoogroups.com, "empedole" <empedole@...> wrote:
>
> Hello everyone;
>
> We have been having issues with backing up the test database that we
> are currently working on. Anyone have an idea how to write the batch
> file? We are using ver. 8.03.404.Here is the step that i think we
are
> stuck on.
>
> "3. Create a batch file to run the online Progress db backup
> ==============================================
> Use the attached batch file MfgSys_backup.txt (it is attached as an
> alphanumeric text file, rename accordingly), and edit the SET
> statements to match your installation
> The first two SET statements need to be set correctly for your
> installation, the second two SET statements are arbitrary but need
to
> refer to directories that exist
> Rem Edit below -----------------------------------------------
> Rem set your Progress directory, using only the physical path
> SET XPrgsDir=d:\epicor\oe100b
> Rem set your Database file, using only the physical path
> SET XDbFile=d:\epicor\mfgsys803\db\mfgsys
> Rem set your backup file and backup log file, using only a physical
path
> SET XBackupFile=d:\backups\Live\LiveBkup.1
> SET XBackupLogFile=d:\backups\Live\LiveBkupLog.wri"
>
> So my problem is how i can compile the codes on the .txt file. I
know
> all our paths and everything.
>
> Thanks in advance.
>
> Erdal
>
The backup file that epicor wrote for us looks like this:

@echo off
rem Epicor BACKMFG.BAT created:07/98 JE - edited: 11/20/02
rem
rem This .bat script requires modification by the system
administrator
rem to include the correct paths and dirctory locations.
rem
rem NOTE:
rem Drive letter of database be a physical drive, not mapped.
rem Drive letter of backup copy can be physical or mapped,
rem on server or across network.
rem
rem General syntax of BACKMFG.BAT does the following:
rem 1) Surpress screen display (echo off)
rem 2) Drive letter locating the MFGBKUP.BAT file.
rem 3) Directory path to the MFGBKUP.BAT file.
rem 4) Call of MFGBKUP to do the backup "online"
rem of c:\path\mfgsys.db database to c:\backupdir\backup.file.
rem
rem System admin should EDIT the following:
rem a) Change DRIVE LETTER to drive where
rem directory PRGS91D\BIN\MFGBKUP.BAT is located.
rem b) Verify path to Mfgsys60\prgs91d\bin and edit if necessary.
rem c) Edit drive letter and path to database location.
rem d) Edit drive letter and path to where back should be placed
rem e) Create the BACKUP directory where backup file will be placed
rem f) copy the BACKMFG.BAT file OUT of the Mfgsys60 folder and
paste
rem it into any other directory were it will be called on.
rem (i.e. Backup, Prgs91d\Bin, scripts, etc.)

echo Running Backup...
@echo off
e:
cd \epicor\oe100b\bin
mfgbkup online e:\epicor\test80\db\mfgsys e:\backup\test80.1


You may need to change the drive letters based on where your test
database is installed.

Brad

--- In vantage@yahoogroups.com, "empedole" <empedole@...> wrote:
>
> Hello everyone;
>
> We have been having issues with backing up the test database that we
> are currently working on. Anyone have an idea how to write the batch
> file? We are using ver. 8.03.404.Here is the step that i think we
are
> stuck on.
>
> "3. Create a batch file to run the online Progress db backup
> ==============================================
> Use the attached batch file MfgSys_backup.txt (it is attached as an
> alphanumeric text file, rename accordingly), and edit the SET
> statements to match your installation
> The first two SET statements need to be set correctly for your
> installation, the second two SET statements are arbitrary but need
to
> refer to directories that exist
> Rem Edit below -----------------------------------------------
> Rem set your Progress directory, using only the physical path
> SET XPrgsDir=d:\epicor\oe100b
> Rem set your Database file, using only the physical path
> SET XDbFile=d:\epicor\mfgsys803\db\mfgsys
> Rem set your backup file and backup log file, using only a physical
path
> SET XBackupFile=d:\backups\Live\LiveBkup.1
> SET XBackupLogFile=d:\backups\Live\LiveBkupLog.wri"
>
> So my problem is how i can compile the codes on the .txt file. I
know
> all our paths and everything.
>
> Thanks in advance.
>
> Erdal
>