--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:

>
> --- In firebird-support@yahoogroups.com, "Craig" <cstevens@d...>
> wrote:
> >
> > --- In firebird-support@yahoogroups.com, Alexandre Benson Smith
> > <iblist@t...> wrote:
> > >
> > > Craig wrote:
> > >
> > > >Hi Anyone who could help?
> > > >
> > > >I have a production database which will restore only on the
> production
> > > >machine and the original design machine, but not to two other
> > > >development machines. Each time its comes up with unsuccessful
> > > >metadata update. I have a 9k metadata only backup i would be
> willing
> > > >to send to anyone who would like to attempt to restore this
> file.
> > > >
> > > >Thanks
> > > >Craig
> > > >cstevens@d...
> > > >
> > > >
> > > Craig,
> > >
> > > What errors did you get ?
> > >
> > > Maybe some missing UDF ???
> > >
> > > see you !
> > >
> > > --
> > > Alexandre Benson Smith
> > > Development
> > > THOR Software e Comercial Ltda
> > > Santo Andre - Sao Paulo - Brazil
> > > www.thorsoftware.com.br
> > >
>
> Craig,
>
> Does the backup fail process, or is it the restore of the backup
> file? If it is the restore process, are you able to restore that file
> on the machine you took the backup from? If not, I suspect it is a a
> stored procedure call from within another stored procedure, where the
> calling parameters have been changed since the BLR was compiled.
> (Happenned once). Restoring with the -v switch, you should be able to
> identify which stored procedure is giving you grief, then look for
> other procedures where it is called from. Fix the stored procedures
> so they are compiled with the correct parameters, and try again.
>
> Of course I may be totally on the wrong track.
>
> Adam
>

hi Adam, i appreciate the input, in aswer to some vital questions, the
backup and restore process work fine on the production server machine.
Restoring this backup file onto my own machine does not work, and as
far as i know there are no stored procedures calling any other stored
procedures. i will check the stored procedure situation regardless
just to be sure, my concern is i have a production database that can
only restore on the production server, what if my production server
machine goes POP! and i cant restore it to another machine, having a
backup file does not help if it cannot be restored on multiple
machines. If you can suggest anything further im listening..or would
you like to have a crack at restoring the file, i have a 9k metadata
only backup???

Craig