Subject Re: [firebird-support] GBak Backup & Restore Problem
Author Jesus Garcia
Hello, I think you have a row with null value. The option is update table
set column = 0 where column is null and then try to backup restore. I have
seen this issue when changing columns from null to not null and you have
rows in the table.


2013/6/25 Tupy... namb´┐Ż <anhanguera@...>

> **
>
>
>
>
> Dear Friends,
>
> We have a strange problem with GBak. We make a backup with gbak and then a
> restore, also with the same.
>
> We have a table with 60 rows where a not null type SmallInt column has 0
> (zero) as content.
>
> When restoring, GBak returns null for this column. As this column is not
> null, we get an error message (Error: Validation error for column .....).
>
> Between these two steps (backup and restore), no further action is done
> with the backup file.
>
> I ask you = What can cause this problem? Is there any solution for this?
> Any idea about this problem?
>
> Thanks a lot,
> Roberto Camargo,
> Rio de Janeiro / Brasil
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]