Alberto,


Alberto Pesce schrieb:

> Well, when I find this situations I do:
>
> 1. Backup my db in a file .gdk but this don't finish correctly

How do you do this backup, which options do you use?

The source of the problem can't be the lost parents at this point since
backup doesn't care about them, you will notice when trying to restore
the database from this backup.

The only time I had a problem like this was back in times of IB5.6 when
there were problems with the server and power failures while
ForcedWrites was off.

> 2. So I Extract Metadata with schema and data in a file (very big file .sql)
> 3. I try to Execute this and I obtain the line which cause violation of FK
> 4. I correct with a editor of text

As soon as you can backup the database but aren't able to restore it you
can delete these orphaned records by sql - which won't solve your
problems but it still seems to better than editing in a sql file...


Luc.