Restoring a database from a foreign server

Hi William,

Thanks for the input but this was a classic case of not being able
to the see the wood for the trees (or my case paths) as within my restore
script there is a path error where would we be without mapped drives (on the
right path)

Once again thanks for the assist.

Stephen Scotney
OS & IT Manager<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" />
Boneham & Turner Limited (World Class Precision Engineers.)



-----Original Message-----
From: William Colls [mailto:william@...]
Sent: 04 February 2001 03:28
To: vantage@yahoogroups.com; Stephen Scotney
Subject: Re: [Vantage] Restoring a database from a foreign server


Stephen, if you got an answer already then you can probably ignore this.
However:

This error classically occurs when the person running the process does not
have
write permission in the directory that progress is trying to create the
file.
Less commonly, it can also happen if the directory does not exists.

Stephen Scotney wrote:

> I am trying to restore from our satellite office a copy of their
> database.
>
> The file I am using was generate using the following progress command
>
> set DLC=E:\EPICOR\PROGRESS
> E:\epicor\progress\bin\probkup online e:\epicor\vantage\db\vantage
> e:\backup\live\vantage
>
> and I am tying to restore using
>
> SET DLC=E:\EPICOR\PROGRESS
> call e:\epicor\progress\bin\prorest e:\bmp\db\vantage
e:\backup\bmp\vantage
>
> the problem I am having is that the progress reports that
>
> PROGRESS PATCH Version 9.0B29 as of April 17, 2000
> ** Unable to create e:\bmp\db\vantage.st, err = 2 (609)
> Unable to create the default .st file
> !!! ERROR - Database restore utility FAILED !!! (8564)
>
> If anyone out their can assist I would be greatful
>
> Stephen Scotney
> OS & IT Manager
> Boneham & Turner Ltd
> mailto:steps@...
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985




Yahoo! Groups Sponsor



<http://rd.yahoo.com/M=176325.1307935.2900315.1248727/D=egroupmail/S=1700007
183:N/A=567150/R=1/*http://domains.yahoo.com>
<http://rd.yahoo.com/M=176325.1307935.2900315.1248727/D=egroupmail/S=1700007
183:N/A=567150/R=2/*http://domains.yahoo.com>


www.

<http://us.adserver.yahoo.com/l?M=176325.1307935.2900315.1248727/D=egroupmai
l/S=1700007183:N/A=567150/rand=450294786>

To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com






[Non-text portions of this message have been removed]
I am trying to restore from our satellite office a copy of their
database.

The file I am using was generate using the following progress command

set DLC=E:\EPICOR\PROGRESS
E:\epicor\progress\bin\probkup online e:\epicor\vantage\db\vantage
e:\backup\live\vantage

and I am tying to restore using

SET DLC=E:\EPICOR\PROGRESS
call e:\epicor\progress\bin\prorest e:\bmp\db\vantage e:\backup\bmp\vantage

the problem I am having is that the progress reports that

PROGRESS PATCH Version 9.0B29 as of April 17, 2000
** Unable to create e:\bmp\db\vantage.st, err = 2 (609)
Unable to create the default .st file
!!! ERROR - Database restore utility FAILED !!! (8564)

If anyone out their can assist I would be greatful

Stephen Scotney
OS & IT Manager
Boneham & Turner Ltd
mailto:steps@...
These are the restore lines that work for us. We are restoring Traing
from the backup of the live db. Each line is in between <>.
Operating from the directory the file will be restored to eliminates
some of the ST problems.

<q:>
<cd \epicor\vntgtrn\db>
<\epicor\progress\bin\prorest vantage q:\dwc\backup\vntgbkup.1>


RRD

On 2 Feb 2001, at 14:04, Stephen Scotney wrote:

I am trying to restore from our satellite office a
copy of their
database.

The file I am using was generate using the following
progress command

set DLC=E:\EPICOR\PROGRESS
E:\epicor\progress\bin\probkup online
e:\epicor\vantage\db\vantage
e:\backup\live\vantage

and I am tying to restore using

SET DLC=E:\EPICOR\PROGRESS
call e:\epicor\progress\bin\prorest e:\bmp\db\vantage
e:\backup\bmp\vantage

the problem I am having is that the progress reports
that

PROGRESS PATCH Version 9.0B29 as of April 17, 2000
** Unable to create e:\bmp\db\vantage.st, err = 2 (609)
Unable to create the default .st file
!!! ERROR - Database restore utility FAILED !!! (8564)

If anyone out their can assist I would be greatful

Stephen Scotney
OS & IT Manager
Boneham & Turner Ltd
mailto:steps@...


Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
Stephen, if you got an answer already then you can probably ignore this.
However:

This error classically occurs when the person running the process does not have
write permission in the directory that progress is trying to create the file.
Less commonly, it can also happen if the directory does not exists.

Stephen Scotney wrote:

> I am trying to restore from our satellite office a copy of their
> database.
>
> The file I am using was generate using the following progress command
>
> set DLC=E:\EPICOR\PROGRESS
> E:\epicor\progress\bin\probkup online e:\epicor\vantage\db\vantage
> e:\backup\live\vantage
>
> and I am tying to restore using
>
> SET DLC=E:\EPICOR\PROGRESS
> call e:\epicor\progress\bin\prorest e:\bmp\db\vantage e:\backup\bmp\vantage
>
> the problem I am having is that the progress reports that
>
> PROGRESS PATCH Version 9.0B29 as of April 17, 2000
> ** Unable to create e:\bmp\db\vantage.st, err = 2 (609)
> Unable to create the default .st file
> !!! ERROR - Database restore utility FAILED !!! (8564)
>
> If anyone out their can assist I would be greatful
>
> Stephen Scotney
> OS & IT Manager
> Boneham & Turner Ltd
> mailto:steps@...
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985