Subject Re: [ib-support] Firebird RC1 Backup & Restore Problem
Author Raf Schandevyl
When I restore the DB I'm getting the following errors in the
Interbase.Log file

RAF-MOVING (Server) Mon Nov 26 08:50:42 2001
Database: E:\DATABA~1\INCASSO\V1\INCASSO1.GDB
RDB$FLAGS for trigger CHECK_1 in RDB$TRIGGERS is corrupted (304)

RAF-MOVING (Server) Mon Nov 26 08:50:42 2001
Database: E:\DATABA~1\INCASSO\V1\INCASSO1.GDB
RDB$FLAGS for trigger CHECK_10 in RDB$TRIGGERS is corrupted (304)

RAF-MOVING (Server) Mon Nov 26 08:50:42 2001
Database: E:\DATABA~1\INCASSO\V1\INCASSO1.GDB
RDB$FLAGS for trigger CHECK_12 in RDB$TRIGGERS is corrupted (304)

RAF-MOVING (Server) Mon Nov 26 08:50:42 2001
Database: E:\DATABA~1\INCASSO\V1\INCASSO1.GDB
RDB$FLAGS for trigger CHECK_13 in RDB$TRIGGERS is corrupted (304)

RAF-MOVING (Server) Mon Nov 26 08:50:42 2001
Database: E:\DATABA~1\INCASSO\V1\INCASSO1.GDB
RDB$FLAGS for trigger CHECK_14 in RDB$TRIGGERS is corrupted (304)


What can I do about it?

Raf Schandevyl

Claudio Valderrama C. wrote:

>I managed to clean your script from strange characters when taken from the
>newsgroups. Ran it. Connected to the db. Backed up it. Restored it. Sent in
>both cases the output to files. No problem. Sorry, can't reproduce the bug.
>After the privileges were restored, gbak created the indices and finished.
>
>C.
>
>"Raf Schandevyl" <Raf.Schandevyl@...> wrote in message
>news:<3C0036B7.1010306@...>...
>
>>This is the error I'm getting.
>>
>>gbak: restoring privilege for user SYSDBA
>>gbak: ERROR: attempt to store duplicate value (visible to active=20
>>transactions) i
>>n unique index "RDB$INDEX_11"
>>gbak: Exiting before completion due to errors
>>
>>I attached the script for creating the DB. Try to create it, then=20
>>backup and restore it and you'll get the error.
>>
>>Regards,
>>Raf Schandevyl
>>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>