Thank You all and Adam.
Tou are right, the FIB error was a table introduced by my Delphi
program. I dropped that table and got a good backup with gbak. No
errors. I however get error restoring it : The restored file is fine
but is missing some entries. And GOOD news, my procedures are back in
the restored file.

Here the error i get:
gbak: restoring index I_AR_SALESPEOPLE_NAME
gbak: restoring data for table AR_SALESPEOPLE
gbak: ERROR: validation error for column GLDEPT, value "*** null ***"
gbak: ERROR: warning -- record could not be restored
gbak: Exiting before completion due to errors

I have to find out about this null value. ???

By the way, i used GBAK BackupRunner who worked fine
http://www.bcp-software.nl/backuprunner/index.html

Thank for the explanation and great help.
----------------
Adam a écrit :

> > OK - Using gbak i get a 'closing' but no 'going home'. I see and
> error
> > message at the end : " (PK_FIB$Errormessages) writing constraints",
> and
>
> Is that an error message? Looks to me like you have a table
> called 'FIB$Errormessages' and it is writing the primary key metadata
> to the backup file. I am guessing that some tool has inserted some
> tables into your database (guessing FIB).
>
> I think the going home is just on the restore, you should get a line
> saying
>
> gbak: closing file, committing, and finishing. [?] bytes written
>
> > backup file is pretty small compare to initial.
>
> The backup file is usually smaller than the fdb file. It does not
> contain garbage records, index pages (just what fields it needs to
> create them again), etc. It is not unusual for it to be half the
> size, although if the size of a backup file is significantly and
> unexplainably different to a prior day then it may be worth
> investigating.
>
> For example, if your fbk file is 15000K one day, 15200K the next and
> 5K the next, you know there is a problem.
>
> > Is there any tool to
> > check the database integrity ?
>
> The fastest and most accurate test is to restore the fbk file that
> has just been generated (TO A DIFFERENT LOCATION THAN THE ORIGINAL
> DATABASE). If the restore does not give an error, then it is probably
> fine, but you may want to connect to it from iSQL or some other tool
> for piece of mind.
>
> gbak -c c:\myfbk.fbk localhost:c:\restored.fdb -user sysdba -password
> masterke -v
>
> Changing the path and credentials as required.
>
> As a side note, the fbk file is extremely compressable. I use 7zip
> for this. For example, a 200MB database can be reduced to about 80MB
> using gbak, and the fbk file to 10MB using 7z. Using zip, you can
> achieve about 15MB. This ratio is probably data dependent.
>
> Adam
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> <http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw>
> Computer technical support
> <http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA>
> Compaq computer technical support
> <http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjEqA6g>
>
> Compaq technical support
> <http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w>
> Hewlett packard technical support
> <http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfmvLcA>
> Microsoft technical support
> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>
>
>
>
> YAHOO! GROUPS LINKS
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
>