At 08:33 AM 22-04-02 -0600, you wrote:

>Yes, this was the problem. The users network does a backup every night
>at 10:00 pm.
>
>I was aware that they did this every night during the week, but I wasn't
>aware of it happening on Sundays.

Erk.

>What does everyone else do for backups? Do they include the GDB file
>when backing up their data

No

>or do they exclude it and only do GBK
>(Interbase Backup) files.

Yep - and include the GBK in the backup (after it has finished, of course).

>I find it scary that your database can get corrupted if you try to copy
>it when it is in use.

A database file needs to be in shared access files. Your sysadmin
shouldn't be backing up/copying/zipping shared access files
willy-nilly. His robot probably has system privileges, which means it can
do what it jolly-well likes, even to getting access to the file when the
ibserver process has exclusive access (which it does, if it is Firebird,
and doesn't if it is IB.)

If they can't exclude your shared access files from their backup, tell them
to get everyone off and shut down the server before they start.
--H

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________