--- In firebird-support@yahoogroups.com, Nando Dessena <nandod@d...>
wrote:

> Fred,
>
> f> If my database contains 50 tables owned by 'owner1' and 100

tables

> f> owned by 'owner2' and 75 tables owned by 'owner3', etc - how

can I

> f> backup/restore so that the tables all have their original

owners?

> f> If this is not possible with gbak, it is useless for disaster
> f> recovery.
>
> Sorry, I completely misunderstood you. I was thinking about the
> database owner, which gbak -c changes AFAIK. I always have a single
> owner for all database objects, so my mindframe is quite biased.
>
> I'm not sure what restore does of your original owners, but I guess
> you are right and it should preserve them (a simple test would

show,

> unfortunately I am away from any firebird at the moment).
>
> So, to recap: you had a database in shutdown mode but you don't

know

> if/when the gfix -shutdown command was issued. Then you brought it
> back on-line but discovered that gbak had changed all your

relation owners

> to the one you used to do the restore, right? Can you reproduce

this

> with a small sample database? I'm sure the developers would be
> interested.
>
> Ciao
> --
> Nando mailto:nandod@d...

Nando,
I am certain that no one issued a gfix -shutdown commmand. Perhaps
a gbak restore leaves the restored database in this state so that
the person doing the restore has a chance to do some single-user
type stuff before the database is brought on-line. I hope this is
the case because the alternative explanation is that there is subtle
corruption the the database and I have only seen the first symptom.
I do plan to do a series of test backup/restores on a much smaller
database in order to better understand what to expect.
We are planning to replace a number of 5 - 20 gb Informix OnLine
5.20 and IDS 7.31 databases with Firebird as soon as we can iron out
wrinkles such as these. I like Firebird very much and hope that we
can re-direct some of our $$$ going to IBM-Informix to the FB
Foundation.

Thanks,
Fred