Offtopic-Backups

Aaron,

Thanks for the info. I'm safari-ing deeper into the freeware/cheapware
jungle these days. It has great potential. And it seems doable because of
the access we all have to new product information here in the Vantage user
group - users sharing their personal experiences and opinions.

Most of my users only utilize a small portion of the original program's
capability anyway. And the cheap stuff seems to posess the commonly used
functionality of the original software. I think we tend to get caught up in
the popular hype, and buy the expensive stuff thinking it's the safe route.
But it's a big world out there - a lot of independent stuff going on. Just
a matter of finding out about it.

Thanks again for sharing.
Gary

-----Original Message-----
From: Aaron Hoyt [mailto:aaron@...]
Sent: Thursday, July 25, 2002 10:03 AM
To: vantage@yahoogroups.com
Subject: RE: Re:[Vantage] Offtopic-Backups


Gary,

Believe it or not, I am still testing it. I only found it last week. :)
So far it is doing wonderful, but I have not put it through all the paces
yet. The interface is simple enough for the "average" user though. I was
using "Ultimate Zip" a free winzip "clone" of sorts. Had language issues
with that one, and then started looking at "M.Dev Software ZipGenius". I
had a couple minor issues with the Italian in that one, but it is a real
strong candidate with a built in FTP (Very good interface for experts). I
am thinking of keeping that one for me and some of my power users, but 7-zip
seems to be the best so far for the "average" user. Besides you can't beat
the price with the command line interface.

Aaron Hoyt

-----Original Message-----
From: Gary Polvinale [mailto:garyp@...]
Sent: Thursday, July 25, 2002 9:49 AM
To: vantage@yahoogroups.com
Subject: RE: Re:[Vantage] Offtopic-Backups


Aaron,

It looks like this could replace winzip altogether - is that right? Do you
use it that way, or just for the command-line interface? Looks like a great
utility - and it's GNU freeware! Good find.

Gary Polvinale
Denton ATD

-----Original Message-----
From: Aaron Hoyt [mailto:aaron@...]
Sent: Wednesday, July 24, 2002 3:56 PM
To: vantage@yahoogroups.com
Subject: RE: Re:[Vantage] Offtopic-Backups


>>>Can you share was your script looks like.

If you are as budget conscious as I am lately you can use this one.
http://www.7-zip.com/ ---get a free version of a zip utility that will
handle command line interface.
Install it on the server and then create a batch file that looks something
like this.

-----------

E:\EPIC50\PROGRESS\BIN\BACKVAN.BAT (our modified online backup bat)
cd c:\epicback\
Del backup.zip (remove the old zip (could use update switch instead))
7z.exe a -tzip backup.zip *.VN5 -mx (command line for zip)

-----------

In the example above, I have modified the backvan.bat file to backup our
database "online" using the output file of "c:\epicback\backup.VN5" The
live database resides on E: and I use the add switch after deleting the
original zip file just to be sure that if the zip file is there it is the
newest backup. I also use the -mx switch to use the maximum compression
ratio. In addition you will need your path command to contain the path to
7z.exe.
Now all you have to do is schedule the batch file using AT (or that little
GUI for AT that I brought up last week.) If you are going to use the -mx
switch, make sure you leave plenty of time for the entire process to
complete before your tape is scheduled to run. I recommend testing the
batch file a couple of times during low usage times to be sure what you are
dealing with.

Hope this sparks some ideas for someone.

Aaron Hoyt





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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Out of curiosity, when you all do your backups on the Vantage db, what
all do you backup? Do you backup the entire Epicor dir and its contents
or just the vantage.db?

Thanks,

Jim MacMillan
IT Manager
Scientific Dimensions
A Synergy Company
www.sdi.cc
www.synergymfg.com
800-523-6180 x 207
Database is 1.5 gb.
At noon and during the wee hours I do a progress backup.
My backup software skips the live database. Then runs in the wee wee hours.

Patrick

-----Original Message-----
From: Jim MacMillan [mailto:jimmac@...]
Sent: Tuesday, July 23, 2002 1:50 PM
To: Vantage Listserv
Subject: [Vantage] Offtopic-Backups


Out of curiosity, when you all do your backups on the Vantage db, what
all do you backup? Do you backup the entire Epicor dir and its contents
or just the vantage.db?

Thanks,

Jim MacMillan
IT Manager
Scientific Dimensions
A Synergy Company
www.sdi.cc
www.synergymfg.com
800-523-6180 x 207




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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
I think Epicor recommends backing up Vantage to a directory OTHER than your VAntage or Progress folders, and then you tell your nightly tape backup to cover the Vantage Backup file, but Exclude the Vantage and Progress folders. Trying to do a backup on the Vantage or Progress folders while Vantage is running is a NO-No.

Troy

----- Original Message -----
From: Mike Lowe
To: vantage@yahoogroups.com ; vantage@yahoogroups.com
Sent: Tuesday, July 23, 2002 12:04 PM
Subject: Re:[Vantage] Offtopic-Backups


I back up the db back up file created by using the Progress probkup nightly on
the NT box. I also back up the Vantage and Progress files nightly since they
live on the Novell file server and it is backed up nightly.

If my NT box crashes I reinstall NT, Progress and Vantage then restore the db
and I'm back in business.

____________________Reply Separator____________________
Subject: [Vantage] Offtopic-Backups
Author: <vantage@yahoogroups.com>
Date: 7/23/02 12:49 PM

Out of curiosity, when you all do your backups on the Vantage db, what
all do you backup? Do you backup the entire Epicor dir and its contents
or just the vantage.db?

Thanks,

Jim MacMillan
IT Manager
Scientific Dimensions
A Synergy Company
www.sdi.cc
www.synergymfg.com
800-523-6180 x 207




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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/






----------

Received: from alv-web1.alvaka.net [207.213.32.80] by la-smtpg.connorms.com (ccMail Link to SMTP R8.31.00.5)
; Tue, 23 Jul 2002 11:44:42 -0700
Return-Path: <sentto-20369-32709-1027450190-MLowe=connorms.com@...>
Received: from n28.grp.scd.yahoo.com ([66.218.66.84])
by alv-web1.alvaka.net (NAVGW 2.5.1.12) with SMTP id M2002072311513305307
for <MLowe@...>; Tue, 23 Jul 2002 11:51:38 -0700
X-eGroups-Return: sentto-20369-32709-1027450190-MLowe=connorms.com@...
Received: from [66.218.67.195] by n28.grp.scd.yahoo.com with NNFMP; 23 Jul 2002 18:49:50 -0000
X-Sender: jimmac@...
X-Apparently-To: vantage@egroups.com
Received: (EGP: mail-8_0_7_4); 23 Jul 2002 18:49:45 -0000
Received: (qmail 67742 invoked from network); 23 Jul 2002 18:49:45 -0000
Received: from unknown (66.218.66.217)
by m2.grp.scd.yahoo.com with QMQP; 23 Jul 2002 18:49:45 -0000
Received: from unknown (HELO sdimain.sdi.cc) (63.225.3.66)
by mta2.grp.scd.yahoo.com with SMTP; 23 Jul 2002 18:49:45 -0000
Received: from administrator ([63.225.3.79])
by sdimain.sdi.cc (8.11.6/8.11.4) with ESMTP id g6NHCCO12262
for <vantage@egroups.com>; Tue, 23 Jul 2002 12:12:12 -0500
To: "Vantage Listserv" <vantage@yahoogroups.com>
Message-ID: <001101c23279$b31848e0$4f03e13f@administrator>
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2627
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Importance: Normal
From: "Jim MacMillan" <jimmac@...>
MIME-Version: 1.0
Mailing-List: list vantage@yahoogroups.com; contact vantage-owner@yahoogroups.com
Delivered-To: mailing list vantage@yahoogroups.com
Precedence: bulk
List-Unsubscribe: <mailto:vantage-unsubscribe@yahoogroups.com>
Date: Tue, 23 Jul 2002 12:49:38 -0600
Subject: [Vantage] Offtopic-Backups
Reply-To: vantage@yahoogroups.com
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit


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


