Solved

while loading a sybase backup

Posted on 2009-03-30
3
648 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Changing a few Outlook Options can help keep you organized!
Determining the an SCCM package name from the Package ID
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scannerā€¦
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decadeā€¦

737 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