while loading a sybase backup

i loaded a sybase backup successfully and when i wrote online database command the following error came :cannot run query referenced object <name NAME not recoverable> dropped during query optimisation msg:3461 and cannot install the required upgrade item 1408 msg:3451.can any one help me out .
vijay11Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
vijay11Connect With a Mentor Author Commented:
i got the solution first i deleted statistics and then up date them
0
 
Joe WoodhousePrincipal ConsultantCommented:
Are you loading the backup into the same ASE you took it from? It sounds like it's trying to do an upgrade. What are your source and destination ASE versions?
0
 
bretCommented:
Sounds like you may be hitting CR 312518, a problem with values stored in sysstatistics.  This was fixed in 12.5.0.3 ESD #2, so if you are trying to load into 12.5.x lower than that, try applying a more recent rollup.  The other workaround would be to clear out the statistics for system tables on the source database using the DELETE STATISTICS command, dumping and loading again, then rerunning update statistics.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.