Orlando,

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.


Sean

> -----Original Message-----
> From: Orlando Jimenez [mailto:orlando_jimenez@...]
> Sent: Thursday, February 22, 2001 11:00 PM
> To: ib-support@yahoogroups.com
> 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

http://www.hotmail.com



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/