Hi Adam,

> I am trying to restore a database, but keep getting the following
> error
>
> "Attempt to store duplicate value (visible to active transactions) in
> unique index "RDB$INDEX_11""
>
> This index is for the table RDB$GENERATORS and it appears to be
> trying to restore RDB$SECURITY twice.
>
> Has anyone come across this before and is there anyway round it?
>
> I have tried deactivating indices but that made no difference.

There was an error with this in early Firebird builds.

I believe the fix was to set the generator RDB$SECURITY to a
system generator or to delete it before backing up. You might want
to check the Yahoogroup archives on this - searching for RDB$SECURITY
should get you going.


With regards,

Martijn Tonies
Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."