Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

while loading a sybase backup

Posted on 2009-03-30
3
Medium Priority
?
651 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

618 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