Database Backups E9

[system]

Ah do you mean backups using a backup software?

You need to backup Epicor db etc first, then back that backed up file up (but exclude several folders from the main backup - one being the DB folder - it stuggles backing up a moving target).



________________________________
From: Kirstin Brandt <kirstin.brandt@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 16 May 2012, 21:49
Subject: [Vantage] Re: Database Backups E9


Â
Do you exclude your \db directory when you do your full backups?

--- In vantage@yahoogroups.com, "r.morton03" <r.morton03@...> wrote:
>
> So, we backup the whole server every night. The online method of Epicor progress files only is what freezes the app server. We can't do it offline because our shop is running 3 shifts, 24/7/365, and are always going in and out.
>
> So, does anyone know what the DB Replication is? Found it in the Epicor Admin Console... heh
>
> --- In vantage@yahoogroups.com, "tracy.tmat" <tracy.smith@> wrote:
> >
> > We work the same as Chris... our online backup runs a couple of times a day and our offline runs on a Sunday afternoon.
> >
> >
> >
> > --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> > >
> > > We have an ONLINE and OFFLINE backup.
> > >
> > > The Online one can be ran at any time without shutting down the APPS or DB.
> > >
> > > The Offline one shuts down the APPS and DB.
> > >
> > >
> > >
> > > ________________________________
> > > From: r.morton03 <r.morton03@>
> > > To: vantage@yahoogroups.com
> > > Sent: Monday, 14 May 2012, 14:38
> > > Subject: [Vantage] Re: Database Backups E9
> > >
> > >
> > > ÂÂ
> > > Hi Chris,
> > >
> > > Shutting down the app servers. IS that standard operating procedure? We can't isolate the error, it happens whenever it wants.
> > >
> > > Thanks
> > >
> > > --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> > > >
> > > > I dont fully understand what you are asking here.
> > > >
> > > > Are your backups taking too long or is it just because it is shutting your app servers?
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > From: r.morton03 <r.morton03@>
> > > > To: vantage@yahoogroups.com
> > > > Sent: Monday, 14 May 2012, 13:49
> > > > Subject: [Vantage] Database Backups E9
> > > >
> > > >
> > > > ÂÂÂ
> > > > This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:
> > > >
> > > > @echo off
> > > >
> > > > Rem This is a batch file to backup your Progress 10.1c database
> > > > Rem You will need one of these files for each database you want to backup
> > > > Rem You will need to edit the SET statements for your installation
> > > > Rem Do not edit anything other than the SET statements
> > > >
> > > > Rem Edit below -----------------------------------------------
> > > >
> > > > Rem set your Progress directory, using only the physical path
> > > > SET XPrgsDir=d:\epicor\oe101c
> > > >
> > > > Rem set your Database file, using only the physical path
> > > > SET XDbFile=d:\epicor904\db\mfgsys
> > > >
> > > > Rem set your backup file and backup log file, using only a physical path
> > > > SET XBackupFile=d:\backups\Live\LiveBkup.2
> > > > SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri
> > > >
> > > > Rem Do Not edit below -----------------------------------------
> > > >
> > > > Rem Run backup
> > > >
> > > > Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%
> > > >
> > > > Rem Run verification of backup
> > > >
> > > > Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%
> > > >
> > > > Rem blank the variables out, since we are finished with them
> > > >
> > > > SET XPrgsDir=""
> > > > SET XDbFile=""
> > > > SET XBackupFile=""
> > > > SET XBackupLogFile=""
> > > >
> > > > We found that if we backup the files only once a night, it works just fine, rather than the whole db.
> > > >
> > > > Anyone have any similar experiences? Suggestions?
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>




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

[system]

This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:

@echo off

Rem This is a batch file to backup your Progress 10.1c database
Rem You will need one of these files for each database you want to backup
Rem You will need to edit the SET statements for your installation
Rem Do not edit anything other than the SET statements

