All I wanted to do is simply to backup a database called "XYZ", and load it to a different machine (same environment). I use sybase 12.5 and got following message when backup:

1> dump database XYZ to "/home/data.dmp"
2> go
Backup Server session id is: 13. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 4.41.1.1: Creating new disk file /home/data.dmp.
Backup Server: 6.28.1.1: Dumpfile name 'troProd023610D17D' section number 1 mounted on disk file '/home/data.dmp'


I typed the following command for loading:

1> load database XYZ from "/home/data.dmp"
2> go

and I got error message saying that the server is expecting volumn 0001, but now get 1677097.

Can somebody please help me here?
Thank you very much!!!

Hiya Youngun,

I've never seen this happen, I think you are getting the wrong dump file

Do a listonly on the dmp file, you'll then see if the detail matches that of the backup server log when te dmp file got created.

1> load database XYZ from '/home/data.dmp' with listonly
2> go

Cheers
Willy