Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

URGENT --- Load database

Status
Not open for further replies.

youngun

Programmer
Apr 27, 2001
61
US
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!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top