Ivan Prenosil wrote:

> > For the second time the backup of our 3G Firebird 1.0.3 database has
> > been corrupted.
>
> * Any messages during restore ?

Only on the 1.5 restore

> * Any messages in firebird.log file ?

No

> * Have you tried both transportable and non-transportable backup ?

Only transportable so far

> * Have you tried restore "one table at a time" or deactivate indexes
> during restore ?

No, but I don't really know how to do one table at a time - I'll try
deactivating the indexes if it happens again.

> * Do you have enough space on disks where database and temporary files
> reside ?

30GB free.

> * Perhaps some viruses or antiviruses can interfere ?

Linux.

> * Somebody (or some application) is trying to connect during restore ?

Impossible - restore is to a unique filename.

> * Do not you use some tools that directly modify system tables ?

iboconsole, but no changes had been made for a while

>
>
> > All tables in the restored database then appear empty
> > i.e. result sets from selects are empty and the roles have disappeared.
>
> So not only data but also metadata are missing ???

Tables and table structures are there - no data.

>
> * Have you tried metadata only backup ? What is the result ?
>

Not yet. I think Alexander has the most likely explanation - a corrupt
index.

> Ivan

Thanks Ivan.