Backup is missing some records

Hi Toby,

I am in the process of tracking down a weird problem
regarding missing records in the backup. In order to
nail the cause I would like to know if the files
created by the backup system call should be:

 1. an exact copy of the files in the data directory
of the still active database if nobody has issued any
SQL commands since the backup was made, or

 2. an exact copy of the files in the data directory
after database shutdown if nobody had issued any SQL
commands since the backup was made.

Would creating unused connections to the database
after the backup have any impact on the files in the
data directory, and if so on which ones?

Do you have any suggestions what might cause records
to be missing in a backup?

The problem occured on a backup of a McKoi 1.02
database running in standalone server mode btw.
I am restoring on a different machine running McKoi
1.03! Is there something that should be aware of when 
restoring from an older version? I have done that on
several occasions without encountering any problems so
far.

P.S.:
Thanks Toby for this excellent database.
I really enjoy using it!

______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]