Yahoo! Groups Sponsor
ADVERTISEMENT



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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
Our experience has been this.
If you ever need to restore your Vantage directory, you need to reinstall
and then restore the database.
Although, we back up the live Vantage folder to get all reports and such so
that individual files can be replaced, we skip the db folder. The Vantage
server runs a progress online backup to a separate drive in the server
shortly before the automatic tape backup starts. We also back up that
folder (separate share) to get the latest database. We have found this very
effective.
The good news is that the file created when doing an online backup is VERY
compressible (just using Zip we can compress our 690 Meg database backup
down to 163 Megs) making it economical for space on our tape. (We don't
compress it first, but the backup compresses it with a similar ratio to
zip).

Just another method.

Aaron Hoyt

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, July 23, 2002 3:14 PM
To: vantage@yahoogroups.com
Subject: Re: Re:[Vantage] Offtopic-Backups


I think Epicor recommends backing up Vantage to a directory OTHER than your
VAntage or Progress folders, and then you tell your nightly tape backup to
cover the Vantage Backup file, but Exclude the Vantage and Progress folders.
Trying to do a backup on the Vantage or Progress folders while Vantage is
running is a NO-No.

Troy

----- Original Message -----
From: Mike Lowe
To: vantage@yahoogroups.com ; vantage@yahoogroups.com
Sent: Tuesday, July 23, 2002 12:04 PM
Subject: Re:[Vantage] Offtopic-Backups


I back up the db back up file created by using the Progress probkup
nightly on
the NT box. I also back up the Vantage and Progress files nightly since
they
live on the Novell file server and it is backed up nightly.

If my NT box crashes I reinstall NT, Progress and Vantage then restore the
db
and I'm back in business.

____________________Reply Separator____________________
Subject: [Vantage] Offtopic-Backups
Author: <vantage@yahoogroups.com>
Date: 7/23/02 12:49 PM

Out of curiosity, when you all do your backups on the Vantage db, what
all do you backup? Do you backup the entire Epicor dir and its contents
or just the vantage.db?

Thanks,

Jim MacMillan
IT Manager
Scientific Dimensions
A Synergy Company
www.sdi.cc
www.synergymfg.com
800-523-6180 x 207
Has anybody used winzip or any other compressing utility to compress the database once the Progress online backup has been done?
Since space is at a premium on my backup media, I am looking for an automation script to automatically zip the database once the Progress online backup has been completed.
Thanks,
Aaron Hoyt <aaron@...> wrote: Our experience has been this.
If you ever need to restore your Vantage directory, you need to reinstall
and then restore the database.
Although, we back up the live Vantage folder to get all reports and such so
that individual files can be replaced, we skip the db folder. The Vantage
server runs a progress online backup to a separate drive in the server
shortly before the automatic tape backup starts. We also back up that
folder (separate share) to get the latest database. We have found this very
effective.
The good news is that the file created when doing an online backup is VERY
compressible (just using Zip we can compress our 690 Meg database backup
down to 163 Megs) making it economical for space on our tape. (We don't
compress it first, but the backup compresses it with a similar ratio to
zip).

Just another method.

Aaron Hoyt

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, July 23, 2002 3:14 PM
To: vantage@yahoogroups.com
Subject: Re: Re:[Vantage] Offtopic-Backups


I think Epicor recommends backing up Vantage to a directory OTHER than your
VAntage or Progress folders, and then you tell your nightly tape backup to
cover the Vantage Backup file, but Exclude the Vantage and Progress folders.
Trying to do a backup on the Vantage or Progress folders while Vantage is
running is a NO-No.

Troy

----- Original Message -----
From: Mike Lowe
To: vantage@yahoogroups.com ; vantage@yahoogroups.com
Sent: Tuesday, July 23, 2002 12:04 PM
Subject: Re:[Vantage] Offtopic-Backups


I back up the db back up file created by using the Progress probkup
nightly on
the NT box. I also back up the Vantage and Progress files nightly since
they
live on the Novell file server and it is backed up nightly.

If my NT box crashes I reinstall NT, Progress and Vantage then restore the
db
and I'm back in business.

____________________Reply Separator____________________
Subject: [Vantage] Offtopic-Backups
Author:
Date: 7/23/02 12:49 PM

Out of curiosity, when you all do your backups on the Vantage db, what
all do you backup? Do you backup the entire Epicor dir and its contents
or just the vantage.db?

Thanks,

Jim MacMillan
IT Manager
Scientific Dimensions
A Synergy Company
www.sdi.cc
www.synergymfg.com
800-523-6180 x 207





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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




---------------------------------
Do You Yahoo!?
Yahoo! Health - Feel better, live better

[Non-text portions of this message have been removed]
yes! when I purchased winzip I also got the command line add-on which works
beautifully with AT Sched!
-----Original Message-----
From: Johnny Juice [mailto:filippi1970@...]
Sent: Wednesday, July 24, 2002 10:06 AM
To: vantage@yahoogroups.com
Subject: RE: Re:[Vantage] Offtopic-Backups



Has anybody used winzip or any other compressing utility to compress the
database once the Progress online backup has been done?
Since space is at a premium on my backup media, I am looking for an
automation script to automatically zip the database once the Progress online
backup has been completed.
Thanks,
Aaron Hoyt <aaron@...> wrote: Our experience has been
this.
If you ever need to restore your Vantage directory, you need to reinstall
and then restore the database.
Although, we back up the live Vantage folder to get all reports and such
so
that individual files can be replaced, we skip the db folder. The Vantage
server runs a progress online backup to a separate drive in the server
shortly before the automatic tape backup starts. We also back up that
folder (separate share) to get the latest database. We have found this
very
effective.
The good news is that the file created when doing an online backup is VERY
compressible (just using Zip we can compress our 690 Meg database backup
down to 163 Megs) making it economical for space on our tape. (We don't
compress it first, but the backup compresses it with a similar ratio to
zip).

Just another method.

Aaron Hoyt

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, July 23, 2002 3:14 PM
To: vantage@yahoogroups.com
Subject: Re: Re:[Vantage] Offtopic-Backups


I think Epicor recommends backing up Vantage to a directory OTHER than
your
VAntage or Progress folders, and then you tell your nightly tape backup to
cover the Vantage Backup file, but Exclude the Vantage and Progress
folders.
Trying to do a backup on the Vantage or Progress folders while Vantage is
running is a NO-No.

Troy

----- Original Message -----
From: Mike Lowe
To: vantage@yahoogroups.com ; vantage@yahoogroups.com
Sent: Tuesday, July 23, 2002 12:04 PM
Subject: Re:[Vantage] Offtopic-Backups


I back up the db back up file created by using the Progress probkup
nightly on
the NT box. I also back up the Vantage and Progress files nightly since
they
live on the Novell file server and it is backed up nightly.

If my NT box crashes I reinstall NT, Progress and Vantage then restore the
db
and I'm back in business.

____________________Reply Separator____________________
Subject: [Vantage] Offtopic-Backups
Author:
Date: 7/23/02 12:49 PM

Out of curiosity, when you all do your backups on the Vantage db, what
all do you backup? Do you backup the entire Epicor dir and its contents
or just the vantage.db?

Thanks,

Jim MacMillan
IT Manager
Scientific Dimensions
A Synergy Company
www.sdi.cc
www.synergymfg.com
800-523-6180 x 207





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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




---------------------------------
Do You Yahoo!?
Yahoo! Health - Feel better, live better

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


Yahoo! Groups Sponsor
ADVERTISEMENT



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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
Can you share was your script looks like.
Thanks in advance,
Lee Ingalls <eli3@...> wrote: yes! when I purchased winzip I also got the command line add-on which works
beautifully with AT Sched!
-----Original Message-----
From: Johnny Juice [mailto:filippi1970@...]
Sent: Wednesday, July 24, 2002 10:06 AM
To: vantage@yahoogroups.com
Subject: RE: Re:[Vantage] Offtopic-Backups



Has anybody used winzip or any other compressing utility to compress the
database once the Progress online backup has been done?
Since space is at a premium on my backup media, I am looking for an
automation script to automatically zip the database once the Progress online
backup has been completed.
Thanks,
Aaron Hoyt wrote: Our experience has been
this.
If you ever need to restore your Vantage directory, you need to reinstall
and then restore the database.
Although, we back up the live Vantage folder to get all reports and such
so
that individual files can be replaced, we skip the db folder. The Vantage
server runs a progress online backup to a separate drive in the server
shortly before the automatic tape backup starts. We also back up that
folder (separate share) to get the latest database. We have found this
very
effective.
The good news is that the file created when doing an online backup is VERY
compressible (just using Zip we can compress our 690 Meg database backup
down to 163 Megs) making it economical for space on our tape. (We don't
compress it first, but the backup compresses it with a similar ratio to
zip).

