Hi Carsten,

> When i do this query on the damaged database i get no result !
> When i do this query on the database after the aborted restore i find
> the duplicate primary key.
> Can someone explain this to me ?

Makes sense, since the index is damaged. Disable (drop) the primary key,
then do the query again. You could also try to specifiy a PLAN in order
to prevent index usage. Of couse you should make a backup copy of your
database file before you try this.

> But what is the next step ?

Backup and Restore the database again when you have deleted the
duplicate data.

hth,
Michael