当前位置: 代码迷 >> Sybase >> sybase数据库由windows2003跨平台导入xp出错,该如何解决
  详细解决方案

sybase数据库由windows2003跨平台导入xp出错,该如何解决

热度:8154   发布时间:2013-02-26 00:00:00.0
sybase数据库由windows2003跨平台导入xp出错
出错内容:
C:\Documents and Settings\Administrator>isql -Usa -P
1> load database baksgs from "D:\baksgs.bat"
2> go
Backup Server session id is: 16. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.177.2.1: The database page size of 2048 bytes obtained from ASE

is different from the database page size of 8192 bytes read from the dump
header. The LOAD session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD
session must exit.
Backup Server: 6.32.2.3: D:\baksgs.bat: volume not valid or not requested
(server: , session id: 16.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD
session must exit.
Msg 8009, Level 16, State 1:
Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for
details.
1>
>


请高手给个解决方法

------解决方案--------------------------------------------------------
dump文件是8K的,你的xp上的sybase页面大小为2k。必须相同页面大小的才能load上。
------解决方案--------------------------------------------------------
Backup Server: 4.177.2.1: The database page size of 2048 bytes obtained from ASE
is different from the database page size of 8192 bytes read from the dump

你原机上是 8192 ,本机上是 2048
主要是这个原因,和你的正版关系不大。
------解决方案--------------------------------------------------------
1,重新安装sybase数据库,设置页面大小为8k;或者新建数据库服务
2,通过bcp导入数据