Hi,

What is the system log you're talking about?

As for the file size -- files cannot be made smaller. Simple as that. To
create a smaller size (in every application), the original file gets deleted
and a new file with new (smaller) data is created.

To do the same for a database file, you need to create a backup and restore
it. But there's no real need in a production environment: Firebird/InterBase
will re-use the empty space inside the (large) file - give it a try, insert
a lot of new records and you will notice that the file doesn't grow (or at
least not a lot).

--
Martijn Tonies
Upscene Productions

InterBase Workbench - The Developer Tool for InterBase
http://www.interbaseworkbench.com

"Experience is what you get when you didn't get what you wanted"

""Hellen Huang"" <hellen@ .com> schreef in bericht
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.
>
> 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?
>
> Thank's In Advance
>
> Hellen H.
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 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/
>
>
>