Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: gbak - loosing data


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Nov 22, 2016 2:13 PM Last Post By: quinn wildman
Damian Slanovic

Posts: 42
Registered: 3/23/04
gbak - loosing data  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 21, 2016 12:12 PM
Have an interbase 2009 on windows server 2008. Every night I made a backup/restore.
Eventually, the backup doesn't write all the data and when a restore is made, I lose the data. Without errors.

I've a gbak log file. It shows something like this:
gbak: writing data for table CORTES_LINEAS
gbak: 0 records written
gbak: writing data for table CORTES_CAB
gbak: 0 records written
gbak: writing data for table CONJUNTOS_VALORES
gbak: 0 records written

certeanly those tables have records.

What could be happen? How can I upload this log file?
Appreciate your help. Regards
Damian.
quinn wildman

Posts: 856
Registered: 12/2/99
Re: gbak - loosing data  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 22, 2016 2:13 PM   in response to: Damian Slanovic in response to: Damian Slanovic
The only cause I see is a corrupted database when you did a backup. Try doing a mend with gfix, back up again, and pray. If that doesn't work, your best choice is go to a recent backup that is good.

You can redirect the verbose output of gbak as follows

gbak -v <options> 2>foo.txt

Damian Slanovic wrote:
Have an interbase 2009 on windows server 2008. Every night I made a backup/restore.
Eventually, the backup doesn't write all the data and when a restore is made, I lose the data. Without errors.

I've a gbak log file. It shows something like this:
gbak: writing data for table CORTES_LINEAS
gbak: 0 records written
gbak: writing data for table CORTES_CAB
gbak: 0 records written
gbak: writing data for table CONJUNTOS_VALORES
gbak: 0 records written

certeanly those tables have records.

What could be happen? How can I upload this log file?
Appreciate your help. Regards
Damian.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02