--- In firebird-support@yahoogroups.com, "Craig" <cstevens@d...>
wrote:

>
> --- 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!

To be safe, at the first oportunity, shutdown the Firebird service,
rename the database file, then make a file copy of it, then rename it
back.

> 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???
>

If you like, send it to my yahoo address which is my username here at
yahoo dot com. The other thing to do is to check whether your backup
is transportable. This is important if you are switching between
systems with different endians, but if everything is Windows etc,
then I doubt this will be the case.

Adam