Subject RE: [firebird-support] HELP Urgent FB 1.0 GBak Restore problem !!!!
Author Thomas Steinmaurer
> I have the following error message
>
> gbak: creating indexes
> gbak: ERROR: attempt to store duplicate value (visible to active
> transactions) in unique index "RDB$PRIMARY10"
> gbak: Index "RDB$PRIMARY10" failed to activate because:
> gbak: The unique index has duplicate values or NULLs.
> gbak: Delete or Update duplicate values or NULLs, and activate index with
> gbak: ALTER INDEX "RDB$PRIMARY10" ACTIVE;
>
> Does anyone have an idea how the backup file can be restored ?

You could try to restore the database with deactivated
indices and activate the indices one by one then.

Look up the -i[nactive] switch of gbak.



Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com