Subject RE: [ib-support] Database Size(after sweep)
Author Leyne, Sean

I have to be honest and say that I think you're confusing the sweep
function/opration and performing a database backup/restore.

IB database only releases disk space back to the OS through a backup and
restore -- this has been true throughout my experience with IB (which
goes back to v4.0).

Accordingly, a sweep does not change the database filesize -- which is
the effect your are seeing.


> -----Original Message-----
> From: Orlando Jimenez [mailto:orlando_jimenez@...]
> Sent: Thursday, February 22, 2001 11:00 PM
> To:
> Subject: [ib-support] Database Size(after sweep)
> Hi to all,
> I'm new in interbase 6.0, and I remeber that in interbase 5.1:
> if I had initially, my database size was 3MB(approximately),
> until here, all
> is very well.(with interbase 6.0)
> I work in my database(inserting, updating, deleting, ....)...
> my database
> size grew up to 10MB...
> (still, until here, all is very well).
> Then, I do a 'truncate table mytable', then I used the sweep
> command in IB
> Console, and my database go back to the size that have
> originally(3MB), but
> in interbase 6.0 size until is 10MB.
> In interbase 5.1, I remeber, that when I did a sweep, over my
> database, the
> database size was of the original size again, but with
> interbase 6.0 doesn't
> happen this way.
> what can I do for my database be of the initial size?
> (only the gbak is the option?)
> Thanks in advance.
> ______________________________________________________________
> ___________
> Get Your Private, Free E-mail from MSN Hotmail at

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to