On Tuesday 22 March 2005 15:00, Daniel Rail wrote:

> Hi,
>
> At March 22, 2005, 07:52, Hannes Streicher wrote:
> >> In order to trim down the size of the database after deleting
> >> record, it is necessary to do a backup (With Garbage Collection),
> >> followed by a restore of
> >
> > if you do a restore, then there is no need for the garbae collection
>
> It's possible to omit garbage collection when performing a backup.

True.

> And, by not doing the garbage collection during backup, the garbage
> will also be backed up,

False.

> and when performing the restore with that
> backup, the garbage will also be restored.
>

False.


Garbage is never backed up, so it can't be restored. Disabling garbage
collection means time saved as old versions are not cleaned out of the
database. This speeds up the backup if the intention is to restore and
replace the existing database. If, however, the intention is just make an
archive and keep the existing database running the garbage collection is
a good housekeeping thing.

Don't forget that gbak is just a read-only snapshot transaction. It can't
see garbage any more than any other transaction.


Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase