Subject Re: Firebird Backups with Sweep
Author stevelw02
I actually initiated the command from within IBExpert. The only
option that was checked, as far as I can recall, was 'sweep'

--- In ib-support@y..., "Nick Upson" <uebridger@h...> wrote:
> what gbak command line did you use?
> >From: "stevelw02" <s.lee-woolf@s...>
> >Reply-To: ib-support@y...
> >To: ib-support@y...
> >Subject: [ib-support] Firebird Backups with Sweep
> >Date: Thu, 09 May 2002 14:49:17 -0000
> >
> >I recently needed to prune a large table (7 Million records) and
> >deleted approx 5 Million (they were fairly well distributed
> >throughout the table). Ti tidy everythiup, I initiated a database
> >backup (via GBAK) with the intention of doing a subsequent restore.
> >
> >The original table, before deletions, took an average of 25 minutes
> >to fully backup. The modified table has, so far, taken some 30
> >and, extrapolating the current rate forward, looks like it will
> >a further 14-16 hours to complete.
> >
> >Is this normal? It seems like a long time but I imagine that quite
> >bit of housekeeping is going on. Anyone got any thoughts? Thanks
> >
> _________________________________________________________________
> Join the world's largest e-mail service with MSN Hotmail.