After you backup script add the following :
@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" ^<emailaddress@...^> > %tempmail%
echo From: "Backup Programme" ^<from@...^> >> %tempmail%
echo Subject: Enter your subject here >> %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 Wednesday 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\Wednesday.>> %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 doesnt tell you in the email if it was successful or not, but because it is
at the end of the backup batch file, I think it will only run once the backup is
complete. There is a way that you include the results in the email which would
mean it can be checked easily off-site.
You need to be backing up a minimum or every day if not multiple times during
the day.
This is our full backup script for a Wednesday ...
@echo off
rem Epicor BACKMFG.BAT createc:07/98 JE - editec: 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 NOTh:
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 oe100b\BIN\MFGBKUP.BAT is located.
rem b) Verify path to Mfgsys60\oe100b\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, oe100b\Bin, scripts, etc.)
echo Running Epicor Vantage live ONLINE Backup...
@echo off
e:\epicor904\oe101c\bin\_mprshut e:\epicor904\db\mfgsys -C backup online
e:\epicor904\backed_up_files\live\Wednesday\live_online_backup_wed.1 %4 %5 %6 %7
%8 %9 >> e:\epicor904\backed_up_files\live\Wednesday\live_online_backup_wed.Wri
echo Running Verify...
@echo off
e:\epicor904\oe101c\bin\_dbutil prorest e:\epicor904\db\mfgsys
e:\epicor904\backed_up_files\live\Wednesday\live_online_backup_wed.1 -vp >>
e:\epicor904\backed_up_files\live\Wednesday\live_online_verify_wed.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" ^<emailaddress@...^> > %tempmail%
echo From: "Backup Programme" ^<from@...^> >> %tempmail%
echo Subject: Wednesday - 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 Wednesday 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\Wednesday.>> %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 takes a backup of the live DB and puts the backup in a folder for Wednesday
which is overwritten every week. We have one of these for Monday to Friday and
also have Thursday 1, 2, 3, 4.
By having Thursday 1-4 you are able to revert to 4 weeks ago data if necessary
and you can also revert to each day up to a week ago.
Every day this server is backed up (excluding the DB folder etc) and restored on
an identical server in an completely isolated location. We then verify that the
data that has been backed up is the correct data by running some offline restore
scripts on the disaster recovery server.
We then also take a tape off-site containing the data.
Dont fall into the trap of never testing (or rarely testing) your backups. Test
them daily and it will remove the worry of 'what if'. It will also reduce your
insurance premium a little.
________________________________
From: Ephraim Feldman <effgroups@...>
To: vantage@yahoogroups.com
Sent: Thu, 21 October, 2010 22:02:03
Subject: Re: [Vantage] Email on successful Backup
Probkup does that already but the problem i have is the automatic email how
to do
Ephraim
@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" ^<emailaddress@...^> > %tempmail%
echo From: "Backup Programme" ^<from@...^> >> %tempmail%
echo Subject: Enter your subject here >> %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 Wednesday 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\Wednesday.>> %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 doesnt tell you in the email if it was successful or not, but because it is
at the end of the backup batch file, I think it will only run once the backup is
complete. There is a way that you include the results in the email which would
mean it can be checked easily off-site.
You need to be backing up a minimum or every day if not multiple times during
the day.
This is our full backup script for a Wednesday ...
@echo off
rem Epicor BACKMFG.BAT createc:07/98 JE - editec: 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 NOTh:
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 oe100b\BIN\MFGBKUP.BAT is located.
rem b) Verify path to Mfgsys60\oe100b\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, oe100b\Bin, scripts, etc.)
echo Running Epicor Vantage live ONLINE Backup...
@echo off
e:\epicor904\oe101c\bin\_mprshut e:\epicor904\db\mfgsys -C backup online
e:\epicor904\backed_up_files\live\Wednesday\live_online_backup_wed.1 %4 %5 %6 %7
%8 %9 >> e:\epicor904\backed_up_files\live\Wednesday\live_online_backup_wed.Wri
echo Running Verify...
@echo off
e:\epicor904\oe101c\bin\_dbutil prorest e:\epicor904\db\mfgsys
e:\epicor904\backed_up_files\live\Wednesday\live_online_backup_wed.1 -vp >>
e:\epicor904\backed_up_files\live\Wednesday\live_online_verify_wed.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" ^<emailaddress@...^> > %tempmail%
echo From: "Backup Programme" ^<from@...^> >> %tempmail%
echo Subject: Wednesday - 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 Wednesday 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\Wednesday.>> %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 takes a backup of the live DB and puts the backup in a folder for Wednesday
which is overwritten every week. We have one of these for Monday to Friday and
also have Thursday 1, 2, 3, 4.
By having Thursday 1-4 you are able to revert to 4 weeks ago data if necessary
and you can also revert to each day up to a week ago.
Every day this server is backed up (excluding the DB folder etc) and restored on
an identical server in an completely isolated location. We then verify that the
data that has been backed up is the correct data by running some offline restore
scripts on the disaster recovery server.
We then also take a tape off-site containing the data.
Dont fall into the trap of never testing (or rarely testing) your backups. Test
them daily and it will remove the worry of 'what if'. It will also reduce your
insurance premium a little.
________________________________
From: Ephraim Feldman <effgroups@...>
To: vantage@yahoogroups.com
Sent: Thu, 21 October, 2010 22:02:03
Subject: Re: [Vantage] Email on successful Backup
Probkup does that already but the problem i have is the automatic email how
to do
Ephraim
On Thu, Oct 21, 2010 at 5:00 PM, Waffqle Driggers <waffqle@...> wrote:
>
>
> I've not tried it, but you should be able to run your probkup from a batch
> file and pipe the output to a text file.
> Easy enough to email that and see what happened.
>
> On Thu, Oct 21, 2010 at 4:57 PM, Ephraim Feldman
><effgroups@...<effgroups%40gmail.com>
> >wrote:
>
>
> > What i actually whas thinking is to attach the log file created by the
> > backup.
> > A user will rather give a look at a attached file than to go to the file
> > system or a link to check it.
> >
> > Ephraim
> >
> > On Thu, Oct 21, 2010 at 4:25 PM, Ned
><TechnoBabbly@...<TechnoBabbly%40gmail.com>>
> wrote:
> >
> > >
> > >
> > > My opinion...
> > >
> > > Skip the email.
> > >
> > > The email won't tell you if the backup was successful or not, only that
> > the
> > > backup program ran.
> > >
> > > Just make it part of someone's job to be checking it each morning, to
> > make
> > > sure it ran and then on a regular basis restore a backup to a secondary
> > DB.
> > > Personally I have always done it Mondays and Thursdays to check the
> > backup
> > > to make sure it will actually work.
> > >
> > > I also recommend adjusting Progress backup scripts to make each backup
> > > unique instead of always overwriting with the same live905.bak or
> > > liveback.1
> > > or whatever the file is named.
> > >
> > > Emails and notifications are great, but they don't always tell the
> whole
> > > situation and certain things you can't just replace with automation.
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> [mailto:
> > > vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>] On Behalf Of
> > > Ephraim Feldman
> > > Sent: Thursday, October 21, 2010 1:50 PM
> > > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
> > > Subject: [Vantage] Email on succesfull Backup
> > >
> > > Hi All
> > >
> > > We setup our db backup to run every night using a batch file with the
> > Task
> > > scheduler of windows but we would like to get a email on the backup
> > status
> > > &
> > > success.
> > > What are my options on doing this and how does everyone handle this?
> > >
> > > Ephraim
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > ------------------------------------
> > >
> > > 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
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > 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
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>Â
>
[Non-text portions of this message have been removed]
------------------------------------
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/.%c2%a0
(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
[Non-text portions of this message have been removed]