Problem when restore a dump file to databae

[Bill Lui]

Dear all,

When I try to restore the database from a dump, the following error message
shown, please help.

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.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.
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: c:\Test.dump: volume not valid or not requested
(server: , session id: 13.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or
LOAD session must exit.
Error encountered by Backup Server. Please refer to Backup Server messages
for details.

Thanks in advance,

Bill Lui

[Mark A. Parsons]

What's the full text of the dump/load command you issued?

Also, have you verified that your dump file (c:\test.dump) actually exists?

Post by Bill Lui
Dear all,
When I try to restore the database from a dump, the following error message
shown, please help.
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.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.
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: c:\Test.dump: volume not valid or not requested
(server: , session id: 13.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or
LOAD session must exit.
Error encountered by Backup Server. Please refer to Backup Server messages
for details.
Thanks in advance,
Bill Lui

[Bill Lui]

Mark,

Thanks for your attention. My command is : LOAD DATABAES test FROM
"c:\test.dump" and then I am sure the test.dump file at c drive root
directory.
Do you have any solution??

Thanks in advance,

Bill Lui

Post by Mark A. Parsons
What's the full text of the dump/load command you issued?
Also, have you verified that your dump file (c:\test.dump) actually exists?

Post by Bill Lui
Dear all,
When I try to restore the database from a dump, the following error
message shown, please help.
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.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.
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: c:\Test.dump: volume not valid or not requested
(server: , session id: 13.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or
LOAD session must exit.
Error encountered by Backup Server. Please refer to Backup Server
messages for details.
Thanks in advance,
Bill Lui

[Bill Lui]

Mark,

Thanks for your attention. My command is : LOAD DATABAES test FROM
"c:\test.dump" and then I am sure the test.dump file at c drive root
directory.
Do you have any solution??

Thanks in advance,

Bill Lui

Post by Mark A. Parsons
What's the full text of the dump/load command you issued?
Also, have you verified that your dump file (c:\test.dump) actually exists?

Post by Bill Lui
Dear all,
When I try to restore the database from a dump, the following error
message shown, please help.
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.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.
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: c:\Test.dump: volume not valid or not requested
(server: , session id: 13.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or
LOAD session must exit.
Error encountered by Backup Server. Please refer to Backup Server
messages for details.
Thanks in advance,
Bill Lui

[Michael Peppler]

Post by Bill Lui
Dear all,
When I try to restore the database from a dump, the following error
message shown, please help.
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.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.

It looks like the dump file is corrupted.

Are you sure that this is a Sybase database dump?
What version of Sybase was used to create the dump, and what version fo
Sybase is used for the load?

Michael

[a***@anacomp.com]

The 'compress' command was new in 12.?? and I believe if the dump was
initiated with the compress statement, then you need it in the load
statment.

load database DBNAME
from 'compress::c:/test/DBNAME'

Post by Michael Peppler

Post by Bill Lui
Dear all,
When I try to restore the database from a dump, the following error
message shown, please help.
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.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.

It looks like the dump file is corrupted.
Are you sure that this is a Sybase database dump?
What version of Sybase was used to create the dump, and what version fo
Sybase is used for the load?
Michael
--
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html

[Etienne]

Didn't you create the dump with the "compress" option?

Post by Michael Peppler

Post by Bill Lui
Dear all,
When I try to restore the database from a dump, the following error
message shown, please help.
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.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.

It looks like the dump file is corrupted.
Are you sure that this is a Sybase database dump?
What version of Sybase was used to create the dump, and what version fo
Sybase is used for the load?
Michael
--
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html