Rem Edit below -----------------------------------------------

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

Rem set your Database file, using only the physical path
SET XDbFile=d:\epicor904\db\mfgsys

Rem set your backup file and backup log file, using only a physical path
SET XBackupFile=d:\backups\Live\LiveBkup.2
SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri

Rem Do Not edit below -----------------------------------------

Rem Run backup

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

Rem Run verification of backup

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


Rem blank the variables out, since we are finished with them

SET XPrgsDir=""
SET XDbFile=""
SET XBackupFile=""
SET XBackupLogFile=""

We found that if we backup the files only once a night, it works just fine, rather than the whole db.

Anyone have any similar experiences? Suggestions?

[system]

I dont fully understand what you are asking here.

Are your backups taking too long or is it just because it is shutting your app servers?

Thanks.



________________________________
From: r.morton03 <r.morton03@...>
To: vantage@yahoogroups.com
Sent: Monday, 14 May 2012, 13:49
Subject: [Vantage] Database Backups E9


Â
This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:

@echo off

Rem This is a batch file to backup your Progress 10.1c database
Rem You will need one of these files for each database you want to backup
Rem You will need to edit the SET statements for your installation
Rem Do not edit anything other than the SET statements

Rem Edit below -----------------------------------------------

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

Rem set your Database file, using only the physical path
SET XDbFile=d:\epicor904\db\mfgsys

Rem set your backup file and backup log file, using only a physical path
SET XBackupFile=d:\backups\Live\LiveBkup.2
SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri

Rem Do Not edit below -----------------------------------------

Rem Run backup

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

Rem Run verification of backup

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

Rem blank the variables out, since we are finished with them

SET XPrgsDir=""
SET XDbFile=""
SET XBackupFile=""
SET XBackupLogFile=""

We found that if we backup the files only once a night, it works just fine, rather than the whole db.

Anyone have any similar experiences? Suggestions?




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

[system]

Hi Chris,

Shutting down the app servers. IS that standard operating procedure? We can't isolate the error, it happens whenever it wants.

Thanks

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> I dont fully understand what you are asking here.
>
> Are your backups taking too long or is it just because it is shutting your app servers?
>
> Thanks.
>
>
>
> ________________________________
> From: r.morton03 <r.morton03@...>
> To: vantage@yahoogroups.com
> Sent: Monday, 14 May 2012, 13:49
> Subject: [Vantage] Database Backups E9
>
>
> ÂÂ
> This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:
>
> @echo off
>
> Rem This is a batch file to backup your Progress 10.1c database
> Rem You will need one of these files for each database you want to backup
> Rem You will need to edit the SET statements for your installation
> Rem Do not edit anything other than the SET statements
>
> Rem Edit below -----------------------------------------------
>
> Rem set your Progress directory, using only the physical path
> SET XPrgsDir=d:\epicor\oe101c
>
> Rem set your Database file, using only the physical path
> SET XDbFile=d:\epicor904\db\mfgsys
>
> Rem set your backup file and backup log file, using only a physical path
> SET XBackupFile=d:\backups\Live\LiveBkup.2
> SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri
>
> Rem Do Not edit below -----------------------------------------
>
> Rem Run backup
>
> Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%
>
> Rem Run verification of backup
>
> Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%
>
> Rem blank the variables out, since we are finished with them
>
> SET XPrgsDir=""
> SET XDbFile=""
> SET XBackupFile=""
> SET XBackupLogFile=""
>
> We found that if we backup the files only once a night, it works just fine, rather than the whole db.
>
> Anyone have any similar experiences? Suggestions?
>
>
>
>
> [Non-text portions of this message have been removed]
>

[system]

That's definitely not SOPÂ…. It shouldn't be shutting down your appservers.



When you say, "We found that if we backup the files only once a night, it
works just fine, rather than the whole db."



Can you clarify?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
r.morton03
Sent: Monday, May 14, 2012 9:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Database Backups E9





Hi Chris,

Shutting down the app servers. IS that standard operating procedure? We
can't isolate the error, it happens whenever it wants.

Thanks

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Chris
Thompson <chriselectrix@...> wrote:

>
> I dont fully understand what you are asking here.
>
> Are your backups taking too long or is it just because it is shutting your

app servers?

>
> Thanks.
>
>
>
> ________________________________
> From: r.morton03 <r.morton03@...>
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Sent: Monday, 14 May 2012, 13:49
> Subject: [Vantage] Database Backups E9
>
>
> Â
> This is a little above my knowledge level, but what is happening is we

have issues with backing up the database, it shuts down the app servers.
Here is the script:

>
> @echo off
>
> Rem This is a batch file to backup your Progress 10.1c database
> Rem You will need one of these files for each database you want to backup
> Rem You will need to edit the SET statements for your installation
> Rem Do not edit anything other than the SET statements
>
> Rem Edit below -----------------------------------------------
>
> Rem set your Progress directory, using only the physical path
> SET XPrgsDir=d:\epicor\oe101c
>
> Rem set your Database file, using only the physical path
> SET XDbFile=d:\epicor904\db\mfgsys
>
> Rem set your backup file and backup log file, using only a physical path
> SET XBackupFile=d:\backups\Live\LiveBkup.2
> SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri
>
> Rem Do Not edit below -----------------------------------------
>
> Rem Run backup
>
> Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >>

%XBackupLogFile%

>
> Rem Run verification of backup
>
> Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >>

%XBackupLogFile%

>
> Rem blank the variables out, since we are finished with them
>
> SET XPrgsDir=""
> SET XDbFile=""
> SET XBackupFile=""
> SET XBackupLogFile=""
>
> We found that if we backup the files only once a night, it works just

fine, rather than the whole db.

>
> Anyone have any similar experiences? Suggestions?
>
>
>
>
> [Non-text portions of this message have been removed]
>

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2171 / Virus Database: 2425/4998 - Release Date: 05/14/12



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

[system]

>We found that if we backup the files only once a night,
>just fine, rather than the whole db.

I have never seen the backup bat file stop the appservers.

I vaguely remember a problem once when some backup software was first installed.
I think it locked a file and appserver issues.

We run the batch file to create the backup files.
Use the backup software to backup those backup files - not anything in the database directory.

--- In vantage@yahoogroups.com, "r.morton03" <r.morton03@...> wrote:
>
> This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:
>
> @echo off
>
> Rem This is a batch file to backup your Progress 10.1c database
> Rem You will need one of these files for each database you want to backup
> Rem You will need to edit the SET statements for your installation
> Rem Do not edit anything other than the SET statements
>
> Rem Edit below -----------------------------------------------
>
> Rem set your Progress directory, using only the physical path
> SET XPrgsDir=d:\epicor\oe101c
>
> Rem set your Database file, using only the physical path
> SET XDbFile=d:\epicor904\db\mfgsys
>
> Rem set your backup file and backup log file, using only a physical path
> SET XBackupFile=d:\backups\Live\LiveBkup.2
> SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri
>
> Rem Do Not edit below -----------------------------------------
>
> Rem Run backup
>
> Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%
>
> Rem Run verification of backup
>
> Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%
>
>
> Rem blank the variables out, since we are finished with them
>
> SET XPrgsDir=""
> SET XDbFile=""
> SET XBackupFile=""
> SET XBackupLogFile=""
>
> We found that if we backup the files only once a night, it works just fine, rather than the whole db.
>
> Anyone have any similar experiences? Suggestions?
>

[system]

We have an ONLINE and OFFLINE backup.

The Online one can be ran at any time without shutting down the APPS or DB.

The Offline one shuts down the APPS and DB.



________________________________
From: r.morton03 <r.morton03@...>
To: vantage@yahoogroups.com
Sent: Monday, 14 May 2012, 14:38
Subject: [Vantage] Re: Database Backups E9


