Subject Re: [firebird-support] restore - attempt to store duplicate value
Author Milan Babuskov
mat wrote:
> During restore of my database using FB've got the following error "Attempt to store duplicated value (visible to active transactions) in unique index rdb$index_2". Restore with deactivated indexes doesn't work also. So is my database corrupted seriously? And how can I fix it? How can I find out which values are duplicated?

You could create an empty database (using gbak -m) and pump the data
from the "problematic" one. While pumping, you'll probably run into the
record that has problems, so you can identify it and fix it.

P.S. Don't hijack other threads by deleting the message body and
subject. Write a new message instead.

P.P.S. Set line-wrap to some reasonable value.

Milan Babuskov