Subject Re: [ib-support] SHRINK SIZE DATABASE
Author Svein Erling Tysvær
>I was delete all data in the database, except master data, but I noticed that
>the size didn't shrink. When I execute my sql. the system log ws getting
bigger.
>Can anyone tell me how to shrink the system log and database size and please
>tell me why it won't shrink when I deleted all data?

I can answer one of your questions Hellen. The database never release space
once allocated. Rather, it marks the records as deleted and reuse the space
when you insert new data. To reclaim the physical space for use outside of
your database, I think you have to backup and restore.

I know nothing about the system log, so that's for someone else to answer.

HTH,
Set