Subject Re: [firebird-support] How to repair a database with damaged index ?
Author Michael Weissenbacher
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.