Tools that have been developed to recover data from Sybase SQL anywhere DB files are now available.
This tool supports versions such as Asa v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0. The tools to recover Sybase SQL anywhere should be the first in the country.
Application Scenarios for this tool:
1. If the Sybase SQL anywhere database cannot be opened due to physical disk failure, operating system, system software, or power-down, etc.
2. Misoperation, including truncate Table,drop table, incorrect where condition caused by accidental deletion, etc.;
When Sybase SQL anywhere fails to open, the more common error is: Assertion failed.
Such as:
1, Internal Database error * * * * * * * assertion failed:201819 (8.0.1.2600) Checkpoint log:invalid Bitmap page--Transa Ction rolled back
2, Internal Database error * * * * * * assertion failed:201819 (8.0.1.2600) page number on page does not match Page Reque Sted--Transaction rolled back
3, Internal Database error * * * * * * assertion failed:200502 (9.0.2.2451) Checksum failure on page--transaction ro Lled back
4, File is shorter than expected
5, Internal Database Error * * * * * * Assertion failed:201116 Invalid Free List index page found while processing check Point log--transaction rolled back
6. * * * * * * * * * Assertion failed:51901 page for requested record not a table Page or record not present on Page
650) this.width=650; "alt=" Checkpoint log:invalid Bitmap page--transaction rolled back "src=" http://www.dbainfo.net/wp -content/uploads/2014/07/invalid-bitmap-page.png "/>
650) this.width=650; "alt=" Internal Database Error * * * * * Assertion failed:201116 Invalid Free List index page fou nd while processing checkpoint log – transaction rolled back "src=" http://www.dbainfo.net/wp-content/uploads/2014/07/ Invalid-free-list-index-page.jpg "height=" 162 "width=" 384 "/>
Wait a minute. The error may also generate the Assert.dmp file in the same directory as the DB file.
For assertion Failure, you can refer to Sybase official technical article: I ' ve got an assertion! What should I do?
There are two articles in this blog that describe the process of analyzing the physical storage structure of Sybase SQL anywhere database db files, and you can refer to the following:
ASA Database Physical storage Structure Analysis (1)
ASA Database Physical storage Structure Analysis (2)
I do not provide a download for this tool. To learn about the process of recovering a damaged DB file using this tool, you can watch the following video:
Full Screen browsing Video: http://www.dbainfo.net/wp-content/uploads/file/SQL_Anywhere_Recovery_Tool-ReadASADB-demo.swf
If your ASA database needs to be restored, you can contact me.
This article is from the Sybase database technology blog, so be sure to keep this source http://dbainfo.blog.51cto.com/202416/1591356
Developed a tool to recover data from Sybase SQL anywhere db files