# Restoring a database from a foreign server
**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-02-06 08:18 UTC
**Views:** 552
**Replies:** 3
**URL:** https://www.epiusers.help/t/restoring-a-database-from-a-foreign-server/2141
---
## Post #1 by @system
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]
---
## Post #2 by @system
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@...
---
## Post #3 by @system
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
---
## Post #4 by @system
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
---
**Canonical:** https://www.epiusers.help/t/restoring-a-database-from-a-foreign-server/2141
**Original content:** https://www.epiusers.help/t/restoring-a-database-from-a-foreign-server/2141