Â
Hi Chris,

Shutting down the app servers. IS that standard operating procedure? We can't isolate the error, it happens whenever it wants.

Thanks

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> I dont fully understand what you are asking here.
>
> Are your backups taking too long or is it just because it is shutting your app servers?
>
> Thanks.
>
>
>
> ________________________________
> From: r.morton03 <r.morton03@...>
> To: vantage@yahoogroups.com
> Sent: Monday, 14 May 2012, 13:49
> Subject: [Vantage] Database Backups E9
>
>
> ÂÂ
> This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:
>
> @echo off
>
> Rem This is a batch file to backup your Progress 10.1c database
> Rem You will need one of these files for each database you want to backup
> Rem You will need to edit the SET statements for your installation
> Rem Do not edit anything other than the SET statements
>
> Rem Edit below -----------------------------------------------
>
> Rem set your Progress directory, using only the physical path
> SET XPrgsDir=d:\epicor\oe101c
>
> Rem set your Database file, using only the physical path
> SET XDbFile=d:\epicor904\db\mfgsys
>
> Rem set your backup file and backup log file, using only a physical path
> SET XBackupFile=d:\backups\Live\LiveBkup.2
> SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri
>
> Rem Do Not edit below -----------------------------------------
>
> Rem Run backup
>
> Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%
>
> Rem Run verification of backup
>
> Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%
>
> Rem blank the variables out, since we are finished with them
>
> SET XPrgsDir=""
> SET XDbFile=""
> SET XBackupFile=""
> SET XBackupLogFile=""
>
> We found that if we backup the files only once a night, it works just fine, rather than the whole db.
>
> Anyone have any similar experiences? Suggestions?
>
>
>
>
> [Non-text portions of this message have been removed]
>




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

[system]

We work the same as Chris... our online backup runs a couple of times a day and our offline runs on a Sunday afternoon.

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> We have an ONLINE and OFFLINE backup.
>
> The Online one can be ran at any time without shutting down the APPS or DB.
>
> The Offline one shuts down the APPS and DB.
>
>
>
> ________________________________
> From: r.morton03 <r.morton03@...>
> To: vantage@yahoogroups.com
> Sent: Monday, 14 May 2012, 14:38
> Subject: [Vantage] Re: Database Backups E9
>
>
> ÂÂ
> Hi Chris,
>
> Shutting down the app servers. IS that standard operating procedure? We can't isolate the error, it happens whenever it wants.
>
> Thanks
>
> --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> >
> > I dont fully understand what you are asking here.
> >
> > Are your backups taking too long or is it just because it is shutting your app servers?
> >
> > Thanks.
> >
> >
> >
> > ________________________________
> > From: r.morton03 <r.morton03@>
> > To: vantage@yahoogroups.com
> > Sent: Monday, 14 May 2012, 13:49
> > Subject: [Vantage] Database Backups E9
> >
> >
> > ÂÂÂ
> > This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:
> >
> > @echo off
> >
> > Rem This is a batch file to backup your Progress 10.1c database
> > Rem You will need one of these files for each database you want to backup
> > Rem You will need to edit the SET statements for your installation
> > Rem Do not edit anything other than the SET statements
> >
> > Rem Edit below -----------------------------------------------
> >
> > Rem set your Progress directory, using only the physical path
> > SET XPrgsDir=d:\epicor\oe101c
> >
> > Rem set your Database file, using only the physical path
> > SET XDbFile=d:\epicor904\db\mfgsys
> >
> > Rem set your backup file and backup log file, using only a physical path
> > SET XBackupFile=d:\backups\Live\LiveBkup.2
> > SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri
> >
> > Rem Do Not edit below -----------------------------------------
> >
> > Rem Run backup
> >
> > Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%
> >
> > Rem Run verification of backup
> >
> > Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%
> >
> > Rem blank the variables out, since we are finished with them
> >
> > SET XPrgsDir=""
> > SET XDbFile=""
> > SET XBackupFile=""
> > SET XBackupLogFile=""
> >
> > We found that if we backup the files only once a night, it works just fine, rather than the whole db.
> >
> > Anyone have any similar experiences? Suggestions?
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>

