Vantage 8.03.408 Progress Backups

Hi Ned,

I love your idea about the date suffix! Simple but brilliant. Might introduce it.

In the script I posted, I didn't have the -io parameter so thanks for bringing it up. I used to have it in my live script but took it out - each backup file it stored offsite and I get a notification if any of the backups fail, so I'm happy enough that I'm covered.

Nigel.


--- In vantage@yahoogroups.com, "Ned" <TechnoBabbly@...> wrote:
>
> Nigel, I didn't see the original script you had up with your incremental in
> it, however, if you aren't using it, I would suggest making sure you add the
> -io parameter to your incremental backups, either -io 1 or -io 2 to allow
> for the potential loss of 1 or 2 of your incremental backups without totally
> hosing all your backups.
>
> -io stands for incremental overlap, the default setting for an incremental
> backup without this is 0, adding a 1 will overlap the current incremental
> along with the previous incremental, 2 does the current plus the 2 prior.
> This allows for a little tolerance in case for some reason one of your
> backups gets hosed for some unknown reason.
>
>
I was wondering if anyone is using Incremental Backups on their Progress Database and if so how did you set them up and are you using a script to run them? Any information given would be appreciated. Thanks

Robert Nupp
This is the file that runs prior to my tape backups for v.9.



REM ############## Open4 Live ###############

SET XPrgsDir=f:\epicor900\oe101c

SET XDbFile=F:\Epicor900\open4\db\o4db

SET XBackupFile=f:\backups\Open4\Open4LiveBkup.1

SET XBackupLogFile=f:\backups\Open4\Open4LiveBkupLog9.wri

Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >>
%XBackupLogFile%

Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%

SET XPrgsDir=" "

SET XDbFile=" "

SET XBackupFile=" "

SET XBackupLogFile=" "

REM ############## Open4 Test ###############

SET XPrgsDir=f:\epicor900\oe101c

SET XDbFile=F:\Epicor900\open4\db\test\o4db

SET XBackupFile=f:\backups\Open4\Open4TESTBkup.1

SET XBackupLogFile=f:\backups\Open4\Open4TESTBkupLog9.wri

Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >>
%XBackupLogFile%

Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%

SET XPrgsDir=" "

SET XDbFile=" "

SET XBackupFile=" "

SET XBackupLogFile=" "

REM ############## OB Live ###############

SET XPrgsDir=f:\epicor900\oe101c

SET XDbFile=F:\Epicor900\Epicor904\db\mfgsys

SET XBackupFile=f:\backups\Live9\OBLiveBkup9.1

SET XBackupLogFile=f:\backups\Live9\OBLiveBkupLog9.wri

Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >>
%XBackupLogFile%

Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%

SET XPrgsDir=" "

SET XDbFile=" "

SET XBackupFile=" "

SET XBackupLogFile=" "

REM ############## Test ###############

SET XPrgsDir=f:\epicor900\oe101c

SET XDbFile= F:\Epicor900\Epicor904\db\test\mfgsys

SET XBackupFile=f:\backups\test9\testBkup9.1

SET XBackupLogFile=f:\backups\test9\testBkupLog9.wri

Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >>
%XBackupLogFile%

Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%

SET XPrgsDir=" "

SET XDbFile=" "

SET XBackupFile=" "

SET XBackupLogFile=" "

REM ############## Pilot (converted) ###############

SET XPrgsDir=f:\epicor900\oe101c

SET XDbFile= F:\Epicor900\Epicor904\db\pilot\mfgsys

SET XBackupFile=f:\backups\pilot9\pilotBkup9.1

SET XBackupLogFile=f:\backups\pilot9\pilotBkupLog9.wri

Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >>
%XBackupLogFile%

Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%

SET XPrgsDir=" "

SET XDbFile=" "

SET XBackupFile=" "

SET XBackupLogFile=" "

REM ############## RB Live ###############

SET XPrgsDir=f:\epicor900\oe101c

SET XDbFile= F:\Epicor900\Epicor904\db\RBILive\mfgsys

SET XBackupFile=f:\backups\RBILive9\RBILiveBkup9.1

SET XBackupLogFile=f:\backups\RBILive9\RBILiveBkupLog9.wri

Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >>
%XBackupLogFile%

Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%

SET XPrgsDir=" "

SET XDbFile=" "

SET XBackupFile=" "

SET XBackupLogFile=" "

REM ############## RB Test (Training) ###############

SET XPrgsDir=f:\epicor900\oe101c

SET XDbFile= F:\Epicor900\Epicor904\db\training\mfgsys

SET XBackupFile=f:\backups\training\RBITrainingBkup9.1

SET XBackupLogFile=f:\backups\training\RBITrainingBkupLog9.wri

Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >>
%XBackupLogFile%

Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%

SET XPrgsDir=" "

SET XDbFile=" "

SET XBackupFile=" "

SET XBackupLogFile=" "







Thanks,



Sharon



Sharon K. Brenneman

IT Manager

Randall Bearings, Inc.

419-223-1075 Voice

419-234-3237 Mobile





[Non-text portions of this message have been removed]
Honestly, I can't see a reason for incremental backups to be used with a
Vantage System.

Even in some of the largest and most transactionally intensive Customer DBs
out there, a complete backup can be done while online and processing without
any noticable slowdown on the system.

I know it can be done, and it is scripted the same way the normal backups
are scripted, and while it would take a little research to figure out the
exact scripting, it would probably be best investigate the reasoning behind
your need or want to do an incremental instead of complete before I actually
would reccomend doing that research.



----- Original Message -----
From: "Robert" <robert.nupp@...>
To: <vantage@yahoogroups.com>
Sent: Monday, April 26, 2010 10:47 AM
Subject: [Vantage] Vantage 8.03.408 Progress Backups


>I was wondering if anyone is using Incremental Backups on their Progress
>Database and if so how did you set them up and are you using a script to
>run them? Any information given would be appreciated. Thanks
>
> Robert Nupp
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
Hi Robert,

We've started using incremental backups recently. Our DB (Progress) is 25GB. After creating the backups we then uploaded the backup file offsite. With a 25GB backup file this was taking too long so we switched to incremental.

Now we create a full backup on Saturdays and a 1.5GB incremental Sunday-Friday.

We have a different script running (under Windows Task Scheduler) on each day - necessary to create a separate incremental file for each day. Friday's script is:

@echo off
c:
Rem delete old backup file
del \\backup-server\epicor\mfgsys803\backup\mfgsys.fri

Rem create new backup
cd c:\epicor\oe101b\bin\
probkup online e:\epicor\mfgsys803\db\mfgsys incremental \\backup-server\epicor\mfgsys803\backup\mfgsys.fri


That's it. Works fine. To restore, you just run the normal PROREST on the full backup first, then run PROREST on each incremental file one after the other.

HTH,
Nigel.


--- In vantage@yahoogroups.com, "Robert" <robert.nupp@...> wrote:
>
> I was wondering if anyone is using Incremental Backups on their Progress Database and if so how did you set them up and are you using a script to run them? Any information given would be appreciated. Thanks
>
> Robert Nupp
>
Hi Nigel,

Is your Saturday script a lot different from your Sunday - Friday scripts? We are just starting out with Vantage and don't really need incremental at the moment.

Thanks,

Mike
--- In vantage@yahoogroups.com, "NigelK" <nigel.kerley@...> wrote:
>
> Hi Robert,
>
> We've started using incremental backups recently. Our DB (Progress) is 25GB. After creating the backups we then uploaded the backup file offsite. With a 25GB backup file this was taking too long so we switched to incremental.
>
> Now we create a full backup on Saturdays and a 1.5GB incremental Sunday-Friday.
>
> We have a different script running (under Windows Task Scheduler) on each day - necessary to create a separate incremental file for each day. Friday's script is:
>
> @echo off
> c:
> Rem delete old backup file
> del \\backup-server\epicor\mfgsys803\backup\mfgsys.fri
>
> Rem create new backup
> cd c:\epicor\oe101b\bin\
> probkup online e:\epicor\mfgsys803\db\mfgsys incremental \\backup-server\epicor\mfgsys803\backup\mfgsys.fri
>
>
> That's it. Works fine. To restore, you just run the normal PROREST on the full backup first, then run PROREST on each incremental file one after the other.
>
> HTH,
> Nigel.
>
>
> --- In vantage@yahoogroups.com, "Robert" <robert.nupp@> wrote:
> >
> > I was wondering if anyone is using Incremental Backups on their Progress Database and if so how did you set them up and are you using a script to run them? Any information given would be appreciated. Thanks
> >
> > Robert Nupp
> >
>
On 8/13/2010 8:56 AM, Mike wrote:
> Is your Saturday script a lot different from your Sunday - Friday scripts? We are just starting out with Vantage and don't really need incremental at the moment.
>[[ snip ]]
>> We've started using incremental backups recently. Our DB (Progress) is 25GB. After creating the backups we then uploaded the backup file offsite. With a 25GB backup file this was taking too long so we switched to incremental.

Hey Guys... does the probkup process have any file compression
capability? You could probably compress the files enough to make the
off site upload a good bit quicker.

7-Zip has a command line interface you can write into scripts:
http://www.7-zip.org/

-Wayne
Mike: here's my Saturday script:

@echo off
c:
del \\backup-server\epicor\mfgsys803\backup\mfgsys.full
cd c:\epicor\oe101b\bin\
probkup online c:\epicor\mfgsys803\db\mfgsys \\backup-server\epicor\mfgsys803\backup\mfgsys.full

The only differences are the word "incremental" and the fact that I'm backing up to a different filename.


Wayne: yes, you can add "-com" at the end of the probkup line to switch on compression, but the difference in file size is very small.

I have used 7-zip before to compress our DB before uploading to Epicor and that worked very well. Epicor have never had a problem with the uncompressed/restored DB.


