2,596
社区成员
发帖
与我相关
我的任务
分享sybase 备份 恢复问题
请问怎么解决
1> load database branch60 from "e:\data_bak\branch60_bak.dat"
2> go
Backup Server session id is: 9. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'ranch601228207AB2' section number 1
mounted on disk file 'e:\data_bak\branch60_bak.dat'
Msg 3120, Level 16, State 1:
Server 'JBZXSERVER', Line 1:
The database you are attempting to LOAD was DUMPed under a different sort order
ID (39) 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.
1> load database branch60 from "e:\data_bak\branch60_bak.dat"
2> go
Backup Server session id is: 9. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'ranch601228207AB2' section number 1
mounted on disk file 'e:\data_bak\branch60_bak.dat'
Msg 3120, Level 16, State 1:
Server 'JBZXSERVER', Line 1:
The database you are attempting to LOAD was DUMPed under a different sort order
ID (39) 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.
...全文
请发表友善的回复…
发表回复
TBNoO 2012-10-19
- 打赏
- 举报
或者使用以下语句进行配置，测试下：
sp_configure "default character set id",characterid
sp_configure "default sortorder id",sortorderid
sp_configure "default character set id",characterid
sp_configure "default sortorder id",sortorderid
TBNoO 2012-10-19
- 打赏
- 举报
试试运行syconfig.exe，进入配置服务器=> 语言=> 排序顺序=> 设置缺省=> (选择以前备份库的排序方式)
参考贴子：
http://topic.csdn.net/t/20040814/08/3273361.html
参考贴子：
http://topic.csdn.net/t/20040814/08/3273361.html
mtxn2004 2012-10-19
- 打赏
- 举报
楼上你这属于恶意回复吧。。。
千娜 2012-10-19
- 打赏
- 举报
拔电源 重新启动
iihero 2012-10-14
- 打赏
- 举报
备份的库使用的是不同的字符集。
要想正确使用，当前的ASE Server调整成相同的字符集即可。
要想正确使用，当前的ASE Server调整成相同的字符集即可。
