Hello!

You can save data from corrupted backup with IBBackupSurgeon software
www.ibbackupsurgeon.com

Sincerely,
Alexey Kovyazin
www.ibsurgeon.com




kimon_the_athenian2:

> 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
>