Backup database [SMC WIRE FABRICATORS]

Yahoo Archive
1
I have written my own backup bats that log there actions so I can verify
that everything ran the night before.

You just can't trust technology!

-----Original Message-----
From: Rick Spriggle [mailto:rspriggle@...]
Sent: Tuesday, May 14, 2002 6:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Backup database [SMC WIRE FABRICATORS]


That would be me and almost immediately Jay Erickson pointed out my
stupidity. In the comment lines of the backvan.bat file it specifically
says to move this file out of the \Vantage directory.

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.)

Guess I got that checkmark on my report card "Fails to follow directions"
:-)

Rick



>Someone mentioned last week that a routine Vantage patch overwrote his
>customized .BAT files and he hadn't been getting a backup for weeks
>(scary!) So it might be a good idea to completely rename your
>customized
>files.
>


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/
2
Question for y'all.....

From the non-techie of the group! How do you backup the database while it's
live? Our Plant Manager asked me to back it up due to MRP problems and I
have NO CLUE how!!!! Anyone help????

TIA

Tricia Simon, Controller
Riten Industries, Inc.
3
At 11:35 AM 5/13/2002 -0400, you wrote:
>How do you backup the database while it's live???

In the Vantage directory on your server, there are a couple .BAT files that
do it. BackVan.bat & VntgBack.bat, IIRC. One of them is a wrapper for the
Progress ProBack command. The other calls the 1st. You need to edit them
a little, for correct path and drive letters. It will extract a backup
image out to a disk file that you can dump to tape or a network drive. you
can use the NT scheduler service with the AT command to run it regularly.

I had another command file that would rename the file with a date & time
stamp. Might be able to find it tomorrow if anyone would like.

If you keep multiple copies of backups on the server be careful not to let
the disk fill up!! If it does while the backup extraction is running, it
will freeze the DB! (yeah, I found out the hard way, hehe.)

Someone mentioned last week that a routine Vantage patch overwrote his
customized .BAT files and he hadn't been getting a backup for weeks
(scary!) So it might be a good idea to completely rename your customized
files.

-Wayne Cox
Twenty Three - Information Technology Consulting
828-685-2338
4
That would be me and almost immediately Jay Erickson pointed out my
stupidity. In the comment lines of the backvan.bat file it specifically
says to move this file out of the \Vantage directory.

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.)

Guess I got that checkmark on my report card "Fails to follow directions"
:-)

Rick



>Someone mentioned last week that a routine Vantage patch overwrote his
>customized .BAT files and he hadn't been getting a backup for weeks
>(scary!) So it might be a good idea to completely rename your
>customized
>files.
>