At 08:09 AM 7/10/2007, you wrote:

>Figured out the syntax now to restore the IB .gbk file to multiple .fdb
>files, and it seems to look good
>
>with one large primary file of about 2 Gb and a smaller file of about 0.5
>Gb. However when I test with
>
>a query like this:
>
>select max(entry_id) from entry on the largest table in the database it
>shows there are a lot of rows missing.
>
>This is what I ran with gbak:
>
> gbak -c -p 4096 -v -user sysdba -password xxx C:\test\s6.gbk C:\test\s6.fdb
>500000 C:\test\s6A.fdb
>
>Any ideas what I might be doing wrong here?

Backing up and restoring from single to multiple files and vice versa
isn't a cause of lost data. However, a backup taken from the
original database whilst a large insert operation was in process
would be. The backup process can only see data that was already
committed when the backup started.

Start afresh with a new backup taken from your v.5.6 server when
there's nobody online and gbak can get exclusive access.

And don't forget to use dialect 1 for client attachments with the restored db.

./heLen