Backup Paradox Database

[Harald Breitner]

Hi,

I wan't to Backup an entire paradox-database by copying the files into a
separate directory or into a zipped file.

I'm working on a local database with more than one user logged in is
possible. My questions are:

1. Is it possible to copy all files to another directory without loss of
data when I have to restore these files?
2. If not in multiuser, is it save with exclusive access?
3. Are there tools or does anyone have the same problem?

thanks for all
Harald

PS: I doesn't care about the paradox.lck and the others, because I try
to delete them on every startup.

[gerard patel]

On Wed, 10 Nov 1999 00:44:52 +0100, Harald Breitner
<hbre...@pfaffenhofen.de> wrote:

>Hi,
>
>I wan't to Backup an entire paradox-database by copying the files into a
>separate directory or into a zipped file.
>
>I'm working on a local database with more than one user logged in is
>possible. My questions are:
>
>1. Is it possible to copy all files to another directory without loss of
>data when I have to restore these files?
>2. If not in multiuser, is it save with exclusive access?
>3. Are there tools or does anyone have the same problem?
>

I have done that in a single user setup and found
necessary to close the session. So it is probably impossible
to do what you want if other users are connected.
There are several free or commercial components to do
zip compression. I used E.Engler component, that you
should be able to find at the Delphi Super Page
http://sunsite.icm.edu.pl/delphi

Gerard

[Roy Leierzapf]

I have backed up databases to a ZIP Drive many times without kicking people
out of the app. It has never been a problem so far. I would assume that
timing could cause a problem, though.

gerard patel wrote in message <3828b56...@forums.inprise.com>...

[gerard patel]

On Sat, 27 Nov 1999 22:26:04 -0500, "Roy Leierzapf"
<leie...@worldnet.att.net> wrote:

>I have backed up databases to a ZIP Drive many times without kicking people
>out of the app. It has never been a problem so far. I would assume that
>timing could cause a problem, though.

<snip>

Files accessed by the Bde are opened in compatible mode; if the
backup software tries to open them in exclusive mode (as is doing the
E.Engler component, and as should do any backup software
IMHO), it fails. That's a problem if you want the application itself
to have an option to save the files, as they are not closed when
the *table* is closed, hence the closing of the session.

You can always use a software that copy the files in compatible
mode, of course. Just don't expect to always have a working set
of database files if some user is in the process of updating index
files.

Gerard