[system]

So, we backup the whole server every night. The online method of Epicor progress files only is what freezes the app server. We can't do it offline because our shop is running 3 shifts, 24/7/365, and are always going in and out.

So, does anyone know what the DB Replication is? Found it in the Epicor Admin Console... heh

--- In vantage@yahoogroups.com, "tracy.tmat" <tracy.smith@...> wrote:
>
> We work the same as Chris... our online backup runs a couple of times a day and our offline runs on a Sunday afternoon.
>
>
>
> --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> >
> > We have an ONLINE and OFFLINE backup.
> >
> > The Online one can be ran at any time without shutting down the APPS or DB.
> >
> > The Offline one shuts down the APPS and DB.
> >
> >
> >
> > ________________________________
> > From: r.morton03 <r.morton03@>
> > To: vantage@yahoogroups.com
> > Sent: Monday, 14 May 2012, 14:38
> > Subject: [Vantage] Re: Database Backups E9
> >
> >
> > ÂÂ
> > Hi Chris,
> >
> > Shutting down the app servers. IS that standard operating procedure? We can't isolate the error, it happens whenever it wants.
> >
> > Thanks
> >
> > --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> > >
> > > I dont fully understand what you are asking here.
> > >
> > > Are your backups taking too long or is it just because it is shutting your app servers?
> > >
> > > Thanks.
> > >
> > >
> > >
> > > ________________________________
> > > From: r.morton03 <r.morton03@>
> > > To: vantage@yahoogroups.com
> > > Sent: Monday, 14 May 2012, 13:49
> > > Subject: [Vantage] Database Backups E9
> > >
> > >
> > > ÂÂÂ
> > > This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:
> > >
> > > @echo off
> > >
> > > Rem This is a batch file to backup your Progress 10.1c database
> > > Rem You will need one of these files for each database you want to backup
> > > Rem You will need to edit the SET statements for your installation
> > > Rem Do not edit anything other than the SET statements
> > >
> > > Rem Edit below -----------------------------------------------
> > >
> > > Rem set your Progress directory, using only the physical path
> > > SET XPrgsDir=d:\epicor\oe101c
> > >
> > > Rem set your Database file, using only the physical path
> > > SET XDbFile=d:\epicor904\db\mfgsys
> > >
> > > Rem set your backup file and backup log file, using only a physical path
> > > SET XBackupFile=d:\backups\Live\LiveBkup.2
> > > SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri
> > >
> > > Rem Do Not edit below -----------------------------------------
> > >
> > > Rem Run backup
> > >
> > > Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%
> > >
> > > Rem Run verification of backup
> > >
> > > Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%
> > >
> > > Rem blank the variables out, since we are finished with them
> > >
> > > SET XPrgsDir=""
> > > SET XDbFile=""
> > > SET XBackupFile=""
> > > SET XBackupLogFile=""
> > >
> > > We found that if we backup the files only once a night, it works just fine, rather than the whole db.
> > >
> > > Anyone have any similar experiences? Suggestions?
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

[system]

Mostly data cubes for reporting functions

Rob Bucek
Production Control Manager
D&S Manafacturing
M: (715) 896-0590<tel:7158960590>
P: (715) 896-0590<tel:7158960590>

Sent from my Verizon Wireless Droid


-----Original message-----
From: "r.morton03" <r.morton03@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wed, May 16, 2012 17:25:41 GMT+00:00
Subject: [Vantage] Re: Database Backups E9



So, we backup the whole server every night. The online method of Epicor progress files only is what freezes the app server. We can't do it offline because our shop is running 3 shifts, 24/7/365, and are always going in and out.

