Subject RE: [ib-support] Re: Firebird Backups with Sweep
Author Wilson, Fred
Sounds like just a ton of garabage collection going on. Next time, if you
plan on doing a restore also, run gbak with the No Garabage Collection flag.
No reason to do the garabge collection if you're going to turn around and
immediately restore the backup.
We did some testing here a couple of years ago and found it much faster,
actually, to do a backup (no garbage collection) and then restore, than to
do a sweep of a large database that had a lot of insertions and deletions

Fred Wilson
SE, Bell & Howell

-----Original Message-----
From: stevelw02 [mailto:s.lee-woolf@...]
Sent: Thursday, May 09, 2002 8:21 AM
Subject: [ib-support] Re: Firebird Backups with Sweep

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.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to