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 a...@ib-aid.com [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
