dbTalk Databases Forums  

I have a database file (*.db) that need to be recovered.

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


Discuss I have a database file (*.db) that need to be recovered. in the sybase.public.sqlanywhere.general forum.



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

Default I have a database file (*.db) that need to be recovered. - 02-22-2010 , 09:50 PM






I have a database file (*.db) that need to be recovered.

The bad is, the end-user have null idea of the version of the
database. Not know the password. The original developer is lost. The
computer where was installed was formatted. We have not experience in
this database software. Yeah, nightmare.

My guess is a old database. I'm trying to open it in Sybase 11, dev
edition.

I follow this steps: http://dcx.sybase.com/1101en/sachang...newjasper.html

I try to use the UNLOAD utility from command line & from the Sybase
central utility. From command line I do:

../dbinfo -c "DBF=/Users/mamcx/Downloads/
CEMDE_ENDOCRINO_S.A.DB;UID=DBA;PWD=sql"
SQL Anywhere Information Utility Version 11.0.1.2045 Unable to start
specified database: '/Users/mamcx/Downloads/CEMDE_ENDOCRINO_S.A.DB'
was created by a different version of the software

Ok, I try to unload:

../dbunload -c "DBF=/Users/mamcx/Downloads/
CEMDE_ENDOCRINO_S.A.DB;UID=DBA;PWD=sql"
-n /Users/mamcx/Desktop/ SQL Anywhere Unload Utility Version
11.0.1.2045 Connecting and initializing
***** SQL error: Unable to start database server
Ok, from the server admin tool:

dbunload -v -c "UID=dba;PWD=***;DBF=/Users/mamcx/Downloads/
CEMDE_ENDOCRINO_S.A.DB" -an "/Users/mamcx/Desktop/baba.db" -ap 4096 -
ea None -ii -sa -so _sc866192545
Connecting and initializing
***** SQL error: Unable to start database server
An error occurred while attempting to unload the database '/Users/
mamcx/Downloads/CEMDE_ENDOCRINO_S.A.DB'.

Exist a way to know the version of the database server used to create
this? Is possible to recover this file?

P.D. The original question at
http://stackoverflow.com/questions/2...now-db-version

Reply With Quote
  #2  
Old   
dantheguy
 
Posts: n/a

Default Re: I have a database file (*.db) that need to be recovered. - 03-23-2010 , 09:09 AM






On Feb 22, 10:50*pm, mamcx <ma... (AT) elmalabarista (DOT) com> wrote:
Quote:
I have a database file (*.db) that need to be recovered.

The bad is, the end-user have null idea of the version of the
database. Not know the password. The original developer is lost. The
computer where was installed was formatted. We have not experience in
this database software. Yeah, nightmare.

My guess is a old database. I'm trying to open it in Sybase 11, dev
edition.

I follow this steps:http://dcx.sybase.com/1101en/sachang...eloading-upgra...

I try to use the UNLOAD utility from command line & from the Sybase
central utility. From command line I do:

./dbinfo -c "DBF=/Users/mamcx/Downloads/
CEMDE_ENDOCRINO_S.A.DB;UID=DBA;PWD=sql"
SQL Anywhere Information Utility Version 11.0.1.2045 Unable to start
specified database: '/Users/mamcx/Downloads/CEMDE_ENDOCRINO_S.A.DB'
was created by a different version of the software

Ok, I try to unload:

./dbunload -c "DBF=/Users/mamcx/Downloads/
CEMDE_ENDOCRINO_S.A.DB;UID=DBA;PWD=sql"
-n /Users/mamcx/Desktop/ SQL Anywhere Unload Utility Version
11.0.1.2045 Connecting and initializing
***** SQL error: Unable to start database server
Ok, from the server admin tool:

dbunload -v -c "UID=dba;PWD=***;DBF=/Users/mamcx/Downloads/
CEMDE_ENDOCRINO_S.A.DB" -an "/Users/mamcx/Desktop/baba.db" -ap 4096 -
ea None -ii -sa -so _sc866192545
Connecting and initializing
***** SQL error: Unable to start database server
An error occurred while attempting to unload the database '/Users/
mamcx/Downloads/CEMDE_ENDOCRINO_S.A.DB'.

Exist a way to know the version of the database server used to create
this? Is possible to recover this file?

P.D. The original question athttp://stackoverflow.com/questions/2314919/how-recover-sybase-databas...
I would try running strings against it and see if the version is
embedded in the database file. Not sure about how to recover without
the password though. I ran it against one that was created in 9 and
found the 9.0.2.3480, but I'm not sure if all versions have it or not.

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.