Backup and Restore Bat files

No, I used the Gnu version to create the GZip files. I know that 7Zip can
create GZip files, but after using WinRAR I didn't bother to test a GZip
file with 7Zip. I use 7Zip quite a bit and I really like the program, just
not for the database backups.



Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ari Footlik
Sent: Tuesday, May 20, 2008 1:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Backup and Restore Bat files



Ted -

Did you try using 7zip to make a GZip archive?

--Ari

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ted Kitch
Sent: Tuesday, May 20, 2008 1:07 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Backup and Restore Bat files

Once the database reaches a certain size I've found that ZIP compatible
compression utilities become pretty useless. I've done some testing with
various zip type programs available for Windows and here is a brief
synopsis
of my findings (I tested each program with its fastest and also its
maximum
compression settings):

WinZip - Compresses very well, very fast, however zipped database would
not
restore with either setting

Zip (included with Windows) - Compresses OK, takes forever and would not
restore

7Zip - Slightly better compression and speed than WinZip, once again
could
not restore with either setting

PKZip (DOS) - Larger and slower than the above and would not restore
either

WinRAR - Smallest file of the bunch and slightly slower than WinZip,
however
would restore 100% every time!

GZip - Larger files and slower than everything except PKZip and Windows
Zip,
but would restore 100% of the time.

These tests were done on a 1.8 GB database. For anyone with a large
database, I would seriously suggest that you do a complete restore to
test
your files if you are using any of the Zip formats. All of the formats
would successfully compress the database without error. Upon restoring
majority would give a CRC error and the database wasn't' correct. Don't
forget that the purpose of backing up is to eventually restore it, so
make
sure you test it all the way through. I'm currently using the command
line
version of WinRAR for compressing our backups. It does cost $ while the
GZip is free, but the file sizes are about 25%+ smaller and considerably
faster.

HTH,

Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Charles Carden
Sent: Tuesday, May 20, 2008 12:38 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Backup and Restore Bat files

Using the Windows Compression will work up to a point. When your
database become too large it will no longer compress the backup. I made
an attempt to compress a backup of our database that was approximately
3.8 GB and Windows would not do it. It did at least tell me that the
file was too large. Consequently, I loaded Winzip. I don't know if
there are free compression utilities that will handle large files or
not.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of RSN
Sent: Monday, May 19, 2008 5:07 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Backup and Restore Bat files

Maybe I'm oversimplifying my response-To the person who asked for a
restore script. Did you get one?
This is what I use for V8.00.812A OpenEdge 10.05B db in *.bat
c:
cd c:\epicor\mfgsys80\db
pause (just so I can confirm which directory I'm restoring to)
c:\epicor\oe100b\bin\prorest mfgsys c:\backup\FILES\backupfilename.bak

To anyone who has backups automated adn scripted-does anyone know the
.exe of the Windows Compression utility in Windows XP so that I can use
this to compress the backup from the command line. Someone else on the
forum had posted a sample backup script that uses Winzip utility. We
don't use Winzip and use the Windows compress files for all zip needs.
Thanks in Advance!
RSN

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

Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089

DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

[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]





[Non-text portions of this message have been removed]
Does any one have a restore batch file that you would share. Brains are
currently pulp from hitting key board.

thank you in advance
What version of Vantage? I have a script for v6 that I re-wrote from
batch to VBScript that does a lot more than just regular backups.

--Ari

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mjtonsing
Sent: Thursday, May 15, 2008 2:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Backup and Restore Bat files



Does any one have a restore batch file that you would share. Brains are
currently pulp from hitting key board.

thank you in advance






[Non-text portions of this message have been removed]
Sorry about that v8 404b

mark

--- In vantage@yahoogroups.com, "Ari Footlik" <ari@...> wrote:
>
> What version of Vantage? I have a script for v6 that I re-wrote from
> batch to VBScript that does a lot more than just regular backups.
>
> --Ari
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of mjtonsing
> Sent: Thursday, May 15, 2008 2:31 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Backup and Restore Bat files
>
>
>
> Does any one have a restore batch file that you would share. Brains are
> currently pulp from hitting key board.
>
> thank you in advance
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I'll email you (and anyone else who wants it) the VBScripts I have for
v6 backups. I bet they could be updated for v8.

--Ari

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mjtonsing
Sent: Thursday, May 15, 2008 2:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Backup and Restore Bat files



Sorry about that v8 404b

mark

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Ari
Footlik" <ari@...> wrote:
>
> What version of Vantage? I have a script for v6 that I re-wrote from
> batch to VBScript that does a lot more than just regular backups.
>
> --Ari
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of mjtonsing
> Sent: Thursday, May 15, 2008 2:31 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Backup and Restore Bat files
>
>
>
> Does any one have a restore batch file that you would share. Brains
are
> currently pulp from hitting key board.
>
> thank you in advance
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
Here's my backup for 404B. It also saves 5 of the latest backups and
rotates them as they go out. I also have it auto-zip the backup
files down smaller automatically for my backup tapes. You can remove
that last line if you need.

@echo off
echo Running Backup...
E:

rem Delete the oldest backup then rotate the rest backwards

cd \epicor\mfgsys803\backup
del backup.5.zip
ren backup.4.zip backup.5.zip
ren backup.3.zip backup.4.zip
ren backup.2.zip backup.3.zip
ren backup.1.zip backup.2.zip

rem Execute the backup of the current life database

cd \epicor\oe101b\bin

call probkup online E:\epicor\mfgsys803\db\mfgsys E:\epicor\mfgsys803
\BACKUP\backup.1

"C:\Program Files\WinZip\WZZIP.EXE" -m "E:\epicor\mfgsys803
\BACKUP\backup.1.zip" "E:\epicor\mfgsys803\BACKUP\backup.1"

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

As far as restoring, I've found no way to automatically restore them
because it always prompts you as to overwriting the existing database.

I can post those files if you want/need.


--- In vantage@yahoogroups.com, "mjtonsing" <mjtonsing@...> wrote:
>
> Does any one have a restore batch file that you would share.
Brains are
> currently pulp from hitting key board.
>
> thank you in advance
>
In version 6.0, I used to be able to run procedures ENDACT60.R and
CLOCKOUT60.R

This was for those times when a Employee record was hung up in Vantage and
they couldn¹t clock out. I am now in 6.1 and I see that there is a function
in the database conversions called End Activity on Labor Detail
Transactions. I am reluctant to run this as I doubt it is specific to an
individual Shop Employee

Any ideas??


Bob Goss
BC nstruments
>




[Non-text portions of this message have been removed]
Try the conversion in the test database.



Steve Ashton
Decoustics Limited



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bob Goss
Sent: Thursday, May 15, 2008 3:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] END ACTIVITY VERSION 6.1



