Subject Re: [ib-support] Restoring a Database
Author Martijn Tonies
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

Upscene Productions

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