Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Restoring dump file - cross platform and from 12.5.4 to ASE dev edition 15.03

2 posts in Backup and Recovery Last posting was on 2009-10-27 05:47:24.0Z
Anantha Posted on 2009-10-23 17:08:32.0Z
Sender: 729e.4ae1e07d.1804289383@sybase.com
From: Anantha
Newsgroups: sybase.public.ase.backup+recovery
Subject: Restoring dump file - cross platform and from 12.5.4 to ASE dev edition 15.03
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ae1e310.731d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Oct 2009 10:08:32 -0700
X-Trace: forums-1-dub 1256317712 10.22.241.41 (23 Oct 2009 10:08:32 -0700)
X-Original-Trace: 23 Oct 2009 10:08:32 -0700, 10.22.241.41
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4061
Article PK: 48149

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] Posted on 2009-10-27 05:47:24.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.backup+recovery
References: <4ae1e310.731d.1681692777@sybase.com>
In-Reply-To: <4ae1e310.731d.1681692777@sybase.com>
Subject: Re: Restoring dump file - cross platform and from 12.5.4 to ASE dev edition 15.03
Lines: 56
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ae6896c@forums-1-dub>
Date: 26 Oct 2009 21:47:24 -0800
X-Trace: forums-1-dub 1256622444 10.22.241.152 (26 Oct 2009 21:47:24 -0800)
X-Original-Trace: 26 Oct 2009 21:47:24 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4062
Article PK: 48150

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

"Anantha" wrote in message news:4ae1e310.731d.1681692777@sybase.com...
>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