In version 6.0, I used to be able to run procedures ENDACT60.R and
CLOCKOUT60.R

This was for those times when a Employee record was hung up in Vantage and
they couldn¹t clock out. I am now in 6.1 and I see that there is a function
in the database conversions called End Activity on Labor Detail
Transactions. I am reluctant to run this as I doubt it is specific to an
individual Shop Employee

Any ideas??

Bob Goss
BC nstruments
>

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





[Non-text portions of this message have been removed]
Got a hold of someone in Minneapolic (Epicr) and the database conversion is
Company/Shop Employee specific

Good to go

thanks


On 5/15/08 4:15 PM, "Ashton, Steve" <Steve.Ashton@...> wrote:

>
>
>
>
>
> Try the conversion in the test database.
>
> Steve Ashton
> Decoustics Limited
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
> Of Bob Goss
> Sent: Thursday, May 15, 2008 3:57 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] END ACTIVITY VERSION 6.1
>
> In version 6.0, I used to be able to run procedures ENDACT60.R and
> CLOCKOUT60.R
>
> This was for those times when a Employee record was hung up in Vantage and
> they couldn¹t clock out. I am now in 6.1 and I see that there is a function
> in the database conversions called End Activity on Labor Detail
> Transactions. I am reluctant to run this as I doubt it is specific to an
> individual Shop Employee
>
> Any ideas??
>
> Bob Goss
> BC nstruments
>> >
>
> [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]
Yes

Sandy Morse
BVR Technologies Company
815-874-2471 x112

The information in this message is proprietary and/or confidential and is intended only for the use of the individual(s) named above. This message should not be forwarded without permission from the author. If this message is received in error or otherwise by someone other than the addressee, please contact the author at the above number and return the message or destroy it. In addition, the recipient of this data agrees to abide by the United States Export Control of Technical Data and Equipment under the International Traffic in Arms Regulations (ITAR) and Export Administration Regulations (EAR). The recipient agrees to abide by these laws and their regulations not only for export and re-export, but for disclosure to non-U.S. citizens.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 15, 2008 2:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Digest Number 5840



Bob,

It is the same program that we used to call corporate and get emailed to us. I ran it two weeks ago and it worked fine.

Sandy Morse
BVR Technologies Company

11f. END ACTIVITY VERSION 6.1
Posted by: "Bob Goss" bob@... an_ex_molson
Date: Thu May 15, 2008 12:56 pm ((PDT))

In version 6.0, I used to be able to run procedures ENDACT60.R and
CLOCKOUT60.R

This was for those times when a Employee record was hung up in Vantage and
they couldn¹t clock out. I am now in 6.1 and I see that there is a function
in the database conversions called End Activity on Labor Detail
Transactions. I am reluctant to run this as I doubt it is specific to an
individual Shop Employee

Any ideas??


Bob Goss
BC nstruments
>




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



Messages in this topic (6)



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

------------------------------------------------------------------------
Yahoo! Groups Links



------------------------------------------------------------------------
Maybe I'm oversimplifying my response-To the person who asked for a restore script. Did you get one?
This is what I use for V8.00.812A OpenEdge 10.05B db in *.bat
c:
cd c:\epicor\mfgsys80\db
pause (just so I can confirm which directory I'm restoring to)
c:\epicor\oe100b\bin\prorest mfgsys c:\backup\FILES\backupfilename.bak

To anyone who has backups automated adn scripted-does anyone know the .exe of the Windows Compression utility in Windows XP so that I can use this to compress the backup from the command line. Someone else on the forum had posted a sample backup script that uses Winzip utility. We don't use Winzip and use the Windows compress files for all zip needs.
Thanks in Advance!
RSN



[Non-text portions of this message have been removed]
Using the Windows Compression will work up to a point. When your
database become too large it will no longer compress the backup. I made
an attempt to compress a backup of our database that was approximately
3.8 GB and Windows would not do it. It did at least tell me that the
file was too large. Consequently, I loaded Winzip. I don't know if
there are free compression utilities that will handle large files or
not.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RSN
Sent: Monday, May 19, 2008 5:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Backup and Restore Bat files



Maybe I'm oversimplifying my response-To the person who asked for a
restore script. Did you get one?
This is what I use for V8.00.812A OpenEdge 10.05B db in *.bat
c:
cd c:\epicor\mfgsys80\db
pause (just so I can confirm which directory I'm restoring to)
c:\epicor\oe100b\bin\prorest mfgsys c:\backup\FILES\backupfilename.bak

To anyone who has backups automated adn scripted-does anyone know the
.exe of the Windows Compression utility in Windows XP so that I can use
this to compress the backup from the command line. Someone else on the
forum had posted a sample backup script that uses Winzip utility. We
don't use Winzip and use the Windows compress files for all zip needs.
Thanks in Advance!
RSN

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



Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089


DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.



[Non-text portions of this message have been removed]
As far as compression-programs go, I haven't tried it with large files
(or Vantage databases), but 7-Zip is a public-domain product that I've
been using for quite a while now for my own needs (personal and
corporate), and I haven't had any problems with it.

http://www.7-zip.org/

--Ari <http://www.7-zip.com>

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charles Carden
Sent: Tuesday, May 20, 2008 12:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Backup and Restore Bat files



Using the Windows Compression will work up to a point. When your
database become too large it will no longer compress the backup. I made
an attempt to compress a backup of our database that was approximately
3.8 GB and Windows would not do it. It did at least tell me that the
file was too large. Consequently, I loaded Winzip. I don't know if
there are free compression utilities that will handle large files or
not.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of RSN
Sent: Monday, May 19, 2008 5:07 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Backup and Restore Bat files

Maybe I'm oversimplifying my response-To the person who asked for a
restore script. Did you get one?
This is what I use for V8.00.812A OpenEdge 10.05B db in *.bat
c:
cd c:\epicor\mfgsys80\db
pause (just so I can confirm which directory I'm restoring to)
c:\epicor\oe100b\bin\prorest mfgsys c:\backup\FILES\backupfilename.bak

To anyone who has backups automated adn scripted-does anyone know the
.exe of the Windows Compression utility in Windows XP so that I can use
this to compress the backup from the command line. Someone else on the
forum had posted a sample backup script that uses Winzip utility. We
don't use Winzip and use the Windows compress files for all zip needs.
Thanks in Advance!
RSN

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

Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089

DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

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






[Non-text portions of this message have been removed]
Once the database reaches a certain size I've found that ZIP compatible
compression utilities become pretty useless. I've done some testing with
various zip type programs available for Windows and here is a brief synopsis
of my findings (I tested each program with its fastest and also its maximum
compression settings):



WinZip - Compresses very well, very fast, however zipped database would not
restore with either setting

Zip (included with Windows) - Compresses OK, takes forever and would not
restore

7Zip - Slightly better compression and speed than WinZip, once again could
not restore with either setting

PKZip (DOS) - Larger and slower than the above and would not restore either

WinRAR - Smallest file of the bunch and slightly slower than WinZip, however
would restore 100% every time!

GZip - Larger files and slower than everything except PKZip and Windows Zip,
but would restore 100% of the time.



These tests were done on a 1.8 GB database. For anyone with a large
database, I would seriously suggest that you do a complete restore to test
your files if you are using any of the Zip formats. All of the formats
would successfully compress the database without error. Upon restoring
majority would give a CRC error and the database wasn't' correct. Don't
forget that the purpose of backing up is to eventually restore it, so make
sure you test it all the way through. I'm currently using the command line
version of WinRAR for compressing our backups. It does cost $ while the
GZip is free, but the file sizes are about 25%+ smaller and considerably
faster.



HTH,



Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charles Carden
Sent: Tuesday, May 20, 2008 12:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Backup and Restore Bat files



Using the Windows Compression will work up to a point. When your
database become too large it will no longer compress the backup. I made
an attempt to compress a backup of our database that was approximately
3.8 GB and Windows would not do it. It did at least tell me that the
file was too large. Consequently, I loaded Winzip. I don't know if
there are free compression utilities that will handle large files or
not.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of RSN
Sent: Monday, May 19, 2008 5:07 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Backup and Restore Bat files

Maybe I'm oversimplifying my response-To the person who asked for a
restore script. Did you get one?
This is what I use for V8.00.812A OpenEdge 10.05B db in *.bat
c:
cd c:\epicor\mfgsys80\db
pause (just so I can confirm which directory I'm restoring to)
c:\epicor\oe100b\bin\prorest mfgsys c:\backup\FILES\backupfilename.bak

To anyone who has backups automated adn scripted-does anyone know the
.exe of the Windows Compression utility in Windows XP so that I can use
this to compress the backup from the command line. Someone else on the
forum had posted a sample backup script that uses Winzip utility. We
don't use Winzip and use the Windows compress files for all zip needs.
Thanks in Advance!
RSN

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

Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089

DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

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





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

Did you try using 7zip to make a GZip archive?

--Ari

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Kitch
Sent: Tuesday, May 20, 2008 1:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Backup and Restore Bat files



Once the database reaches a certain size I've found that ZIP compatible
compression utilities become pretty useless. I've done some testing with
various zip type programs available for Windows and here is a brief
synopsis
of my findings (I tested each program with its fastest and also its
maximum
compression settings):

WinZip - Compresses very well, very fast, however zipped database would
not
restore with either setting

Zip (included with Windows) - Compresses OK, takes forever and would not
restore

7Zip - Slightly better compression and speed than WinZip, once again
could
not restore with either setting

PKZip (DOS) - Larger and slower than the above and would not restore
either

WinRAR - Smallest file of the bunch and slightly slower than WinZip,
however
would restore 100% every time!

GZip - Larger files and slower than everything except PKZip and Windows
Zip,
but would restore 100% of the time.

These tests were done on a 1.8 GB database. For anyone with a large
database, I would seriously suggest that you do a complete restore to
test
your files if you are using any of the Zip formats. All of the formats
would successfully compress the database without error. Upon restoring
majority would give a CRC error and the database wasn't' correct. Don't
forget that the purpose of backing up is to eventually restore it, so
make
sure you test it all the way through. I'm currently using the command
line
version of WinRAR for compressing our backups. It does cost $ while the
GZip is free, but the file sizes are about 25%+ smaller and considerably
faster.

HTH,

Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Charles Carden
Sent: Tuesday, May 20, 2008 12:38 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Backup and Restore Bat files

Using the Windows Compression will work up to a point. When your
database become too large it will no longer compress the backup. I made
an attempt to compress a backup of our database that was approximately
3.8 GB and Windows would not do it. It did at least tell me that the
file was too large. Consequently, I loaded Winzip. I don't know if
there are free compression utilities that will handle large files or
not.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of RSN
Sent: Monday, May 19, 2008 5:07 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Backup and Restore Bat files

Maybe I'm oversimplifying my response-To the person who asked for a
restore script. Did you get one?
This is what I use for V8.00.812A OpenEdge 10.05B db in *.bat
c:
cd c:\epicor\mfgsys80\db
pause (just so I can confirm which directory I'm restoring to)
c:\epicor\oe100b\bin\prorest mfgsys c:\backup\FILES\backupfilename.bak

To anyone who has backups automated adn scripted-does anyone know the
.exe of the Windows Compression utility in Windows XP so that I can use
this to compress the backup from the command line. Someone else on the
forum had posted a sample backup script that uses Winzip utility. We
don't use Winzip and use the Windows compress files for all zip needs.
Thanks in Advance!
RSN

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

Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089

DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

[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]