• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

sybase error : while loading database bad magic number

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
suzn cas
Asked:
suzn cas
1 Solution
 
BudDurlandCommented:
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
 
Joe WoodhousePrincipal ConsultantCommented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now