Hi

Sorry, I have no idea to help.
But a very much related question to the others on this list:

How can I check if a backup was really successful?

I do scripted backups (quarterly, monthly, weekly, dayly, on some servers
even hourly).
I do this with multi-level backups via nbackup.
For every backup done I also do a scripted restore, to see that this works.

However I would like to run some consistency checks on that restored
database to see if everything is really okay, as I think nbackup only copies
data and does no real checks (except that the backup files belong together).

Is there any DEFINITE way to tell if a database file is consistent (except
for looking at all the data manually)?
I am searching for some scriptable command...

Best regards,
Steffen



-----Ursprüngliche Nachricht-----
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Im Auftrag von
midnight_fred@...
Gesendet: Samstag, 1. August 2009 18:22
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Database Corrupt, can't backup and restore.

Hi all,

My 600 Mo Firebird 2.1.1 Database is corrupted (page file problems).

I've tried to do Gfix and Gbak usefull command without success. How could I
get my data back ? It seems that the backup of my database are also
corrupted... I've tried to use gfix and gbak from 2.1.2 without success.

Any idea ? Thanks, in advance.

Regards from France,

Fred

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

bellow you can find is some indication for someone who can help me :

Result of the Gfix command :

gfix -mend -i -user SYSDBA -password masterkey D:\SAVE\COPY_BASE.FDB
Summary of validation errors

Number of record level errors : 11
Number of Blob page errors : 6
Number of data page errors : 2
Number of database page errors : 106

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

Result of gbak backup command (aborted after creating a 180Mo file of
backup) :

gbak -b -ig -g -user SYSDBA -password masterkey D:\SAVE\COPY_BASE.FDB
D:\SAVE\COPY_BASE.FBK

gbak: ERROR:attempted retrieval of more segments than exist
gbak: ERROR:gds_$get_segment failed
gbak:Exiting before completion due to errors

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

Errors seen in firebird.log ( a lot of message concerning tra.cpp line 2484
is logged on)

COMPUTER (Server) Sat Aug 01 15:35:39 2009
Database: D:\SAVE\COPY_BASE.FDB
Page 146628 is an orphan


COMPUTER (Server) Sat Aug 01 15:41:48 2009
Database: D:\SAVE\COPY_BASE.FDB
internal gds software consistency check (cannot find tip page (165),
file: tra.cpp line: 2494)





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

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

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]