Subject RE: [firebird-support] Automatically deleting bad duplicate records
Author Alan McDonald
> We have a database at one of our sites that
> cannot restore because there are duplicate records
> in primary indices.
> Does anyone know how this can happen?
> Also how can we automatically clean all these records from
> the database so we can backup and restore it.

there was a version 1.0 build which allowed you to restore a database with
primary key indexes inactive. Not sure which one - Helen will remember. This
was fixed but what version are you running here? If you again restore with
inactive indexes, you should be able to fix it before backing up again.