Subject Re: [ib-support] Database Size(after sweep)
Author Daniel Rail
You have to do a backup and then restore it to a new file as follows:

1. Do the backup
2. Rename your current database
3. Restore your backup to your database's original name.

This will also help in making sure that the data integrity of the database
is maintained. But, as you can see, you have to make sure that nobody is
connect to the database while you are performing this operation.

Hope this helps and have a nice day.

Daniel Rail
Senior System Engineer
ACCRA Med Software Inc. (

At 22/02/2001 15:36, you wrote:
>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
>Yahoo! Groups Sponsor
>Click here for
>To unsubscribe from this group, send an email to:
>Your use of Yahoo! Groups is subject to the
><>Yahoo! Terms of Service.