Mega Search
23.2 Million


Sign Up

Make a donation  
gbak connection to database lost  
News Group: embarcadero.public.interbase.general

Able to run database validation successfully in Interbase XE3. 
BUT after that, attempting to backup database with gbak, it stalls on certain tables and then disconnects the DB connection.
"connection to database lost"
I am trying to backup and restore, but backup blows up. What can I do?
Thanks for any help!

Vote for best question.
Score: 0  # Vote:  0
Date Posted: 16-Jan-2015, at 12:17 PM EST
From: ken pfeiffer
 
Re: gbak connection to database lost  
News Group: embarcadero.public.interbase.general
Thank you Quinn.  Unfortunately the "mend" did not work, it just hung up. 
Strange that running DB validation from IB Console did not show errors.
Anyway, fortunately the user had a DB backup which we used and we
also reinstalled interbase. Now it appears all is well.  Appreciate your
help!


> {quote:title=quinn wildman wrote:}{quote}
> I would suggest you have a corrupted database. In that case, you should 
> mend your database first. Here is an example of mending a database:
> 
> set isc_user=sysdba
> set isc_password=masterkey
> gfix -mend "path to database"
> 
> ken pfeiffer wrote:
> > Able to run database validation successfully in Interbase XE3.
> > BUT after that, attempting to backup database with gbak, it stalls on certain tables and then disconnects the DB connection.
> > "connection to database lost"
> > I am trying to backup and restore, but backup blows up. What can I do?
> > Thanks for any help!
> >

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 16-Jan-2015, at 4:02 PM EST
From: ken pfeiffer
 
Re: gbak connection to database lost  
News Group: embarcadero.public.interbase.general
I would suggest you have a corrupted database. In that case, you should 
mend your database first. Here is an example of mending a database:

set isc_user=sysdba
set isc_password=masterkey
gfix -mend "path to database"

ken pfeiffer wrote:
> Able to run database validation successfully in Interbase XE3.
> BUT after that, attempting to backup database with gbak, it stalls on certain tables and then disconnects the DB connection.
> "connection to database lost"
> I am trying to backup and restore, but backup blows up. What can I do?
> Thanks for any help!
>

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 16-Jan-2015, at 2:43 PM EST
From: quinn wildman