![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |