OnLine Back Up

Yahoo Archive
1
Sophia,

All I do to get different backup files names is to copy the backvan.bat file
to other names; and edit that file.

I have a file named 6am.bat, 12pm.bat, 6pm.bat, and 10pm.bat.

I edit the file as follows:

@echo off
rem Dataworks BACKVAN.BAT created:07/98
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 BACKVAN.BAT does the following:
rem 1) Surpress screen display (echo off)
rem 2) Drive letter locating the VNTGBKUP.BAT file.
rem 3) Directory path to the VNTGBKUP.BAT file.
rem 4) Call of VNTGBKUP to do the backup "online"
rem of c:\path\dcdv7 database to c:\backupdir\backup.file.
rem
rem System admin should EDIT the following:
rem a) Change DRIVE LETTER to drive where
rem directory DLCSRV\BIN\VNTGBKUP.BAT is located.
rem b) Verify path to \dlcsrv\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 @echo off
e:
cd \epicor\progress\bin
vntgbkup online e:\epicor\vantage\db\vantage E:\Vantage\Backups\Vntg12pm.bak


The other backups would be like the following lines:

vntgbkup online e:\epicor\vantage\db\vantage E:\Vantage\Backups\Vntg6am.bak
vntgbkup online e:\epicor\vantage\db\vantage E:\Vantage\Backups\Vntg6pm.bak
vntgbkup online e:\epicor\vantage\db\vantage E:\Vantage\Backups\Vntg10pm.bak

Dave Cole
Reeder & Kline

-----Original Message-----
From: Ted Kitch [mailto:ted@...]
Sent: Thursday, December 21, 2000 5:15 PM
To: vantage@egroups.com
Subject: Re: [Vantage] OnLine Back Up


Here is something that I've been using for years. The examples that I stole
this idea from are here:
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=13575
<http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=13575>

Works great withing the backvan.bat file on NT

Ted Kitch
ted@...
----- Original Message -----
From: Wayne Cox
To: vantage@egroups.com
Sent: Thursday, December 21, 2000 8:41 AM
Subject: RE: [Vantage] OnLine Back Up


At 08:37 AM 12/21/2000 -0500, you wrote:
>If you use the Epicor supplied BACKVAN.BAT routine ....
>....schedule it to run, and presto, it works just great!!

Anyone devised a way to have it generate unique names for the backup
file? A date suffix would be nice. Doable with standard NT tools, or do
I
need to install some "real" scripting language?

-Wayne Cox


eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)



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



eGroups Sponsor

<http://rd.yahoo.com/M=102308.1038796.2731130.908943/D=egroupmail/S=17000071
83:N/A=466331/?http://features.yahoo.com/webceleb/carrey/> Click Here!

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)




[Non-text portions of this message have been removed]
2
I would like to start using the on line back up system of Vantage.
However I've got an attack of the nerves!!!
If something goes wrong while backing up what possibility is there of
Vantage being affected?
To test the back up and restore would it be better to try it on the Test
database rather than the Live?
Am I worrying unnecessarily?!
Sophie
3
Sophie,

If you use the Epicor supplied BACKVAN.BAT routine there is nothing that can
go wrong.
I use this in a slightly modified form to backup our database four times a
day.

Just copy the file from the Vantage directory into a directory something
like "C:\Scripts",
edit it to point to the correct locations, schedule it to run, and presto,
it works just great!!

Dave Cole
Reeder & Kline

-----Original Message-----
From: Jill Seath [mailto:JillSeath@...]
Sent: Thursday, December 21, 2000 9:21 AM
To: 'vantage@egroups.com'
Subject: [Vantage] OnLine Back Up


I would like to start using the on line back up system of Vantage.
However I've got an attack of the nerves!!!
If something goes wrong while backing up what possibility is there of
Vantage being affected?
To test the back up and restore would it be better to try it on the Test
database rather than the Live?
Am I worrying unnecessarily?!
Sophie





eGroups Sponsor

<http://rd.yahoo.com/M=102308.1038796.2731130.908943/D=egroupmail/S=17000071
83:N/A=466331/?http://features.yahoo.com/webceleb/carrey/> Click Here!

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)




[Non-text portions of this message have been removed]
4
At 08:37 AM 12/21/2000 -0500, you wrote:
>If you use the Epicor supplied BACKVAN.BAT routine ....
>....schedule it to run, and presto, it works just great!!

Anyone devised a way to have it generate unique names for the backup
file? A date suffix would be nice. Doable with standard NT tools, or do I
need to install some "real" scripting language?

-Wayne Cox
5
With regards to Step 5: Tape BackUp Software, how do I instruct the tape
back up software to ignore or skip the avtive live db dir? We are using
Seagate Backup Software.
Thanks
Sophie

> -----Original Message-----
> From: Cole, Dave [SMTP:dave@...]
> Sent: 21 December 2000 13:38
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] OnLine Back Up
>
> Sophie,
>
> If you use the Epicor supplied BACKVAN.BAT routine there is nothing
> that can
> go wrong.
> I use this in a slightly modified form to backup our database four
> times a
> day.
>
> Just copy the file from the Vantage directory into a directory
> something
> like "C:\Scripts",
> edit it to point to the correct locations, schedule it to run, and
> presto,
> it works just great!!
>
> Dave Cole
> Reeder & Kline
>
> -----Original Message-----
> From: Jill Seath [mailto:JillSeath@...]
> Sent: Thursday, December 21, 2000 9:21 AM
> To: 'vantage@egroups.com'
> Subject: [Vantage] OnLine Back Up
>
>
> I would like to start using the on line back up system of Vantage.
> However I've got an attack of the nerves!!!
> If something goes wrong while backing up what possibility is there of
> Vantage being affected?
> To test the back up and restore would it be better to try it on the
> Test
> database rather than the Live?
> Am I worrying unnecessarily?!
> Sophie
>
>
>
>
>
> eGroups Sponsor    Â
>
> <
> <http://rd.yahoo.com/M=102308.1038796.2731130.908943/D=egroupmail/S=17
> 000071>
> 83:N/A=466331/? <http://features.yahoo.com/webceleb/carrey/>> Click
> Here!    Â
>
> We no longer allow attachments to files. To access/share Report
> Files,
> please go to the following link:Â
> <http://www.egroups.com/files/vantage/>
> < <http://www.egroups.com/files/vantage/>>
> (Note:Â If this link does not work for you the first time you try it,
> go to
> www.egroups.com, login and be sure to save your password, choose My
> Groups,
> choose Vantage, then choose Files. If you save the password, the link
> above
> will work the next time you try it.)
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> eGroups Sponsor
> Click Here!
> <http://rd.yahoo.com/M=102308.1038796.2731130.908943/D=egroupmail/S=17
> 00007183:N/A=466331/?http://features.yahoo.com/webceleb/carrey/>
>
>
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:Â
> <http://www.egroups.com/files/vantage/>
> (Note:Â If this link does not work for you the first time you try it,
> go to www.egroups.com, login and be sure to save your password, choose
> My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)
>
6
Wayne,
I'm not sure, but I think this is what you want to know. I use the
backvan.bat to run my backups. I run a backkup at night and one in the
afternoon. Each backup has it's own file name.

sample of the Syntex:
This changes to the drive vantage is intalled on e:
This is were the vntgbkup command is located cd
\epicor\progress\bin
This is the command:Command Database file (from) backup
file (to)
vntgbkup online e:\epicor\vantage\db\vantage
e:\epicor\backup\live.bk

As you see with this you can name your backup file anything.
This command overwrites the same file names. So I only have 1 live.bk file
at a time.
If you want the file name to continously change, I'm not sure how to do
that, but watch out for disk space.
For those of you interested I use an AT command to run these .BAT files at a
given time and day. They get backed up to tape when backups are run.
Nancy


-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Thursday, December 21, 2000 9:42 AM
To: vantage@egroups.com
Subject: RE: [Vantage] OnLine Back Up



Anyone devised a way to have it generate unique names for the backup
file? A date suffix would be nice. Doable with standard NT tools, or do I
need to install some "real" scripting language?

-Wayne Cox




----------

@echo off
rem Epicor BACKVAN.BAT created:07/98 JE - edited: 07/99
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 BACKVAN.BAT does the following:
rem 1) Surpress screen display (echo off)
rem 2) Drive letter locating the VNTGBKUP.BAT file.
rem 3) Directory path to the VNTGBKUP.BAT file.
rem 4) Call of VNTGBKUP to do the backup "online"
rem of c:\path\vantage.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 PROGRESS\BIN\VNTGBKUP.BAT is located.
rem b) Verify path to epicor\progress\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 BACKVAN.BAT file OUT of the Vantage folder and paste
rem it into any other directory were it will be called on.
rem (i.e. Backup, Progress\Bin, scripts, etc.)

echo Running Backup...
@echo off
e:
cd \epicor\progress\bin
vntgbkup online e:\epicor\vantage\db\vantage e:\epicor\backup\live.bk


----------

@echo off
rem Epicor BACKVAN.BAT created:07/98 JE - edited: 07/99
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 BACKVAN.BAT does the following:
rem 1) Surpress screen display (echo off)
rem 2) Drive letter locating the VNTGBKUP.BAT file.
rem 3) Directory path to the VNTGBKUP.BAT file.
rem 4) Call of VNTGBKUP to do the backup "online"
rem of c:\path\vantage.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 PROGRESS\BIN\VNTGBKUP.BAT is located.
rem b) Verify path to epicor\progress\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 BACKVAN.BAT file OUT of the Vantage folder and paste
rem it into any other directory were it will be called on.
rem (i.e. Backup, Progress\Bin, scripts, etc.)

echo Running Backup...
@echo off
e:
cd \epicor\progress\bin
vntgbkup online e:\epicor\vantage\db\vantage e:\epicor\backup\liveaft.bk


----------

