Copying Databases

Yahoo Archive
1
> I'll be doing that soon myself as we start testing 8.XX on a copy of our
> live db.

After you restore, there's a couple more steps!!!

We go in and change the company name to "********TEST***********" or COPY or
whatever. Nothing's worse than entering a day of work into the test
database...

You'll need to update the System Agent to point to the port numbers of your
test appservers.

NOW, you're ready to go.

Mark W.
2
I just copied my Live database to my test database. I had to stop the
AppServers and restart them afterwards. But my MfgSys803TaskAgent will
not stop. It status is "Stopping, Please wait..." It has been like
that for 10 minutes now. Is it normal to take a while to stop and start
this? I stopped the AppServers on the test DB after the copy, and it
stopped and started just fine. How can I prod it along??



We are running 8.03.403D and Progress 10.1B



Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************





[Non-text portions of this message have been removed]
3
What I do is

In the Progress Explorer Tool
1. Right click on the AppServer and get the Status
2. Get the Broker PID Number
3. Go into Task Manager
4. Go into the Process Tab
5. Find that PID and highlight it
6. Right click and End Process

That will kill the process and stop the AppServer.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Matt Caldwell
Sent: Wednesday, February 20, 2008 11:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Copying Databases

I just copied my Live database to my test database. I had to stop the
AppServers and restart them afterwards. But my MfgSys803TaskAgent will
not stop. It status is "Stopping, Please wait..." It has been like
that for 10 minutes now. Is it normal to take a while to stop and start
this? I stopped the AppServers on the test DB after the copy, and it
stopped and started just fine. How can I prod it along??



We are running 8.03.403D and Progress 10.1B



Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************





[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/.
(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
Yahoo! Groups Links
4
Great info, thanks!! Will try that!





Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Wednesday, February 20, 2008 11:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Copying Databases



What I do is

In the Progress Explorer Tool
1. Right click on the AppServer and get the Status
2. Get the Broker PID Number
3. Go into Task Manager
4. Go into the Process Tab
5. Find that PID and highlight it
6. Right click and End Process

That will kill the process and stop the AppServer.

Scott

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Matt Caldwell
Sent: Wednesday, February 20, 2008 11:25 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Copying Databases

I just copied my Live database to my test database. I had to stop the
AppServers and restart them afterwards. But my MfgSys803TaskAgent will
not stop. It status is "Stopping, Please wait..." It has been like
that for 10 minutes now. Is it normal to take a while to stop and start
this? I stopped the AppServers on the test DB after the copy, and it
stopped and started just fine. How can I prod it along??

We are running 8.03.403D and Progress 10.1B

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links





[Non-text portions of this message have been removed]
5
Isn't there a live backup process in 8.XX?


Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 a Fax 401-596-1050

www.maxsonautomatic.com <http://www.maxsonautomatic.com/>



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Scott Litzau
Sent: Wednesday, February 20, 2008 12:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Copying Databases



What I do is

In the Progress Explorer Tool
1. Right click on the AppServer and get the Status
2. Get the Broker PID Number
3. Go into Task Manager
4. Go into the Process Tab
5. Find that PID and highlight it
6. Right click and End Process

That will kill the process and stop the AppServer.

Scott

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Matt Caldwell
Sent: Wednesday, February 20, 2008 11:25 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Copying Databases

I just copied my Live database to my test database. I had to stop the
AppServers and restart them afterwards. But my MfgSys803TaskAgent will
not stop. It status is "Stopping, Please wait..." It has been like
that for 10 minutes now. Is it normal to take a while to stop and start
this? I stopped the AppServers on the test DB after the copy, and it
stopped and started just fine. How can I prod it along??

We are running 8.03.403D and Progress 10.1B

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso. <http://www.kerusso.com> com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[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. <http://groups.yahoo.com/group/vantage/files/.>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/links>
yahoo.com/group/vantage/links
Yahoo! Groups Links






[Non-text portions of this message have been removed]
6
I've seen this hanging behaviour regularly in our pre-production
environment. The TaskAgent doesn't always exit cleanly. As Scott
Litzau shows below, I do the same thing: identify the process ID from
Progress Explorer, and kill the process (I select 'Kill Process Tree'
just to be safe and get any child processes). Then I can start it
normally.

-brian

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...> wrote:
>
> What I do is
>
> In the Progress Explorer Tool
> 1. Right click on the AppServer and get the Status
> 2. Get the Broker PID Number
> 3. Go into Task Manager
> 4. Go into the Process Tab
> 5. Find that PID and highlight it
> 6. Right click and End Process
>
> That will kill the process and stop the AppServer.
7
Yes, the "online" parameter in

mfgbkup online F:\epicor\mfgsys803\db\mfgsys F:\backup\backup803.1

Indicates to backup the database while it is in multi-user mode. So to back
it up does not require shutting down the DB or the AppServers.

If you want to back it up while it is down you remove the "online"
parameter.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Edward F. Fox, Jr.
Sent: Wednesday, February 20, 2008 12:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Copying Databases

Isn't there a live backup process in 8.XX?


Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 Fax 401-596-1050

www.maxsonautomatic.com <http://www.maxsonautomatic.com/>



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Scott Litzau
Sent: Wednesday, February 20, 2008 12:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Copying Databases



What I do is

In the Progress Explorer Tool
1. Right click on the AppServer and get the Status
2. Get the Broker PID Number
3. Go into Task Manager
4. Go into the Process Tab
5. Find that PID and highlight it
6. Right click and End Process

That will kill the process and stop the AppServer.

Scott

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Matt Caldwell
Sent: Wednesday, February 20, 2008 11:25 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Copying Databases

I just copied my Live database to my test database. I had to stop the
AppServers and restart them afterwards. But my MfgSys803TaskAgent will
not stop. It status is "Stopping, Please wait..." It has been like
that for 10 minutes now. Is it normal to take a while to stop and start
this? I stopped the AppServers on the test DB after the copy, and it
stopped and started just fine. How can I prod it along??

We are running 8.03.403D and Progress 10.1B

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso. <http://www.kerusso.com> com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[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. <http://groups.yahoo.com/group/vantage/files/.>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/links>
yahoo.com/group/vantage/links
Yahoo! Groups Links






[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/.
(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
Yahoo! Groups Links
8
I run this on our live db from a batch file



rem run backup routine

cd \epicor\oe100b\bin

mfgbkup online d:\epicor\mfgsys80\db\mfgsys d:\backup\live80_1.1



Mark

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Edward F. Fox, Jr.
Sent: Wednesday, February 20, 2008 1:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Copying Databases



Isn't there a live backup process in 8.XX?


Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 Fax 401-596-1050

www.maxsonautomatic.com <http://www.maxsonautomatic.com/
<http://www.maxsonautomatic.com/> >

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Scott Litzau
Sent: Wednesday, February 20, 2008 12:45 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Copying Databases

What I do is

In the Progress Explorer Tool
1. Right click on the AppServer and get the Status
2. Get the Broker PID Number
3. Go into Task Manager
4. Go into the Process Tab
5. Find that PID and highlight it
6. Right click and End Process

That will kill the process and stop the AppServer.

Scott

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Matt Caldwell
Sent: Wednesday, February 20, 2008 11:25 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Copying Databases

I just copied my Live database to my test database. I had to stop the
AppServers and restart them afterwards. But my MfgSys803TaskAgent will
not stop. It status is "Stopping, Please wait..." It has been like
that for 10 minutes now. Is it normal to take a while to stop and start
this? I stopped the AppServers on the test DB after the copy, and it
stopped and started just fine. How can I prod it along??

We are running 8.03.403D and Progress 10.1B

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso. <http://www.kerusso.com
<http://www.kerusso.com> > com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[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. <http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/> >
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
yahoo.com/group/vantage/links
Yahoo! Groups Links

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





[Non-text portions of this message have been removed]
9
Thanks, I thought there would be. I'd recommend that Scott uses that
process to backup the database and use "prorest" to restore it to a new
location.

I'll be doing that soon myself as we start testing 8.XX on a copy of our
live db.


Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 a Fax 401-596-1050

www.maxsonautomatic.com <http://www.maxsonautomatic.com/>



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Scott Litzau
Sent: Wednesday, February 20, 2008 1:18 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Copying Databases



Yes, the "online" parameter in

mfgbkup online F:\epicor\mfgsys803\db\mfgsys F:\backup\backup803.1

Indicates to backup the database while it is in multi-user mode. So to back
it up does not require shutting down the DB or the AppServers.

If you want to back it up while it is down you remove the "online"
parameter.

Scott

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Edward F. Fox, Jr.
Sent: Wednesday, February 20, 2008 12:11 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Copying Databases

Isn't there a live backup process in 8.XX?


Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 Fax 401-596-1050

www.maxsonautomatic.com <http://www.maxsonau
<http://www.maxsonautomatic.com/> tomatic.com/>

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Scott Litzau
Sent: Wednesday, February 20, 2008 12:45 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Copying Databases

What I do is

In the Progress Explorer Tool
1. Right click on the AppServer and get the Status
2. Get the Broker PID Number
3. Go into Task Manager
4. Go into the Process Tab
5. Find that PID and highlight it
6. Right click and End Process

That will kill the process and stop the AppServer.

Scott

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Matt Caldwell
Sent: Wednesday, February 20, 2008 11:25 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Copying Databases

I just copied my Live database to my test database. I had to stop the
AppServers and restart them afterwards. But my MfgSys803TaskAgent will
not stop. It status is "Stopping, Please wait..." It has been like
that for 10 minutes now. Is it normal to take a while to stop and start
this? I stopped the AppServers on the test DB after the copy, and it
stopped and started just fine. How can I prod it along??

We are running 8.03.403D and Progress 10.1B

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso. <http://www.kerusso. <http://www.kerusso.com>
com> com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

[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. <http://groups.
<http://groups.yahoo.com/group/vantage/files/.>
yahoo.com/group/vantage/files/.>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups. <http://groups.yahoo.com/group/vantage/links>
yahoo.com/group/vantage/links>
yahoo.com/group/vantage/links
Yahoo! Groups Links

[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. <http://groups.yahoo.com/group/vantage/files/.>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/links>
yahoo.com/group/vantage/links
Yahoo! Groups Links






[Non-text portions of this message have been removed]
10
I back our Progress DB up every 4 hours to an offsite NAS. I use task
scheduler on the server to kick off a batch file that does it all for.

@echo off
cls
Set dlc=v:\Progress

DEL \\k-tsvr4\vantagebackup\0900\backup.1
<file://\\k-tsvr4\vantagebackup\0900\backup.1>

echo.
echo.===============================================
echo. Backup of Live Vantage DB Started.
echo.

call v:\progress\bin\probkup online v:\mfgsys\db\mfgsys
\\NAS\vantagebackup\0900\backup.1
<file://\\NAS\vantagebackup\0900\backup.1> >>
\\NAS\vantagebackup\0900\updatetrn.wri
<file://\\NAS\vantagebackup\0900\updatetrn.wri>


echo. Backup of Live Vantage DB Complete.
echo.===============================================
echo.


Then if I want to restore, I use the following method also via a batch
file. This restore autostarts my appservers

@echo off

v:
cd\mfgsystrn\db\
erase *.* /q

echo. >> c:\backup\updatetrn.wri
echo.=============================================== >>
c:\backup\updatetrn.wri
echo. Restore of Vantage Training DB Started. >>
c:\backup\updatetrn.wri
echo.
echo.===============================================
echo. Restore of Vantage Training DB Started.

call v:\progress\bin\prorest V:\mfgsystrn\db\mfgsys
\\NAS\VantageBackup\0900\backup.1
<file://\\NAS\VantageBackup\0900\backup.1> >> C:\backup\updatetrn.wri

echo. >> c:\backup\updatetrn.wri
echo. Restore of Vantage Training DB Complete. >>
c:\backup\updatetrn.wri
echo.=============================================== >>
c:\backup\updatetrn.wri

echo.
echo. Restore of Vantage Training DB Complete.
echo.===============================================

echo. >> c:\backup\updatetrn.wri
echo. *** Starting Vantage Training DB *** >>
c:\backup\updatetrn.wri
echo.
echo. *** Starting Vantage Training DB ***
call v:\progress\bin\dbman -start mfgsystrn
echo. >> c:\backup\updatetrn.wri
echo. *** DATABASE STARTED *** >> c:\backup\updatetrn.wri
echo.
echo. *** DATABASE STARTED ***
pause

Hopefully this may help a little



--- In vantage@yahoogroups.com, "Edward F. Fox, Jr." <efox@...> wrote:
>
> Thanks, I thought there would be. I'd recommend that Scott uses that
> process to backup the database and use "prorest" to restore it to a
new
> location.
>
> I'll be doing that soon myself as we start testing 8.XX on a copy of
our
> live db.
>
>
> Edward F. Fox, Jr., CPA
>
> Controller
>
> Maxson Automatic Machinery Company
>
> Phone 401-596-0162 a Fax 401-596-1050
>
> www.maxsonautomatic.com <http://www.maxsonautomatic.com/>
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Scott Litzau
> Sent: Wednesday, February 20, 2008 1:18 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Copying Databases
>
>
>
> Yes, the "online" parameter in
>
> mfgbkup online F:\epicor\mfgsys803\db\mfgsys F:\backup\backup803.1
>
> Indicates to backup the database while it is in multi-user mode. So to
back
> it up does not require shutting down the DB or the AppServers.
>
> If you want to back it up while it is down you remove the "online"
> parameter.
>
> Scott
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]
On
> Behalf Of
> Edward F. Fox, Jr.
> Sent: Wednesday, February 20, 2008 12:11 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Copying Databases
>
> Isn't there a live backup process in 8.XX?
>
>
> Edward F. Fox, Jr., CPA
>
> Controller
>
> Maxson Automatic Machinery Company
>
> Phone 401-596-0162 Fax 401-596-1050
>
> www.maxsonautomatic.com <http://www.maxsonau
> <http://www.maxsonautomatic.com/> tomatic.com/>
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]
On
> Behalf Of
> Scott Litzau
> Sent: Wednesday, February 20, 2008 12:45 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Copying Databases
>
> What I do is
>
> In the Progress Explorer Tool
> 1. Right click on the AppServer and get the Status
> 2. Get the Broker PID Number
> 3. Go into Task Manager
> 4. Go into the Process Tab
> 5. Find that PID and highlight it
> 6. Right click and End Process
>
> That will kill the process and stop the AppServer.
>
> Scott
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]
On
> Behalf Of
> Matt Caldwell
> Sent: Wednesday, February 20, 2008 11:25 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Copying Databases
>
> I just copied my Live database to my test database. I had to stop the
> AppServers and restart them afterwards. But my MfgSys803TaskAgent will
> not stop. It status is "Stopping, Please wait..." It has been like
> that for 10 minutes now. Is it normal to take a while to stop and
start
> this? I stopped the AppServers on the test DB after the copy, and it
> stopped and started just fine. How can I prod it along??
>
> We are running 8.03.403D and Progress 10.1B
>
> Matt Caldwell
> Technical Support Analyst
>
> KERUSSO
> P.O. Box 32
> Berryville, AR 72616
> Phone: 800-424-0943 Ext. 231
> Fax: 870-423-3568
> Web Site: http://www.kerusso. <http://www.kerusso.
<http://www.kerusso.com>
> com> com
> ******************************************************************
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ******************************************************************
>
> [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. <http://groups.
> <http://groups.yahoo.com/group/vantage/files/.>
> yahoo.com/group/vantage/files/.>
> yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups. <http://groups.
> <http://groups.yahoo.com/group/vantage/messages>
> yahoo.com/group/vantage/messages>
> yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/links>
> yahoo.com/group/vantage/links>
> yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
> [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. <http://groups.yahoo.com/group/vantage/files/.>
> yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups. <http://groups.yahoo.com/group/vantage/messages>
> yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.yahoo.com/group/vantage/links>
> yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>




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