Restoring dump file - cross platform and from 12.5.4 to ASE dev edition 15.03
Anantha
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]
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
"Anantha" wrote in message news:4ae1e310.731...@sybase.com...