Solved

while loading a sybase backup

Posted on 2009-03-30
3
643 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now