Mega Search
23.2 Million


Sign Up

Make a donation  
gbak dump on corrupted DB  
News Group: embarcadero.public.interbase.general

We execute gbak -b on our customer's databases to test if they are ok or corrupted
Recently we tried to launch gbak -d to create Dump file (on each week) to reduce time needed for this task, Dump only update modified pages once the first Dump is done

But it seems gbak -d doesn't return any error on a corrupted database, the file is created or updated just like it was a valid DB

Is there an option to add with gbak -d which allows to test the validity of the DB ?

Thanks
Yves

Vote for best question.
Score: 0  # Vote:  0
Date Posted: 15-Jan-2015, at 9:58 AM EST
From: Yves Ganier
 
Re: gbak dump on corrupted DB  
News Group: embarcadero.public.interbase.general
It should be noted that the purpose of gbak is not to detect corruption. 
So, if corruption is a concern, you are well advised to use gfix.

On a side note, if you know how your corruption might be occurring, we 
are always interested in knowing the details. Should this be the case, 
please start a new thread. Thanks.

Yves Ganier wrote:
>> {quote:title=quinn wildman wrote:}{quote}
>> No. If you need to verify the database, use gfix -v -f first.
>>
>> Yves Ganier wrote:
>>> Is there an option to add with gbak -d which allows to test the validity of the DB ?
>
> yes we tried this way, but this is far longer than a gbak -b
> Thanks
>

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 16-Jan-2015, at 7:49 AM EST
From: quinn wildman
 
Re: gbak dump on corrupted DB  
News Group: embarcadero.public.interbase.general
> {quote:title=quinn wildman wrote:}{quote}
> No. If you need to verify the database, use gfix -v -f first.
> 
> Yves Ganier wrote:
> > Is there an option to add with gbak -d which allows to test the validity of the DB ?

yes we tried this way, but this is far longer than a gbak -b
Thanks

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 16-Jan-2015, at 4:24 AM EST
From: Yves Ganier
 
Re: gbak dump on corrupted DB  
News Group: embarcadero.public.interbase.general
No. If you need to verify the database, use gfix -v -f first.

Yves Ganier wrote:
> Is there an option to add with gbak -d which allows to test the validity of the DB ?

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 15-Jan-2015, at 3:01 PM EST
From: quinn wildman