Prorest and test database

I think what some people are trying to say is that the directory should
be the mfgsys folder you want the restored database to go into. I don't
think it can restore into "prg91d\bin". You have to change directories
to "the target folder where you want to restore your database TO". Then
type the PROREST command with name of database you want to restore then
the location of the back-up file. Though the example below uses V8.0
the principles are the same.



HOW TO USE PROREST:

=====================

1) Open Progress Explorer and STOP the Appservers, and then the
database you wish to overwrite. In this example we will use the
"MfgSys80" database.



Open the Appservers and Right click each Mfgsys80 Appserver and stop
them. Then open Databases, and on the MfgSys80 database and select
"Stop".



2) Go to [START] --> Programs --> OpenEdge 10b --> Proenv



3) At the Proenv prompt, type the word: "prompt" and press enter.



4) Next change directories to the target folder where you want to
restore your MfgSys backup copy. The example uses the training folder.



E:\EPICOR\TRAIN80\DB>



5) The following command is an example of restoring the backup.1 file
from the E:\Backup folder to the training database directory. The
syntax is:



prorest mfgsys e:\backup\backup.1





If a database exists in the folder, you will be prompted a
question "Do you wish to Overwrite?" answer "Y" for yes.



When the process finishes, the prompt will be returned to the
screen.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of PLAMAN DICK
Sent: Monday, January 15, 2007 9:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Prorest and test database



Sandy,
try this:
Start/Programs/Progress 9.1D/Proenv
type "prompt"
navigate to your db directory (not your prg91d\bin directory).. ie;
epicor\mfgsys61\testdb\db
type "prorest mfgsys e:\epicor\mfgsys61\db\testdb" (assuming your
backup is named testdb)
this should work.
good luck

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Sandy Morse
Sent: Monday, January 15, 2007 8:53 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Prorest and test database

Well, here I am again -- trying to remember why I can't get prorest to
work -- we are on 6.1. I have copied my backup file to
E:\epicor\mfgsys61\db\testdb. I go to a command prompt and change my
directory to E:\epicor\prg91d\bin -- then I run the following command
prorest E:\epicor\mfgsys61\db\testdb mfgsys backup.bvr61 -- I get an
error stating that mfgsys cannot be found. What exactly are the steps I
should be using to restore my backup file to the directory I have
listed?

Any and all help will be appreciated!

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.

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





[Non-text portions of this message have been removed]
Well, here I am again -- trying to remember why I can't get prorest to
work -- we are on 6.1. I have copied my backup file to
E:\epicor\mfgsys61\db\testdb. I go to a command prompt and change my
directory to E:\epicor\prg91d\bin -- then I run the following command
prorest E:\epicor\mfgsys61\db\testdb mfgsys backup.bvr61 -- I get an
error stating that mfgsys cannot be found. What exactly are the steps I
should be using to restore my backup file to the directory I have
listed?

Any and all help will be appreciated!

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.
Sandy,

Open proenv (from the progress / openedge program menu, off
start)

Type in the following

prompt

E:

cd e:\epicor\mfgsys61\db\testdb

prorest mfgsys backup.bvr61



That should work.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sandy Morse
Sent: 15 January 2007 13:53
To: vantage@yahoogroups.com
Subject: [Vantage] Prorest and test database



Well, here I am again -- trying to remember why I can't get prorest to
work -- we are on 6.1. I have copied my backup file to
E:\epicor\mfgsys61\db\testdb. I go to a command prompt and change my
directory to E:\epicor\prg91d\bin -- then I run the following command
prorest E:\epicor\mfgsys61\db\testdb mfgsys backup.bvr61 -- I get an
error stating that mfgsys cannot be found. What exactly are the steps I
should be using to restore my backup file to the directory I have
listed?

Any and all help will be appreciated!

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.





[Non-text portions of this message have been removed]
I've had this before too. I seem to recall that the first time I created a TestDB there was a problem restoring. If the TestDB folder is empty of database files it might be that there must be files there for prorest to "restore over". I think I had to copy the trainingDB mfgsys files to my TestDB folder and restore over them. From then on periodic restores to "refresh" the TestDB worked fine.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Sandy Morse
Sent: Monday, January 15, 2007 7:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Prorest and test database



Well, here I am again -- trying to remember why I can't get prorest to
work -- we are on 6.1. I have copied my backup file to
E:\epicor\mfgsys61\db\testdb. I go to a command prompt and change my
directory to E:\epicor\prg91d\bin -- then I run the following command
prorest E:\epicor\mfgsys61\db\testdb mfgsys backup.bvr61 -- I get an
error stating that mfgsys cannot be found. What exactly are the steps I
should be using to restore my backup file to the directory I have
listed?

Any and all help will be appreciated!

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.






[Non-text portions of this message have been removed]
Sandy, you can also do it this way: you need to change the directory to the
folder where you want to restore the db to, then run the prorest command as
I show below, with the location of the prorest command in the first part,
and the location of the backup in the second. Mine looks a little strange
because I'm still using the location of 5.2 for progress while running 6.1
in it's location.

****
Example:
f:
cd \ep-Pilot61
d:\epic52\progress\bin\prorest mfgsys d:\epicor\mfgsys61\backup\backup.61

*****
hope this helps

Norm Watkins
Engineering Manager
ELECPAC
Phone: 847-639-2307

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Sandy Morse
Sent: Monday, January 15, 2007 7:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Prorest and test database


Well, here I am again -- trying to remember why I can't get prorest to
work -- we are on 6.1. I have copied my backup file to
E:\epicor\mfgsys61\db\testdb. I go to a command prompt and change my
directory to E:\epicor\prg91d\bin -- then I run the following command
prorest E:\epicor\mfgsys61\db\testdb mfgsys backup.bvr61 -- I get an
error stating that mfgsys cannot be found. What exactly are the steps I
should be using to restore my backup file to the directory I have
listed?

Any and all help will be appreciated!

Sandy Morse
BVR Technologies Company
815-874-2471 x112
Sandy,
try this:
Start/Programs/Progress 9.1D/Proenv
type "prompt"
navigate to your db directory (not your prg91d\bin directory).. ie;
epicor\mfgsys61\testdb\db
type "prorest mfgsys e:\epicor\mfgsys61\db\testdb" (assuming your
backup is named testdb)
this should work.
good luck

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sandy Morse
Sent: Monday, January 15, 2007 8:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Prorest and test database



Well, here I am again -- trying to remember why I can't get prorest to
work -- we are on 6.1. I have copied my backup file to
E:\epicor\mfgsys61\db\testdb. I go to a command prompt and change my
directory to E:\epicor\prg91d\bin -- then I run the following command
prorest E:\epicor\mfgsys61\db\testdb mfgsys backup.bvr61 -- I get an
error stating that mfgsys cannot be found. What exactly are the steps I
should be using to restore my backup file to the directory I have
listed?

Any and all help will be appreciated!

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.





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