Subject Re: [firebird-support] GBak Backup & Restore Problem
Author Tupy... nambá
Hi, Dmitry,
Thanks for you response.
No one has changed this table. At most, as a not null column, someone could have change it to another value, but not to null. And no one changed it´s validation rule (as not null). This is discarded.
We repeated the action = we take the DB, checked the content of this colum (all lines having 0 at this column), then we run a backup and imediatelly a restore, and we reproduced the problem (it ocurred when restoring).
Roberto Camargo.

From: Dmitry Kuzmenko <kdv@...>
Sent: Tuesday, June 25, 2013 4:33 PM
Subject: Re: [firebird-support] GBak Backup & Restore Problem

Hello, Tupy...!

Tuesday, June 25, 2013, 11:23:47 PM, you wrote:

Tn> Dear Friends,

Tn> We have a table with 60 rows where a not null type SmallInt column has 0 (zero) as content.
Tn> When restoring, GBak returns null for this column. As this column
Tn> is not null, we get an error message (Error: Validation error for column .....).

Tn> Between these two steps (backup and restore), no further action is done with the backup file.

Tn> I ask you = What can cause this problem? Is there any solution
Tn> for this? Any idea about this problem?

1. somebody altered column to not null default 0 while column had null data
2. somebody added column not null default 0.

solution - update that column to 0 like this
update table
set field = 0

p.s. gbak backups data, it does not check correspondence of data and
constraints. If it is broken (somehow, by db corruption or by actions
I mentioned), restore will show that column data does not correspond
to it's check.

Dmitry Kuzmenko,



Visit click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at

Yahoo! Groups Links

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