Discussion:
Restoring dump file - cross platform and from 12.5.4 to ASE dev edition 15.03
(too old to reply)
Anantha
2009-10-23 17:08:32 UTC
Permalink
Raw Message
I have a series of.dump files from the same db (the .dump
files are named as .Dump1of10 .Dump2of10 etc) that was on
solaris running ASE version 12.5.4. I'm trying to restore
these .Dump files on to my ASE dev edition version 15.0.3.

I tried restoring in 2 ways and following are the steps I
took and the error messages I got

Mentod 1: Restoring by right clicking an empty db

Step 1: Created an empty db
Step 2: Right clicked this db and selected restore and then
selected restore the entire database
Step 3:For selecting the dump device, I chose 'Explicit Dump
Device" and specified the path where the .Dump files exist
Note: did not specify any backup name
When I click "Finish" I get the error below
----------------------------------------------------------
-- test Restore Messages
----------------------------------------------------------
Backup Server session id is: 153. Use this value when
executing the 'sp_volchanged' system stored procedure after
fulfilling any volume change request from the Backup Server.
Backup Server: 4.135.2.1: Invalid Device: you cannot dump to
or load from a directory, 'I:\MLARS\VRP'.
Error encountered by Backup Server. Please refer to Backup
Server messages for details.

Mentod 2: Restoring by executing Load database
Step 1: Excuted the command load database test from
"I:\MLARS\VRP\VRP.dump"

Got the error message below

Could not execute statement.
Error encountered by Backup Server. Please refer to Backup
Server
messages for details.
Sybase error code=8009
Severity Level=16, State=1, Transaction State=0
Line 1

load database test from "I:\MLARS\VRP\VRP.dump"

Please help
"Cory Sane [TeamSybase]" <cory!=sane>
2009-10-27 05:47:24 UTC
Permalink
Raw Message
Are you switching to Windows?
Is VRP.dump the new file name on Windows?
DID you use BINARY mode when transferring the files? (text mode is common mistake)
There should be more information in the backupserver log file.
--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0
Post by Anantha
I have a series of.dump files from the same db (the .dump
files are named as .Dump1of10 .Dump2of10 etc) that was on
solaris running ASE version 12.5.4. I'm trying to restore
these .Dump files on to my ASE dev edition version 15.0.3.
I tried restoring in 2 ways and following are the steps I
took and the error messages I got
Mentod 1: Restoring by right clicking an empty db
Step 1: Created an empty db
Step 2: Right clicked this db and selected restore and then
selected restore the entire database
Step 3:For selecting the dump device, I chose 'Explicit Dump
Device" and specified the path where the .Dump files exist
Note: did not specify any backup name
When I click "Finish" I get the error below
----------------------------------------------------------
-- test Restore Messages
----------------------------------------------------------
Backup Server session id is: 153. Use this value when
executing the 'sp_volchanged' system stored procedure after
fulfilling any volume change request from the Backup Server.
Backup Server: 4.135.2.1: Invalid Device: you cannot dump to
or load from a directory, 'I:\MLARS\VRP'.
Error encountered by Backup Server. Please refer to Backup
Server messages for details.
Mentod 2: Restoring by executing Load database
Step 1: Excuted the command load database test from
"I:\MLARS\VRP\VRP.dump"
Got the error message below
Could not execute statement.
Error encountered by Backup Server. Please refer to Backup
Server
messages for details.
Sybase error code=8009
Severity Level=16, State=1, Transaction State=0
Line 1
load database test from "I:\MLARS\VRP\VRP.dump"
Please help
Loading...