Subject Re: [firebird-support] Can't restore database with invalid SP-s
Author Alexey Kovyazin

You can save data from corrupted backup with IBBackupSurgeon software

Alexey Kovyazin

> Hi!
> Once I managed to setup my stored procedures so that in one place (a
> trigger) a procedure was used with different parameter list than in SP
> definition. It only caused errors when the trigger was executed or when
> database was backed up and then restored. Seemed that dependency
> information between SP and trigger was lost.
> Then I could fix the SP usage in trigger, but now I have a backup which
> seems to have same problem. gbak restores only tables but no sp-s or
> views.
> Tried gback with -n option but it didn't help.
> Any advice how can I restore it fully?
> thanks,
> Aivar