Copying a database

Yahoo Archive
1
Rhonda
We use probkup to "Copy" a database. We use prorest to restore the
database to our training database. Using this method we don't have
to run prostrct utilities. The only time we have had problems is on a
busy day. If the backup is run during the day the database slows
down. If restore is run during a busy day it may have copy errors.
Running later then everything was fine.
The key lines from our bat files are below. Individual lines are
between the <>. Q: is the partition drive (not mapped).


Backup.bat
<q:>
<cd \epicor\progress\bin
probkup online q:\epicor\vantage\db\vantage>
<q:\dwc\backup\vntgbkup.1>

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

HTH
Russ Dover
On 12 Jan 2001, at 8:42, Reilly, Rhonda wrote:


I have read before that when you want to make a quick
copy of a database
that you shutdown the database in procontrol and copy
the db and the bi
files. My question is. Do I have to shut down
procontrol. I have one
database I need to copy but want to leave the others
running. So can I just
shut down the one I want to copy.

Thanks 
Rhonda


Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
2
I have read before that when you want to make a quick copy of a database
that you shutdown the database in procontrol and copy the db and the bi
files. My question is. Do I have to shut down procontrol. I have one
database I need to copy but want to leave the others running. So can I just
shut down the one I want to copy.

Thanks
Rhonda
3
Rhonda -

Yes.
Just stop the database that you wish to copy.

calvin

----- Original Message -----
From: Reilly, Rhonda <rreilly@...>
To: <vantage@egroups.com>
Sent: Friday, January 12, 2001 8:42 AM
Subject: [Vantage] copying a database


>
> I have read before that when you want to make a quick copy of a database
> that you shutdown the database in procontrol and copy the db and the bi
> files. My question is. Do I have to shut down procontrol. I have one
> database I need to copy but want to leave the others running. So can I
just
> shut down the one I want to copy.
>
> Thanks
> Rhonda
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
4
Rhonda,

I copy my database many times throughout the day and never shut the database
down. In fact users are in the database when I copy it. I have never had
any problems doing it this way.


Jim MacMillan
System Administrator
Sales/Marketing
Scientific Dimensions
800-523-6180
jimmac@...
5
> I copy my database many times throughout the day and never
> shut the database
> down.
This is just a question and is not meant to be a criticism, but
theoretically, is there any chance that you could wind up with a corrupted
database doing it this way? For example, if the system was in the middle of
a transaction when you did the copy?

It figure its usually safer (although slower) to make an online backup and
restore it.

Brian Boyes,
Systems Administrator,
Precision Resource Canada Ltd.
<http://www.precisionresource.com>
<mailto:brianb@...>
6
At 09:43 AM 1/12/2001 , you wrote:
>I copy my database many times throughout the day and never shut the database
>down. In fact users are in the database when I copy it. I have never had
>any problems doing it this way.

Jim, I'm no Progress expert, but I find it really hard to believe that that
is a guaranteed accurate and safe way of copying the data. At best, I
suspect the database server has to process the copy as if the system had
crashed, or other wise been improperly shutdown. Have you checked the .LG
file after restarting to see how it handled it? Recovery and fault
tolerance are part of the product, but I wouldn't want to rely on them if
that were my only backup!

If you're just taking snapshots to have a reporting or training database,
and it seems to be working, then there's no harm done. But I hope you're
doing your actual backups "by the book."

-Wayne Cox
7
Yes, if you have a large database that has a very high write activity.

However, in many cases, after copying a running database using an OS copy utility, when you start the copy, progress will see it as a crashed data base, and go through a crash recovery.

Also note: this discussion only applies to a single volume progress V8 data base. Multi volume data bases (V8 or V9) have special rules; all V9 databases are multi volume.

Brian Boyes wrote:

> > I copy my database many times throughout the day and never
> > shut the database
> > down.
> This is just a question and is not meant to be a criticism, but
> theoretically, is there any chance that you could wind up with a corrupted
> database doing it this way? For example, if the system was in the middle of
> a transaction when you did the copy?
>
> It figure its usually safer (although slower) to make an online backup and
> restore it.
>
> Brian Boyes,
> Systems Administrator,
> Precision Resource Canada Ltd.
> <http://www.precisionresource.com>
> <mailto:brianb@...>
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)

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

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
8
Brian,

There have been instances when I have taken this copied database and put it
into the test database and have had users do testing to learn something in
Vantage. We are still learning the potential of Vantage and find this to be
a great way to learn. I have yet to get any errors when running the
prostrct utility to restore the database this way. Maybe I am lucky so far
and you are correct, but it seems to be working for me. I also should point
out I dont depend on this for my backup, its merely for other occasions. I
am sorry I should have included that part in my first email.

Sorry for the confusion

Jim MacMillan
System Administrator
Sales/Marketing
Scientific Dimensions
800-523-6180
jimmac@...