Hi all,

I want to load a database dump but got the following error, could
anyone please help? Thanks a lot.

Backup Server session id is: 5. 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 8192 bytes
obtained from ASE is different from the database page size of 2048
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: /tmp/sytsdb.dump: volume not valid or not
requested (server:, session id:5.)
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:
Server 'se3pc09', Line 1:
Error encountered by Backup Server. Please refer to Backup Server
messages for details.


Thanks.

The dump file comes from a database with a 2k page size. You're
trying to load it to a database with an 8k page size. Won't work.
Your options are to use bcp to copy the data row by row (instead of
loading a dump, which works page by page), or create a database with a
2k page size to load the dump into.