@echo off
rem Epicor BACKVAN.BAT created:07/98 JE - edited: 07/99
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 BACKVAN.BAT does the following:
rem 1) Surpress screen display (echo off)
rem 2) Drive letter locating the VNTGBKUP.BAT file.
rem 3) Directory path to the VNTGBKUP.BAT file.
rem 4) Call of VNTGBKUP to do the backup "online"
rem of c:\path\vantage.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 PROGRESS\BIN\VNTGBKUP.BAT is located.
rem b) Verify path to epicor\progress\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 BACKVAN.BAT file OUT of the Vantage folder and paste
rem it into any other directory were it will be called on.
rem (i.e. Backup, Progress\Bin, scripts, etc.)

echo Running Backup...
@echo off
e:
cd \epicor\progress\bin
vntgbkup online e:\epicor\vantage\db\vantage e:\epicor\backup\train.bk



[Non-text portions of this message have been removed]
7
To answer Jill's question about backups causing problems: There is a much
greater chance that you will need a backup someday than the having the
backup cause a problem. Second, although the Progress online backup is
somewhat complicated in the way it works (as is any live database backup),
it only *reads* from the database, so it can't hurt the database itself.

> Anyone devised a way to have it generate unique names for the backup
> file? A date suffix would be nice. Doable with standard NT
> tools, or do I
> need to install some "real" scripting language?
If you are trying to append the date to the name of the backup file, I'm not
sure. However, if you are looking for a way to keep multiple backups, you
might be able to use our method. We keep the last three of our backups. The
files are backed up to the c:\backup directory. Here is the command file:

rem *** Bump old backup files and create a new one.
if exist c:\backup\backup.3 del c:\backup\backup.3
if exist c:\backup\backup.2 ren c:\backup\backup.2 backup.3
if exist c:\backup\backup.1 ren c:\backup\backup.1 backup.2
cd \epicor\progress\bin
probkup online c:\epicor\vantage\db\vantage.db c:\backup\backup.1
exit

Brian Boyes,
Systems Administrator,
Precision Resource Canada Ltd.
<http://www.precisionresource.com>
<mailto:brianb@...>
8
At 02:07 PM 12/21/2000 , you wrote:
>As you see with this you can name your backup file anything.
>This command overwrites the same file names. So I only have 1 live.bk file
>at a time.
>If you want the file name to continously change, I'm not sure how to do that,

Yup, the "continuous change" is what I had in mind. Right now, my
Backvan.Bat file always dumps out to "Backup.1" which I usually manually
rename to something like Backup.20001220. If I'm not available to load
tapes, I'd like to at least have it extract the backup every day to a
unique file [keep 'em all till manually purged] and copy to another machine
over the net'.

-Wayne
9
Just a quick thought... Can your backup software run a procedure to rename
backup.1 when it is done taping the system backup?
Nancy

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Thursday, December 21, 2000 3:40 PM
To: vantage@egroups.com
Subject: RE: [Vantage] OnLine Back Up


At 02:07 PM 12/21/2000 , you wrote:
>As you see with this you can name your backup file anything.
>This command overwrites the same file names. So I only have 1 live.bk file
>at a time.
>If you want the file name to continously change, I'm not sure how to do
that,

Yup, the "continuous change" is what I had in mind. Right now, my
Backvan.Bat file always dumps out to "Backup.1" which I usually manually
rename to something like Backup.20001220. If I'm not available to load
tapes, I'd like to at least have it extract the backup every day to a
unique file [keep 'em all till manually purged] and copy to another machine
over the net'.

-Wayne




We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
10
Is there an AT command that will rename a file? I haven't used it, but
someone with more time than I have right now might check it out.

The other thought I had is to make different folders for each day of the
week (or month) whatever you're after. Then run a different AT command for
each day of the week, with a different destination for your BackVan copy...


I have the Backup.1 file copied to another server also, and that's about all
the copies of a 400 mg database I care to have rolling around-main vantage
server, backup tape, additional server, backup tape for that server-and of
course, I really only care about the latest info, although I typically run
an archive tape quarterly. I take the tapes offsite every night, so that
settles our ISO requirement for disaster recovery.

Just taking a shot.

Lydia


Just a quick thought... Can your backup software run a procedure to rename
backup.1 when it is done taping the system backup?
Nancy


Yup, the "continuous change" is what I had in mind. Right now, my
Backvan.Bat file always dumps out to "Backup.1" which I usually manually
rename to something like Backup.20001220. If I'm not available to load
11
Here is something that I've been using for years. The examples that I stole this idea from are here:
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=13575

Works great withing the backvan.bat file on NT

Ted Kitch
ted@...
----- Original Message -----
From: Wayne Cox
To: vantage@egroups.com
Sent: Thursday, December 21, 2000 8:41 AM
Subject: RE: [Vantage] OnLine Back Up


At 08:37 AM 12/21/2000 -0500, you wrote:
>If you use the Epicor supplied BACKVAN.BAT routine ....
>....schedule it to run, and presto, it works just great!!

Anyone devised a way to have it generate unique names for the backup
file? A date suffix would be nice. Doable with standard NT tools, or do I
need to install some "real" scripting language?

-Wayne Cox


eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



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