Re: Backup is missing some records

Hi,

Using the live system backup function, the copy made should be the 
database in the state it is when the backup is made.  If any records are 
added or removed during the backup, this change will not be present in 
the backed up version.  In other words, the backup copy will be the 
state of the database at the last commit immediately before the backup 
command was run.

What sort of records are missing from the backup?  Is it records that 
have recently been added or longer term records?  You should expect that 
records added close to or during the backup command will not make it 
into the backed up version.

Toby.

Hendrik Schwachenwalde wrote:

> 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!



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