If you only have a backup and the backup is corrupted then very bad
news.
The best politic is always to do a backup/restore cycle inmediatly. So, if
an error is detected when the backup is being restored you can take actions
at that right moment.
If your operating system is Windows, you can
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
Hi!
What would be a proper way of dealing with GBAK restore error
'validation error for column X, value *** null ***'? This error
appears in one table, where X is the primary key. The database is
Firebird 2.5.4 in the superserver mode.
1) How do I properly restore this backup? Neither
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