Hello.

Thank you for your detailed answer.

I have expressed myself unclear. Of course, I make daily a backup of the
database and test the backup, but I never had to restore the database -
because it would be corrupted. On Superserver 1.5 never are the transactions
are a problem, since for four weeks ago.

The follow options I have in my Manager:

Data transactions properties:
Snapshot
Read commited - selected
Read only table stability
Read write table stability

The self options I have in Metadate Transactions Properties, read commited
is selected too.

>Your deleted records remain "interesting" ( = Oldest Transaction) until
>there are no more transactions running that would potentially touch the
>records that were deleted. Their "stubs" will continue to occupy space on
>the pages for that table until all of those other transactions are HARD
>committed. If IBManager never performs HARD commits, then all of its
>transactions just keep being "interesting". :-)

Thank you, I have understand this.

The OIT is a completed transaction. The next one after that was the one that
is displayed as your Oldest Active transaction. It is still running, i.e.,
it has not been committed, nor rolled back.

>Just try it: SELECT * FROM ATABLE, followed by a HARD commit, will do it.
>(If IBManager doesn't offer a hard commit then use isql and provide your
>own COMMIT statement.)

Is this right, that this action commit all uncommitted transactions? Thanks.

>Can't tell what "the automatically backup" might be....

This is a windows task with gbak to make a backup. I have had a problem,
after I disconnect the network connections, the backup doesn't ends (with -g
switch, it does finish)

>From some things you have said, I wonder whether you are trying to read
>statistics while a backup or restore is running. I suggest you use the -v
>and -f switches on both backups and restores, so you have a record of what
>happens.

I have read the statistics before and after running backup/restore. One
time, the backup doesn't end (after I have disconnected the network adapter
to make a backup) and I have ended the gstat-task. After this, I have read
the statistics and tried the second way with -g switch.

I have realised many tasks and function with Firebird. I know I'm not so
good with the administration of firebird. But I will work to improve myself.

My projects are connected with ODBC to firebird. There are not many
opportunities.

Thanks for your friendly help