Solved

sybase error : while loading database bad magic number

Posted on 2016-10-09
2
121 Views
Last Modified: 2016-10-10
Dears,
I got the following error when I was loading a database as usual:

 Volume validation error: bad magic number 0ءّ, expected USTH.

is it because I try to load dump from sybase ase 15.7 onto ase 15.0.3 ??
I read some thing like this :
The 'bad magic number' is usually raised when you attemp to load a backup with and older version of the backupserver than then backserver that made the backup

Loading database from higher version to lower version is possible but we can't use higher version features in this way.

I was sure the oposit is the right case i.e we can load dump from older version onto higher, but cannot load dump from higher version.
advice please.
0
Comment
Question by:suzn cas
[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
2 Comments
 
LVL 17

Expert Comment

by:BudDurland
ID: 41836265
How are you migrating the data?  Are you doing a backup and trying to ready the backup with the other version, or are you doing a DBUNLOAD / DBLOAD process.  When changing version (up or down), DBUNLOAD / DBLOAD is preferred.
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 total points
ID: 41836345
Sorry, the advice you read is wrong and what you thought is correct.

We cannot dump from a higher version and load into a lower version. This is straight out of the manuals.

Lower version to higher version is fine, and it will try to upgrade when you bring the database online. Upgrade-during-load has been stable for many years now and for any healthy database (i.e. no corruption) it works fine.

For what you're trying to do you will need some kind of physical rebuild, bcp out, scripts to recreate every object, and bcp in.
1

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

There is a lot to be said for protecting yourself and your accounts with 2 factor authentication.  I found to my own chagrin, that there is a big downside as well.
Article by: Justin
In light of the WannaCry ransomware attack that affected millions of Windows machines, you might wonder if your Mac needs protecting. Yes, it does and here is how to do it.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

695 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