Subject Re: Unsuccessful MetaData Update
Author Craig
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
>
> At 05:51 AM 28/11/2005 +0000, you wrote:
> >Hi All,
> >
> >I have a situation occuring with a backup from a production database.
> >If i try to restore the database onto my machine i get the following
> >error -
> >
> >Unsuccessful MetaData Update
> > Catalogue <=== Table name in the database
> >exiting before completion due to errors
> >
> >
> >the same thing occurs on another machine, but the third machine
> >restores ok...
> >
> >Can anyone suggest reason and fix
>
> Try to recreate it using the -verbose option. Then you might find
out more
> about what metadata it was trying to update for that table and possibly
> even why it couldn't perform the update....
>
> ./heLen.
>
>
> >Using firebird V1.5.2 CS
> >
> >Thanks
> >Craig
>

Helen, did the verbose and this did not elude to much, i removed the
table the restore complained about but this simply moved it to the
next table. One theory is that the database was created with a
different user/password, but attempting to restore on a different FB
machine using the sysdba/password still encounters the errors. I
created a new database from the code and ensured the id/password was
correct, this new database i was able to restore, which adds weight to
the issue being database ownership, are there ways of checking
database ownership using the tools like isql, gstat etc..

Thanks
Craig