Hi all,

I use Firebird 2 [single file] in my app. This app mostly works with
blob data and use triggers other than the trivial database jobs. At
application exit, all the data in all tables are cleared. My problem
is that the database file somehow got bigger and bigger [7mb] as the
time goes despite all data being removed by the application exit.

For a solution, first I tried a database sweep via IBOConsole but that
didn't do the trick. Then I tried to make a backup for the database
with IBOConsole as recommended but then the created backup database
file is an invalid database file.

SoI wanna ask:
1. what is going on with the inflation?
2. why does the sweep not work?
3. what am I doing wrong to get a corrupted backup?

Regards,
M. Utku Karataş.