on 06-02-2015 5:26 PM
I am looking for help in attempting to repair a corrupt SQL Anyhere 9 (9.0.2.2451) database. There is no backup of the database. The database service will not start and gives the following error: Assertion failed: 201129 (9.0.2.2451) File is shorter than expected. Is repairing the database possible? Could data from the database be salvaged to use in creating a new database? I have tried unloading tables using the dbunload command but the same 201129 error occurs when I make the attempt.
Hi David,
Do you have the corresponding *.log file for the database? If the file has never been truncated you may be able to translate the entire transaction log into a SQL file. This would provide you with the complete history of DDL/DML statements which you could playback on a fresh database.
It might be worth trying to start the database with the -f switch, in case the transaction log itself is corrupted (although log corruption would likely being up a different error message).
Mikel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You may not have any options... BUT... it may also be possible that only unimportant data at the end of the file was truncated... this is JUST A GUESS, but perhaps you could try adding bytes to the end of the file using some kind of binary editor, and repeatedly try to start the database. Make a backup file copy of the .db file first, so you can start everything over again if desired. Then start by padding it to the next 2K boundary, then add 2K chunks (the most likely block size). Or use 1K boundary and chunks.
The probability of that working is very low... but not necessarily zero : )
If it works, then you may be able to rescue some of your data.
David you can try Stellar Phoenix repair for SQL AnyWhere software developed by Stellar data recovery. I hope that it can help you.
It helps you in recovery of data from corrupt SQL AnyWhere database along-with tables, triggers, indexes, views, table properties and many more.
Good Luck!!!
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.