Subject | Re: consistency check error |
---|---|
Author | Adam |
Post date | 2008-01-20T22:46:12Z |
--- In firebird-support@yahoogroups.com, "Sasa Mihajlovic"
<majstoru@...> wrote:
curiosity, does the same error occur when you perform a simple select
* from that table?
If so, shut down the Firebird service first and then take a file copy
to a 'safe' location (on a different disk) before attempting to
recover data from a suspected corrupt database.
GFix may work.
GBak with -g flag may work
Identifying the record(s) which are not corrupt, copying them to
another table within the database and using a data pumping tool to
copy the data to a clean structure may work.
Adam
<majstoru@...> wrote:
>I wonder if this is a corrupt record within your database? Out of
> Hi Helen,
>
> First of all thanks for all yours help. Next, I was check all you said
> that can be problem and on my server I have 250GB free space on HDD,
> 2GB RAM memory which is used 30% during backing up database, and
> Administrator account + SYSDBA connected on DB. So, I think that all
> works fine, and I found what error are writen on log file, maybe this
> can help for some closer explanantion of my problem:
>
> MASTER (Server) Fri Jan 18 23:33:25 2008
> Database: D:\PROJECTS\BIF\DATA\MERKUR.FDB
> internal gds software consistency check (cannot find record
> fragment (248), file: dpm.cpp line: 1181)
curiosity, does the same error occur when you perform a simple select
* from that table?
If so, shut down the Firebird service first and then take a file copy
to a 'safe' location (on a different disk) before attempting to
recover data from a suspected corrupt database.
GFix may work.
GBak with -g flag may work
Identifying the record(s) which are not corrupt, copying them to
another table within the database and using a data pumping tool to
copy the data to a clean structure may work.
Adam