Just another method.

Aaron Hoyt

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, July 23, 2002 3:14 PM
To: vantage@yahoogroups.com
Subject: Re: Re:[Vantage] Offtopic-Backups


I think Epicor recommends backing up Vantage to a directory OTHER than
your
VAntage or Progress folders, and then you tell your nightly tape backup to
cover the Vantage Backup file, but Exclude the Vantage and Progress
folders.
Trying to do a backup on the Vantage or Progress folders while Vantage is
running is a NO-No.

Troy

----- Original Message -----
From: Mike Lowe
To: vantage@yahoogroups.com ; vantage@yahoogroups.com
Sent: Tuesday, July 23, 2002 12:04 PM
Subject: Re:[Vantage] Offtopic-Backups


I back up the db back up file created by using the Progress probkup
nightly on
the NT box. I also back up the Vantage and Progress files nightly since
they
live on the Novell file server and it is backed up nightly.

If my NT box crashes I reinstall NT, Progress and Vantage then restore the
db
and I'm back in business.

____________________Reply Separator____________________
Subject: [Vantage] Offtopic-Backups
Author:
Date: 7/23/02 12:49 PM

Out of curiosity, when you all do your backups on the Vantage db, what
all do you backup? Do you backup the entire Epicor dir and its contents
or just the vantage.db?

Thanks,

Jim MacMillan
IT Manager
Scientific Dimensions
A Synergy Company
www.sdi.cc
www.synergymfg.com
800-523-6180 x 207





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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




---------------------------------
Do You Yahoo!?
Yahoo! Health - Feel better, live better

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


Yahoo! Groups Sponsor
ADVERTISEMENT



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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




---------------------------------
Do You Yahoo!?
Yahoo! Health - Feel better, live better

[Non-text portions of this message have been removed]
>>>Can you share was your script looks like.

If you are as budget conscious as I am lately you can use this one.
http://www.7-zip.com/ ---get a free version of a zip utility that will
handle command line interface.
Install it on the server and then create a batch file that looks something
like this.

-----------

E:\EPIC50\PROGRESS\BIN\BACKVAN.BAT (our modified online backup bat)
cd c:\epicback\
Del backup.zip (remove the old zip (could use update switch instead))
7z.exe a -tzip backup.zip *.VN5 -mx (command line for zip)

-----------

In the example above, I have modified the backvan.bat file to backup our
database "online" using the output file of "c:\epicback\backup.VN5" The
live database resides on E: and I use the add switch after deleting the
original zip file just to be sure that if the zip file is there it is the
newest backup. I also use the -mx switch to use the maximum compression
ratio. In addition you will need your path command to contain the path to
7z.exe.
Now all you have to do is schedule the batch file using AT (or that little
GUI for AT that I brought up last week.) If you are going to use the -mx
switch, make sure you leave plenty of time for the entire process to
complete before your tape is scheduled to run. I recommend testing the
batch file a couple of times during low usage times to be sure what you are
dealing with.

Hope this sparks some ideas for someone.

Aaron Hoyt
I back up my copy of the database that I make with the progress utility, Not
the actual database, and the ud and userform directories out of the Vantage
directory. I believe this is what Epicor recommends, (not that that matters
a lot) and installing progress and vantage does not seem like a huge burden
and that way I have a "clean" install.... Might as well get some good out of
a server crash.

-----Original Message-----
From: Jim MacMillan [mailto:jimmac@...]
Sent: Tuesday, July 23, 2002 1:50 PM
To: Vantage Listserv
Subject: [Vantage] Offtopic-Backups [SMC WIRE FABRICATORS]


Out of curiosity, when you all do your backups on the Vantage db, what
all do you backup? Do you backup the entire Epicor dir and its contents
or just the vantage.db?

Thanks,

Jim MacMillan
IT Manager
Scientific Dimensions
A Synergy Company
www.sdi.cc
www.synergymfg.com
800-523-6180 x 207




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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Aaron,

