> Approximately how many tables do you have?

excluding metadata, approx...
120 tables
1600 fields
350 constraints
1140 triggers
140 procedures (so far)

> How big is the backup?

Original problem seen where the backup file was approx 250mb.

> Does this happen with a metadata backup,

Yes. Resulting backup file about 3.8Mb

> From your description, I think that the problem is serious
> and would like a chance to reproduce it.

At the moment the problem does not seem to result in any data loss,
but any error after backup/restore is of great concern.

> Any chance you could send me the backup?
> Absolutely no promises on schedule.

I will email you privately about this.

> The difficulty is not in the backup, it's in the restore.
> You have to be very careful of the order in which you restore
> data, triggers, & constraints. Easier, of course, if you know
> the database.

Is there any problem with just restoring the domains and table
structures (and perhaps primary keys) then restore the data and then
restoring everything else? Obviously there is still some order issues
with procedures but these are fairly easy to avoid.


Thanks for your interest.

Geoff Worboys
Telesis Computing