So, does anyone know what the DB Replication is? Found it in the Epicor Admin Console... heh

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "tracy.tmat" <tracy.smith@...> wrote:
>
> We work the same as Chris... our online backup runs a couple of times a day and our offline runs on a Sunday afternoon.
>
>
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Chris Thompson <chriselectrix@> wrote:
> >
> > We have an ONLINE and OFFLINE backup.
> >
> > The Online one can be ran at any time without shutting down the APPS or DB.
> >
> > The Offline one shuts down the APPS and DB.
> >
> >
> >
> > ________________________________
> > From: r.morton03 <r.morton03@>
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Sent: Monday, 14 May 2012, 14:38
> > Subject: [Vantage] Re: Database Backups E9
> >
> >
> > Â
> > Hi Chris,
> >
> > Shutting down the app servers. IS that standard operating procedure? We can't isolate the error, it happens whenever it wants.
> >
> > Thanks
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Chris Thompson <chriselectrix@> wrote:
> > >
> > > I dont fully understand what you are asking here.
> > >
> > > Are your backups taking too long or is it just because it is shutting your app servers?
> > >
> > > Thanks.
> > >
> > >
> > >
> > > ________________________________
> > > From: r.morton03 <r.morton03@>
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > Sent: Monday, 14 May 2012, 13:49
> > > Subject: [Vantage] Database Backups E9
> > >
> > >
> > > ÂÂ
> > > This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:
> > >
> > > @echo off
> > >
> > > Rem This is a batch file to backup your Progress 10.1c database
> > > Rem You will need one of these files for each database you want to backup
> > > Rem You will need to edit the SET statements for your installation
> > > Rem Do not edit anything other than the SET statements
> > >
> > > Rem Edit below -----------------------------------------------
> > >
> > > Rem set your Progress directory, using only the physical path
> > > SET XPrgsDir=d:\epicor\oe101c
> > >
> > > Rem set your Database file, using only the physical path
> > > SET XDbFile=d:\epicor904\db\mfgsys
> > >
> > > Rem set your backup file and backup log file, using only a physical path
> > > SET XBackupFile=d:\backups\Live\LiveBkup.2
> > > SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri
> > >
> > > Rem Do Not edit below -----------------------------------------
> > >
> > > Rem Run backup
> > >
> > > Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%
> > >
> > > Rem Run verification of backup
> > >
> > > Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%
> > >
> > > Rem blank the variables out, since we are finished with them
> > >
> > > SET XPrgsDir=""
> > > SET XDbFile=""
> > > SET XBackupFile=""
> > > SET XBackupLogFile=""
> > >
> > > We found that if we backup the files only once a night, it works just fine, rather than the whole db.
> > >
> > > Anyone have any similar experiences? Suggestions?
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>



Reply to sender<mailto:r.morton03@...?subject=Re%3A%20Database%20Backups%20E9> | Reply to group<mailto:vantage@yahoogroups.com?subject=Re%3A%20Database%20Backups%20E9> | Reply via web post<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwaTkzbjBzBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMTAyMzkEc2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMzM3MTg5MTM4?act=reply&messageNum=110239> | Start a New Topic<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjM2RwYzRsBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNudHBjBHN0aW1lAzEzMzcxODkxMzg->
Messages in this topic<http://groups.yahoo.com/group/vantage/message/110035;_ylc=X3oDMTM2NTB2a2RvBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMTAyMzkEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzM3MTg5MTM4BHRwY0lkAzExMDAzNQ--> (8)
Recent Activity:

Visit Your Group<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjc28xZTNyBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzEzMzcxODkxMzg->
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: <a href="http:


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

[system]

Do you exclude your \db directory when you do your full backups?

