Hello.

I've a little problem with my firebird database. The classicserver 2.01 is
running on a quad core machine, 4 GB RAM, Windows 2003 Server.

Yesterday, I have deleted much old data on any tables taken with my IB
Manager. After this, the database works fine again. I have made a backup
copy - without any problems.

But the statistics of my database (gbak -h) looks not good. A hour later,
the same problem. The oldest transaction: 4000 and the next transaction:
119000- rising. I have thought that I can clear the problem with
backup-restore. All connections I have closed, and then I have disabled my
network adapter, that no user can connect to my database.

With my EMS-Manager I have access over 127.0.0.1, although it is no active
connection available. But now, the backup-cycle does not end. Gbak does run
and run, but with no result. (With the -g switch manually, it does work)

But, after I have tried a backup, the statistics were fine! The two counters
had nearly no difference! But I could no longer access the database.

Result: After I have disabled my network connection, the database cannot
backup, does not work again after running backup, but the statistics are
good. I had an old backup restored.

Now, I have these questions:

Can any one help me, what's the problem? Thousands records I have deleted,
but the next transactions-counter stopped. Also, when I have closed my
EMS-Manager and commit after every step.

It there a problem with disabled network connection? Does the database
damage? Why does gbak only works with this -g switch after this - so in my
case?

After I restart the firebird-serviced (classic server), I have no access to
my database. What can it be?

Thanks for your help. In this way, also many thanks to mr Streicher for your
friendly help.

With best regards

Olaf Kluge