dbTalk Databases Forums  

Database File Corrupted, need help

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


Discuss Database File Corrupted, need help in the sybase.public.sqlanywhere.general forum.



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

Default Database File Corrupted, need help - 10-05-2009 , 08:21 AM






One customer database was corrupted, tried all the SQL
Anywhere command and still cannot make it work. The error is
this file is not a database file. Opened by work pad and
checked it is database for sure. Unfortunately they don't
have the log file. The SQL Anywhere version is 5.
Does anybody have idea how to fix it? Does anybody know what
the database file format is? Maybe so I can fix the header
manually.
Thanks

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

Default Re: Database File Corrupted, need help - 10-06-2009 , 03:07 AM






To start when you have not the log create a bat file with

path1\DBENG50 path2\dbname.db -f
pause

I you edit with an Hex editor, can you see the header?

Claude

<Myron> a écrit dans le message de news:
4ac9f2c7.4b0e.1681692777 (AT) sybase (DOT) com...
Quote:
One customer database was corrupted, tried all the SQL
Anywhere command and still cannot make it work. The error is
this file is not a database file. Opened by work pad and
checked it is database for sure. Unfortunately they don't
have the log file. The SQL Anywhere version is 5.
Does anybody have idea how to fix it? Does anybody know what
the database file format is? Maybe so I can fix the header
manually.
Thanks

Reply With Quote
  #3  
Old   
Myron
 
Posts: n/a

Default Re: Database File Corrupted, need help - 10-07-2009 , 10:50 AM



Claude,
Thank you very much for help. But I still cannot open the db
file.
I opened the file by binary mode, and found the header is
different with other files. I tried to copy and fix the
first two rows. After that, the dbinfo command was working,
but cannot open by dbeng50, the error is "page count is
wrong". So I think if I know the format, maybe I can fix it
manually.
Do you have any ideas?
Myron


Quote:
To start when you have not the log create a bat file with

path1\DBENG50 path2\dbname.db -f
pause

I you edit with an Hex editor, can you see the header?

Claude

Myron> a écrit dans le message de news:
4ac9f2c7.4b0e.1681692777 (AT) sybase (DOT) com...
One customer database was corrupted, tried all the SQL
Anywhere command and still cannot make it work. The
error is this file is not a database file. Opened by
work pad and checked it is database for sure.
Unfortunately they don't have the log file. The SQL
Anywhere version is 5. Does anybody have idea how to fix
it? Does anybody know what the database file format is?
Maybe so I can fix the header manually.
Thanks


Reply With Quote
  #4  
Old   
Chris Keating (Sybase iAnywhere)
 
Posts: n/a

Default Re: Database File Corrupted, need help - 10-07-2009 , 12:31 PM



You don't have the tools and knowledge of the database file needed to
patch the database sufficiently to do a data salvage. In the absence of
a backup and recovery plan, you may want to contact technical support to
discuss your options.

-chris

Myron wrote:
Quote:
Claude,
Thank you very much for help. But I still cannot open the db
file.
I opened the file by binary mode, and found the header is
different with other files. I tried to copy and fix the
first two rows. After that, the dbinfo command was working,
but cannot open by dbeng50, the error is "page count is
wrong". So I think if I know the format, maybe I can fix it
manually.
Do you have any ideas?
Myron


To start when you have not the log create a bat file with

path1\DBENG50 path2\dbname.db -f
pause

I you edit with an Hex editor, can you see the header?

Claude

Myron> a écrit dans le message de news:
4ac9f2c7.4b0e.1681692777 (AT) sybase (DOT) com...
One customer database was corrupted, tried all the SQL
Anywhere command and still cannot make it work. The
error is this file is not a database file. Opened by
work pad and checked it is database for sure.
Unfortunately they don't have the log file. The SQL
Anywhere version is 5. Does anybody have idea how to fix
it? Does anybody know what the database file format is?
Maybe so I can fix the header manually.
Thanks

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.