Solved

sybase error : while loading database bad magic number

Posted on 2016-10-09
2
23 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
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Crystal Reports VB6 11 1,019
SyBase SQL Query Syntax 11 457
Alternative to ALTER in Sybase 1 389
Backing up Sybase database Server using Veeam 3 1,068
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
A Short Story about the Best File Recovery Software – Acronis True Image 2017
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

708 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

16 Experts available now in Live!

Get 1:1 Help Now