dbTalk Databases Forums  

unload not working -- cannot upgrade db

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss unload not working -- cannot upgrade db in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Doug Stone
 
Posts: n/a

Default unload not working -- cannot upgrade db - 08-25-2009 , 10:23 AM






Hi. I am moving a customer from sqla8 to sqla11.
When I run dbunload, thru SC, I see the following text...

Quote:
dbunload -v -c "UID=dba;PWD=***;DBF=C:\resq\resqwin\resqprod\db\r esq.db" -r
"c:\resq\resqwin\resqprod\db\reload.sql" -ii -sa -so _sc608242113
"c:\resq\resqwin\resqprod\db\unload"
Connecting and initializing
***** SQL error: Unable to start specified database: autostarting database
failed
An error occurred while attempting to unload the database
'C:\resq\resqwin\resqprod\db\resq.db'.
<<<<<<<<<<<<<<<<

The database was taken from a backup folder.
There are two files: resq.db and resq.log

Any suggestions?

Thanks,
Doug

Reply With Quote
  #2  
Old   
Nick Elson [Sybase iAnywhere]
 
Posts: n/a

Default Re: unload not working -- cannot upgrade db - 08-25-2009 , 10:40 AM






You need to run with the V11 dbunload with the -an swtich;
which I don't see there. The use of -r is a manual style
rebuild and the main indication of not picking the
correct option for this.

V10 and V11 needs to do this rebuild and can do it
for you .... iff you specify

"Unload and reload into a NEW database"

{at step 8 in the link below. Thats the 2nd pick
in the wizard, you seem to have taken the first
one}

from Sybase Central or using dbunload -an
explicitly from the cmdline.

http://dcx.sybase.com//1101en/sachan...newjasper.html

"Doug Stone" <doug.stonenospam (AT) res-q (DOT) com> wrote

Quote:
Hi. I am moving a customer from sqla8 to sqla11.
When I run dbunload, thru SC, I see the following text...


dbunload -v -c
"UID=dba;PWD=***;DBF=C:\resq\resqwin\resqprod\db\r esq.db" -r
"c:\resq\resqwin\resqprod\db\reload.sql" -ii -sa -so _sc608242113
"c:\resq\resqwin\resqprod\db\unload"
Connecting and initializing
***** SQL error: Unable to start specified database: autostarting database
failed
An error occurred while attempting to unload the database
'C:\resq\resqwin\resqprod\db\resq.db'.


The database was taken from a backup folder.
There are two files: resq.db and resq.log

Any suggestions?

Thanks,
Doug

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.