Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unanswered: URGENT -- Load database

    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: Creating new disk file /home/data.dmp.
    Backup Server: 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!!!

  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts