The garbage collection is only done on source database, the gbak file will
never containt 'garbage' records.
Sometimes I find that the quickest way to garbage collect is to shutdown to
single user mode, back up with out garbage collection, then restore and
restart the database.

-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: 28 February 2003 14:38
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] GBAK question


hmmm, then why is there no change in size to a garbage full database after a
gbak with garbage collection?

-----Original Message-----
From: Leyne, Sean (Ext. 225) [mailto:sleyne@...]
Sent: Saturday, 1 March 2003 1:33 AM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] GBAK question

> when you say yes helen, surely you do not mean that the
> remaing gdb file has
> had garbage removed. The option of garbage collection only
> removes garbage
> from the gbk file which is created... No?

No, Garbage Collection (GC) applies to the source database -- does the
GBAK operation force GC to occur for the records being backed up.

The amount of time which GBAK runs for will be longer for backups with
GC active, since the collection will occur before the data is returned
to the backup process.

The backup file will be of the exact same size regardless of whether GC
was active or not. Thus the restore time will also be the same.


Sean


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/






To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/