--- In vantage@yahoogroups.com, "r.morton03" <r.morton03@...> wrote:
>
> So, we backup the whole server every night. The online method of Epicor progress files only is what freezes the app server. We can't do it offline because our shop is running 3 shifts, 24/7/365, and are always going in and out.
>
> So, does anyone know what the DB Replication is? Found it in the Epicor Admin Console... heh
>
> --- In vantage@yahoogroups.com, "tracy.tmat" <tracy.smith@> wrote:
> >
> > We work the same as Chris... our online backup runs a couple of times a day and our offline runs on a Sunday afternoon.
> >
> >
> >
> > --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> > >
> > > We have an ONLINE and OFFLINE backup.
> > >
> > > The Online one can be ran at any time without shutting down the APPS or DB.
> > >
> > > The Offline one shuts down the APPS and DB.
> > >
> > >
> > >
> > > ________________________________
> > > From: r.morton03 <r.morton03@>
> > > To: vantage@yahoogroups.com
> > > Sent: Monday, 14 May 2012, 14:38
> > > Subject: [Vantage] Re: Database Backups E9
> > >
> > >
> > > ÂÂ
> > > Hi Chris,
> > >
> > > Shutting down the app servers. IS that standard operating procedure? We can't isolate the error, it happens whenever it wants.
> > >
> > > Thanks
> > >
> > > --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> > > >
> > > > I dont fully understand what you are asking here.
> > > >
> > > > Are your backups taking too long or is it just because it is shutting your app servers?
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > From: r.morton03 <r.morton03@>
> > > > To: vantage@yahoogroups.com
> > > > Sent: Monday, 14 May 2012, 13:49
> > > > Subject: [Vantage] Database Backups E9
> > > >
> > > >
> > > > ÂÂÂ
> > > > This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:
> > > >
> > > > @echo off
> > > >
> > > > Rem This is a batch file to backup your Progress 10.1c database
> > > > Rem You will need one of these files for each database you want to backup
> > > > Rem You will need to edit the SET statements for your installation
> > > > Rem Do not edit anything other than the SET statements
> > > >
> > > > Rem Edit below -----------------------------------------------
> > > >
> > > > Rem set your Progress directory, using only the physical path
> > > > SET XPrgsDir=d:\epicor\oe101c
> > > >
> > > > Rem set your Database file, using only the physical path
> > > > SET XDbFile=d:\epicor904\db\mfgsys
> > > >
> > > > Rem set your backup file and backup log file, using only a physical path
> > > > SET XBackupFile=d:\backups\Live\LiveBkup.2
> > > > SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri
> > > >
> > > > Rem Do Not edit below -----------------------------------------
> > > >
> > > > Rem Run backup
> > > >
> > > > Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%
> > > >
> > > > Rem Run verification of backup
> > > >
> > > > Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%
> > > >
> > > > Rem blank the variables out, since we are finished with them
> > > >
> > > > SET XPrgsDir=""
> > > > SET XDbFile=""
> > > > SET XBackupFile=""
> > > > SET XBackupLogFile=""
> > > >
> > > > We found that if we backup the files only once a night, it works just fine, rather than the whole db.
> > > >
> > > > Anyone have any similar experiences? Suggestions?
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>

[system]

Or online backup script looks different to the one that was posted - we backup each day to a different folder (so the files dont get overwritten) - we then have an email that fires to tell us it has finished.

Here is ours ....

echo Running Epicor live ONLINE Backup...
@echo off
e:\epicor904\oe101c\bin\_mprshut e:\epicor904\db\mfgsys -C backup online e:\epicor904\backed_up_files\live\Friday\live_online_backup_fri.1 %4 %5 %6 %7 %8 %9 >> e:\epicor904\backed_up_files\live\Friday\live_online_backup_fri.Wri
echo Running Verify...
@echo off

