Subject Re: [firebird-support] GBAK - validation error for column X, value "*** null ***"
Author Josef KokeŇ°
Hi!

Thanks for the answer. Luckily, I still have the FDB file, so I can get
rid of the bad records easily. What has me concerned is, what if I only
had the backup? Your trick with pumping seems plausible, I will have to
give it a try. IBBackupSurgeon looks promising, too.

Josef

On 15.5.2015 9:14, Alexey Kovyazin ak@... [firebird-support] wrote:
>
> Hi Josef,
>
> Such error is the consequence of the corruption - in the original
> database there was a NULL in the field (most likely, all fields in
> that record are NULL).
> gbak does not check constraints when reading.
>
> The best way to fix it is to find record with NULLs in the original
> database and delete it, then repeat backup/restore.
> If you don't have original records, it can be a problem.
> Try to restore database till the privileges error and then pump data
> from partially restored database to the new empty database with the
> same structure - you can use free tool IBDataPump for it.
> If problems continue, you can export data using our proprietary
> IBBackupSurgeon tool (http://ib-aid.com/en/ibbackupsurgeon/), which
> can export data on low-level.
>
> Regards,
> Alexey Kovyazin
> IBSurgeon