It looks like this could replace winzip altogether - is that right? Do you
use it that way, or just for the command-line interface? Looks like a great
utility - and it's GNU freeware! Good find.

Gary Polvinale
Denton ATD

-----Original Message-----
From: Aaron Hoyt [mailto:aaron@...]
Sent: Wednesday, July 24, 2002 3:56 PM
To: vantage@yahoogroups.com
Subject: RE: Re:[Vantage] Offtopic-Backups


>>>Can you share was your script looks like.

If you are as budget conscious as I am lately you can use this one.
http://www.7-zip.com/ ---get a free version of a zip utility that will
handle command line interface.
Install it on the server and then create a batch file that looks something
like this.

-----------

E:\EPIC50\PROGRESS\BIN\BACKVAN.BAT (our modified online backup bat)
cd c:\epicback\
Del backup.zip (remove the old zip (could use update switch instead))
7z.exe a -tzip backup.zip *.VN5 -mx (command line for zip)

-----------

In the example above, I have modified the backvan.bat file to backup our
database "online" using the output file of "c:\epicback\backup.VN5" The
live database resides on E: and I use the add switch after deleting the
original zip file just to be sure that if the zip file is there it is the
newest backup. I also use the -mx switch to use the maximum compression
ratio. In addition you will need your path command to contain the path to
7z.exe.
Now all you have to do is schedule the batch file using AT (or that little
GUI for AT that I brought up last week.) If you are going to use the -mx
switch, make sure you leave plenty of time for the entire process to
complete before your tape is scheduled to run. I recommend testing the
batch file a couple of times during low usage times to be sure what you are
dealing with.

Hope this sparks some ideas for someone.

Aaron Hoyt





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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Gary,

Believe it or not, I am still testing it. I only found it last week. :)
So far it is doing wonderful, but I have not put it through all the paces
yet. The interface is simple enough for the "average" user though. I was
using "Ultimate Zip" a free winzip "clone" of sorts. Had language issues
with that one, and then started looking at "M.Dev Software ZipGenius". I
had a couple minor issues with the Italian in that one, but it is a real
strong candidate with a built in FTP (Very good interface for experts). I
am thinking of keeping that one for me and some of my power users, but 7-zip
seems to be the best so far for the "average" user. Besides you can't beat
the price with the command line interface.

Aaron Hoyt

-----Original Message-----
From: Gary Polvinale [mailto:garyp@...]
Sent: Thursday, July 25, 2002 9:49 AM
To: vantage@yahoogroups.com
Subject: RE: Re:[Vantage] Offtopic-Backups


Aaron,

It looks like this could replace winzip altogether - is that right? Do you
use it that way, or just for the command-line interface? Looks like a great
utility - and it's GNU freeware! Good find.

Gary Polvinale
Denton ATD

-----Original Message-----
From: Aaron Hoyt [mailto:aaron@...]
Sent: Wednesday, July 24, 2002 3:56 PM
To: vantage@yahoogroups.com
Subject: RE: Re:[Vantage] Offtopic-Backups


>>>Can you share was your script looks like.

If you are as budget conscious as I am lately you can use this one.
http://www.7-zip.com/ ---get a free version of a zip utility that will
handle command line interface.
Install it on the server and then create a batch file that looks something
like this.

-----------

E:\EPIC50\PROGRESS\BIN\BACKVAN.BAT (our modified online backup bat)
cd c:\epicback\
Del backup.zip (remove the old zip (could use update switch instead))
7z.exe a -tzip backup.zip *.VN5 -mx (command line for zip)

-----------

In the example above, I have modified the backvan.bat file to backup our
database "online" using the output file of "c:\epicback\backup.VN5" The
live database resides on E: and I use the add switch after deleting the
original zip file just to be sure that if the zip file is there it is the
newest backup. I also use the -mx switch to use the maximum compression
ratio. In addition you will need your path command to contain the path to
7z.exe.
Now all you have to do is schedule the batch file using AT (or that little
GUI for AT that I brought up last week.) If you are going to use the -mx
switch, make sure you leave plenty of time for the entire process to
complete before your tape is scheduled to run. I recommend testing the
batch file a couple of times during low usage times to be sure what you are
dealing with.

Hope this sparks some ideas for someone.

Aaron Hoyt