本人在学习sybase 数据库,在练习升级数据库时遇到此问题,请高手指点,谢谢.

在win2k电脑上dump 数据库后拷贝到xp电脑上直接load出错
版本:
win2K:Adaptive Server Enterprise/11.9.2.6/1290/P/EBF
xp系统:Adaptive Server Enterprise/12.5.3/EBF 13331

恢复:
load database wumaster from 'f:\wumaster.dat'
提示:
Server Message:  Number  3216, Severity  10
Server 'TTT', Line 1:
Backup Server session id is:  28.  Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message:  Number  602801, Severity  1
Server 'TTT_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.28.1.1: Dumpfile name 'umaster0701111FFC' section number 1 mounted on disk file 'f:\wumaster.dat'
Server Message:  Number  3120, Severity  16
Server 'TTT', Line 1:
The database you are attempting to LOAD was DUMPed under a different sort order ID (42) or character set ID (2) than the ones running on this server (SortOrd = 50, CharSet = 2). If the sort orders differ, at least one of them is non-binary.

[ 本帖最后由 liao_feng 于 2008-9-3 11:36 编辑 ]

字符集或排序方式不同，在原Server上执行sp_helpsort，然后照着改，在load

问题解决,谢谢
把两个字符集不同的库都恢复了,adv可以查,提示索引有问题不能正常使用

dbcc reindex