Nigel.



--- In vantage@yahoogroups.com, wayne <wmc20@...> wrote:
>
> On 8/13/2010 8:56 AM, Mike wrote:
> > Is your Saturday script a lot different from your Sunday - Friday scripts? We are just starting out with Vantage and don't really need incremental at the moment.
> >[[ snip ]]
> >> We've started using incremental backups recently. Our DB (Progress) is 25GB. After creating the backups we then uploaded the backup file offsite. With a 25GB backup file this was taking too long so we switched to incremental.
>
> Hey Guys... does the probkup process have any file compression
> capability? You could probably compress the files enough to make the
> off site upload a good bit quicker.
>
> 7-Zip has a command line interface you can write into scripts:
> http://www.7-zip.org/
>
> -Wayne
>
Personally, I have added this line after the @echo off line in my backup
scripts for progress.

set tDate=%date:~12,2%%date:~4,2%%date:~7,2%

The date format is setup as YYMMDD so then for my file name I use
mfgsyslive.%tDate% and end up with something like this for last night's
backup

mfgsyslive.100818

This allows me to keep multiple daily backups automatically instead of
writing over the one from the day before every time. I then keep the backup
folder clean with an altered version of the vbscript that was used to keep
the mfgsyswrk folder clean by deleting backups older than 7 days.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
NigelK
Sent: Thursday, August 19, 2010 5:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03.408 Progress Backups

Mike: here's my Saturday script:

@echo off
c:
del \\backup-server\epicor\mfgsys803\backup\mfgsys.full
cd c:\epicor\oe101b\bin\
probkup online c:\epicor\mfgsys803\db\mfgsys
\\backup-server\epicor\mfgsys803\backup\mfgsys.full

The only differences are the word "incremental" and the fact that I'm
backing up to a different filename.


Wayne: yes, you can add "-com" at the end of the probkup line to switch on
compression, but the difference in file size is very small.

I have used 7-zip before to compress our DB before uploading to Epicor and
that worked very well. Epicor have never had a problem with the
uncompressed/restored DB.


Nigel.



--- In vantage@yahoogroups.com, wayne <wmc20@...> wrote:
>
> On 8/13/2010 8:56 AM, Mike wrote:
> > Is your Saturday script a lot different from your Sunday - Friday
scripts? We are just starting out with Vantage and don't really need
incremental at the moment.
> >[[ snip ]]
> >> We've started using incremental backups recently. Our DB (Progress) is
25GB. After creating the backups we then uploaded the backup file offsite.
With a 25GB backup file this was taking too long so we switched to
incremental.
>
> Hey Guys... does the probkup process have any file compression
> capability? You could probably compress the files enough to make the
> off site upload a good bit quicker.
>
> 7-Zip has a command line interface you can write into scripts:
> http://www.7-zip.org/
>
> -Wayne
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Nigel, I didn't see the original script you had up with your incremental in
it, however, if you aren't using it, I would suggest making sure you add the
-io parameter to your incremental backups, either -io 1 or -io 2 to allow
for the potential loss of 1 or 2 of your incremental backups without totally
hosing all your backups.

-io stands for incremental overlap, the default setting for an incremental
backup without this is 0, adding a 1 will overlap the current incremental
along with the previous incremental, 2 does the current plus the 2 prior.
This allows for a little tolerance in case for some reason one of your
backups gets hosed for some unknown reason.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
NigelK
Sent: Thursday, August 19, 2010 5:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03.408 Progress Backups

Mike: here's my Saturday script:

@echo off
c:
del \\backup-server\epicor\mfgsys803\backup\mfgsys.full
cd c:\epicor\oe101b\bin\
probkup online c:\epicor\mfgsys803\db\mfgsys
\\backup-server\epicor\mfgsys803\backup\mfgsys.full

The only differences are the word "incremental" and the fact that I'm
backing up to a different filename.


Wayne: yes, you can add "-com" at the end of the probkup line to switch on
compression, but the difference in file size is very small.

I have used 7-zip before to compress our DB before uploading to Epicor and
that worked very well. Epicor have never had a problem with the
uncompressed/restored DB.


Nigel.



--- In vantage@yahoogroups.com, wayne <wmc20@...> wrote:
>
> On 8/13/2010 8:56 AM, Mike wrote:
> > Is your Saturday script a lot different from your Sunday - Friday
scripts? We are just starting out with Vantage and don't really need
incremental at the moment.
> >[[ snip ]]
> >> We've started using incremental backups recently. Our DB (Progress) is
25GB. After creating the backups we then uploaded the backup file offsite.
With a 25GB backup file this was taking too long so we switched to
incremental.
>
> Hey Guys... does the probkup process have any file compression
> capability? You could probably compress the files enough to make the
> off site upload a good bit quicker.
>
> 7-Zip has a command line interface you can write into scripts:
> http://www.7-zip.org/
>
> -Wayne
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links