Subject Re: [ib-support] SHRINK SIZE DATABASE
Author Claudio Valderrama C.
""Hellen Huang"" <hellen@...> wrote in message
news:000e01c1cac0$a72a8dc0$3a50a8c0@......
> Dear All,
>
> 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.

What's the system log for you?
There's an interbase.log file that simply keeps some operational messages
and errors. There's no separate transaction log. You can simply delete
interbase.log from time to time.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing