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

    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: 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!!!

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    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

Posting Permissions

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