Benson,
 
Thanks for insist for to have a solution for this.
 
We believe we found a pratical solution = for the first, we restored the DB structure only and after then, DB data only. This worked in a test machine, we believe this will work at a production machine. Today, we will see how we can run this as an script, since we know we can have other pratical problems. If this can be resolved in this manner, if this problem happen simultaneously at many columns and many tables, this way we will have the problem resolved at all his many occurrences.

Thanks a lot for your follow up.
 
Roberto Camargo.
 

________________________________
From: Alexandre Benson Smith <iblist@...>
To: firebird-support@yahoogroups.com
Sent: Tuesday, June 25, 2013 9:40 PM
Subject: Re: [firebird-support] GBak Backup & Restore Problem


Roberto,

Em 25/6/2013 17:07, Tupy... nambá escreveu:

> Mr.Benson,
> 
> No, the constraint wasn´t change. As I explain to mr.Jesus Garcia, we take the DB having the data and the constraint in the needed conditions, we made a backup and then the restore. This mean = all the conditions were assured that the DB were in "good conditions" and, during the backup/restore process, the data at this column was "lost".
> 
> 
> Thank you, i.c.u.2 !
> Roberto Camargo
>

Did you tried my suggestion ?

I will insist on that... Update the problematic column/table

update MyTable set MyColumn = 0 where Mycolumn is null or MyColumn = 0;
commit;

then try to back-up/restore.

see you !


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org/and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links



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