Worked great. I've been wanting to try this for a long time as a means ot
populating the test db without shutting down the live db to use procopy.
Only change was in the prorest command line locaiton for the backup. Ours
was at e:\epicor\backup\backup.1 rather than e:\backup\backup.1. Now I can
package this as a command file and include a reminder to change the company
name to "TEST TEST TEST" in the test db and I will be set to refresh it as
often as the users want.
Thanks to everyone for the help.
-Todd C.
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, November 12, 2001 12:29 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Restore from vantage.bkp
Thanks - I was just going to send a question about "where" the restore will
go and if ProRest obeys the "current" directory (cd) location. Now I can
turn off TEST and try it without worrying about hurting the LIVE location.
-Todd C.
-----Original Message-----
From: Gary Polvinale [mailto:garyp@...]
Sent: Monday, November 12, 2001 12:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Restore from vantage.bkp
Yes. I tried to restore using the command line while database was turned
on - the restore command stopped without making the restore. If you have
multiple databases and are restoring only one, be sure to leave the others
running so it won't overwrite them by a typo by accident.
Gary Polvinale
Denton ATD
Milan OH
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, November 12, 2001 12:44 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Restore from vantage.bkp
One more question - Do I first need to shut off the target db in Procontrol
as I would if using Procopy?
Thanks,
-Todd C.
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, November 12, 2001 11:41 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Restore from vantage.bkp
OH, and I also do a "set dlc=e:\epic50\progress" in there too. I'm not sure
what it does, but it was in one of the batch files that epicor supplied so I
have included it as well.
So, Similar to Terry's batch file I have:
e:
cd e:\epic50\vantage\db
set dlc=e:\epic50\progress
path=e:\epic50\progress\bin
prorest vantage e:\backup\backup.1
Troy Funte
Liberty Electronics
populating the test db without shutting down the live db to use procopy.
Only change was in the prorest command line locaiton for the backup. Ours
was at e:\epicor\backup\backup.1 rather than e:\backup\backup.1. Now I can
package this as a command file and include a reminder to change the company
name to "TEST TEST TEST" in the test db and I will be set to refresh it as
often as the users want.
Thanks to everyone for the help.
-Todd C.
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, November 12, 2001 12:29 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Restore from vantage.bkp
Thanks - I was just going to send a question about "where" the restore will
go and if ProRest obeys the "current" directory (cd) location. Now I can
turn off TEST and try it without worrying about hurting the LIVE location.
-Todd C.
-----Original Message-----
From: Gary Polvinale [mailto:garyp@...]
Sent: Monday, November 12, 2001 12:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Restore from vantage.bkp
Yes. I tried to restore using the command line while database was turned
on - the restore command stopped without making the restore. If you have
multiple databases and are restoring only one, be sure to leave the others
running so it won't overwrite them by a typo by accident.
Gary Polvinale
Denton ATD
Milan OH
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, November 12, 2001 12:44 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Restore from vantage.bkp
One more question - Do I first need to shut off the target db in Procontrol
as I would if using Procopy?
Thanks,
-Todd C.
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, November 12, 2001 11:41 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Restore from vantage.bkp
OH, and I also do a "set dlc=e:\epic50\progress" in there too. I'm not sure
what it does, but it was in one of the batch files that epicor supplied so I
have included it as well.
So, Similar to Terry's batch file I have:
e:
cd e:\epic50\vantage\db
set dlc=e:\epic50\progress
path=e:\epic50\progress\bin
prorest vantage e:\backup\backup.1
Troy Funte
Liberty Electronics
----- Original Message -----
From: Brian Boyes
To: 'vantage@yahoogroups.com'
Sent: Monday, November 12, 2001 12:27 PM
Subject: RE: [Vantage] Restore from vantage.bkp
Assuming Vantage 5.0 here although the procedure is the same for 4.0:
Run a command prompt, change directory to epic50\progress\bin, and run the
following command:
prorest <vantage database> <backup file>
So in our, case the line looks like this:
prorest e:\epic50\vantage\db\vantage e:\backup\backup.1
Although, if you are testing to make sure your Vantage backup is good, I
would not suggest restoring over your live database!
Brian Boyes,
Systems Administrator,
Precision Resource Canada Ltd.
< http://www.precisionresource.com <http://www.precisionresource.com> <
http://www.precisionresource.com <http://www.precisionresource.com> > <
http://www.precisionresource.com <http://www.precisionresource.com> <
http://www.precisionresource.com <http://www.precisionresource.com> > > >
<mailto:brianb@...>
> How do we restore the data from vantage.bkp if anything goes wrong
> with the original..
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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> > >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<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]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=213858.1727639.3250013.1261774/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=213858.1727639.3250013.1261774/D=egroupweb/S=17050071
>
<
http://rd.yahoo.com/M=213858.1727639.3250013.1261774/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=213858.1727639.3250013.1261774/D=egroupweb/S=17050071
>
>
83:HM/A=763352/R=0/* http://www.classmates.com/index.tf?s=5085
<http://www.classmates.com/index.tf?s=5085>
< http://www.classmates.com/index.tf?s=5085
<http://www.classmates.com/index.tf?s=5085> > >
<
http://us.adserver.yahoo.com/l?M=213858.1727639.3250013.1261774/D=egroupmai
<http://us.adserver.yahoo.com/l?M=213858.1727639.3250013.1261774/D=egroupmai
>
<
http://us.adserver.yahoo.com/l?M=213858.1727639.3250013.1261774/D=egroupmai
<http://us.adserver.yahoo.com/l?M=213858.1727639.3250013.1261774/D=egroupmai
>
>
l/S=1705007183:HM/A=763352/rand=174984606>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> > >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> > >
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> <
http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > > .
[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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=213858.1727639.3250013.1261774/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=213858.1727639.3250013.1261774/D=egroupweb/S=17050071
>
83:HM/A=763352/R=0/* http://www.classmates.com/index.tf?s=5085
<http://www.classmates.com/index.tf?s=5085> >
<
http://us.adserver.yahoo.com/l?M=213858.1727639.3250013.1261774/D=egroupmai
<http://us.adserver.yahoo.com/l?M=213858.1727639.3250013.1261774/D=egroupmai
>
l/S=1705007183:HM/A=763352/rand=329802791>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .
[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]