Subject | Re: [firebird-support] GBak Backup & Restore Problem |
---|---|
Author | Jesus Garcia |
Post date | 2013-06-25T19:28:17Z |
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@...>
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@...>
> **[Non-text portions of this message have been removed]
>
>
>
>
> 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]
>
>
>