Subject Re: GBAK Restore hangs Firebird 1.5 before finishing and going home
Author davidrevill69
As you say, garbage collection is not an issue for the restore, so
what is it doing just before finishing and going home which might
cause the server to become unresponsive ? The restored database is no
being accessed by any other application

--- In, Helen Borrie <helebor@...>
> At 07:53 PM 14/08/2006, you wrote:
> >I am unsure of the significance of the -g switch on
> >a restore. If the backup was run with garbage collection on , what
> >garbage is there for the restore process to tidy up?
> It's simply a non-issue for the restore. Gbak doesn't back up
> garbage. What it does do for the database, by accessing every
> (by default, unless you switch it off using the -g switch), is kick
> off garbage collection of all tables.
> >The restore completes successfully on an apparently identical
> >server using the same backup file, but on our live server Fbserver
> >apprears to be doing nothing (for serveral hours) and cannot be
> >stopped
> If the live server is accumulating tonnes of garbage that's not
> cleaned out any other way, then it's to be expected.
> If you plan to restore the database anyway, use the -g switch.
> pointless garbage-collecting on a database that you are about to
> delete. Just don't do anything silly like using your restore to
> overwrite your database....
> ./heLen