e:\epicor904\oe101c\bin\_dbutil prorest e:\epicor904\db\mfgsys e:\epicor904\backed_up_files\live\Friday\live_online_backup_fri.1 -vp >> e:\epicor904\backed_up_files\live\Friday\live_online_verify_fri.wri

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@companydomain^> > %tempmail%
echo From: "Backup Programme" ^<no-reply@companydomain^> >> %tempmail%
echo Subject: Friday - Epicor 9 Live Online Backup >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo The Friday backup for Epicor 9 (Live) Online backup has taken place.>> %tempmail%
echo Please check the 'backup' and 'verify' documents (using Wordpad) for any errors - \\server\epicor904\backed_up_files\live\Friday.>> %tempmail%
echo If there are any errors present, please consult with the other Backup Users.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal


This works no problem for us.



________________________________
From: r.morton03 <r.morton03@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 16 May 2012, 18:25
Subject: [Vantage] Re: Database Backups E9


Â
So, we backup the whole server every night. The online method of Epicor progress files only is what freezes the app server. We can't do it offline because our shop is running 3 shifts, 24/7/365, and are always going in and out.

So, does anyone know what the DB Replication is? Found it in the Epicor Admin Console... heh

--- In vantage@yahoogroups.com, "tracy.tmat" <tracy.smith@...> wrote:
>
> We work the same as Chris... our online backup runs a couple of times a day and our offline runs on a Sunday afternoon.
>
>
>
> --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> >
> > We have an ONLINE and OFFLINE backup.
> >
> > The Online one can be ran at any time without shutting down the APPS or DB.
> >
> > The Offline one shuts down the APPS and DB.
> >
> >
> >
> > ________________________________
> > From: r.morton03 <r.morton03@>
> > To: vantage@yahoogroups.com
> > Sent: Monday, 14 May 2012, 14:38
> > Subject: [Vantage] Re: Database Backups E9
> >
> >
> > ÂÂ
> > Hi Chris,
> >
> > Shutting down the app servers. IS that standard operating procedure? We can't isolate the error, it happens whenever it wants.
> >
> > Thanks
> >
> > --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> > >
> > > I dont fully understand what you are asking here.
> > >
> > > Are your backups taking too long or is it just because it is shutting your app servers?
> > >
> > > Thanks.
> > >
> > >
> > >
> > > ________________________________
> > > From: r.morton03 <r.morton03@>
> > > To: vantage@yahoogroups.com
> > > Sent: Monday, 14 May 2012, 13:49
> > > Subject: [Vantage] Database Backups E9
> > >
> > >
> > > ÂÂÂ
> > > This is a little above my knowledge level, but what is happening is we have issues with backing up the database, it shuts down the app servers. Here is the script:
> > >
> > > @echo off
> > >
> > > Rem This is a batch file to backup your Progress 10.1c database
> > > Rem You will need one of these files for each database you want to backup
> > > Rem You will need to edit the SET statements for your installation
> > > Rem Do not edit anything other than the SET statements
> > >
> > > Rem Edit below -----------------------------------------------
> > >
> > > Rem set your Progress directory, using only the physical path
> > > SET XPrgsDir=d:\epicor\oe101c
> > >
> > > Rem set your Database file, using only the physical path
> > > SET XDbFile=d:\epicor904\db\mfgsys
> > >
> > > Rem set your backup file and backup log file, using only a physical path
> > > SET XBackupFile=d:\backups\Live\LiveBkup.2
> > > SET XBackupLogFile=d:\backups\Live\LiveBkupLog2.wri
> > >
> > > Rem Do Not edit below -----------------------------------------
> > >
> > > Rem Run backup
> > >
> > > Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%
> > >
> > > Rem Run verification of backup
> > >
> > > Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%
> > >
> > > Rem blank the variables out, since we are finished with them
> > >
> > > SET XPrgsDir=""
> > > SET XDbFile=""
> > > SET XBackupFile=""
> > > SET XBackupLogFile=""
> > >
> > > We found that if we backup the files only once a night, it works just fine, rather than the whole db.
> > >
> > > Anyone have any similar experiences? Suggestions?
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>




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