Thanks all,

When I follow the guidelines and try to restore the database, gbak
ends with the following error:

gbak: cannot commit index RDB$FOREIGN20
gbak: ERROR: violation of FOREIGN KEY constraint "PK_PERSONS" on
table "PERSONS"

gbak: ERROR: action cancelled by trigger (3) to preserve data
integrity
gbak: ERROR: Cannot deactivate primary index
gbak: Exiting before completion due to errors

What can this be causing?

Thanks,
Tom.
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 12:56 PM 30/04/2004 +0000, you wrote:
> > >
> > > You should be able to fix these with gfix. There may be some

lost

> >data, however.
> >
> >how can I fix this with gfix? ie which command do I use for this?
>
> http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_db_corr
>
> /heLen