Solved

while loading a sybase backup

Posted on 2009-03-30
3
645 Views
Last Modified: 2012-05-06
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 .
0
Comment
Question by:vijay11
3 Comments
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 24023957
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
 
LVL 10

Expert Comment

by:bret
ID: 24030366
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
 

Accepted Solution

by:
vijay11 earned 0 total points
ID: 24056125
i got the solution first i deleted statistics and then up date them
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Troubleshooting common task sequence error codes
Read about the ways of improving workplace communication.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question