Adam wrote:

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

Adam,

I think that it have something to UDF because he said it could restore
ONLY on the production machine, and that the restore fails on other
machines.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br