Hi,

We have a interbase 5.6 database which had a corrupted constraint
index. I drop and recreated the index. The first restore we did
alerted us to the fact that the index was a problem. When we rerun
the backup and restore process the restore failed and the following
reason was generated:

gbak: creating indexes
gbak: ERROR: index RDB$PRIMARY42 cannot be used in the specified
plan
gbak: Exiting before completion due to errors

Restore exited unsuccessfully on Thu May 16 04:27:08 2002

The index RDB$PRIMARY42 is the index that was dropped and recreated
but with a new name. I need to drop any reference to the
RDB$PRIMARY42 constraint.

Please help!

Thanks
Paul Grobler
Blake & Associates
Tel: (031) 5384000
Fax: (031) 5384971
Email: paul@...