Danny García Hernández wrote:

> We have a big database with a lot of SP, some of them are using PLAN syntax
> to speed up selections. I don´t know the reason, but in rare situations,
> one or some proccess corrupt this
> index used into SP´s PLAN and the database become unrestorable
> ...

Are you using system generated indexes? The names for these will (more
than likely) change when you restore (they are - as A.V.N. said - created,
not restored).

--
Aage J.