Developed a tool to recover data from Sybase SQL anywhere db files

Source: Internet
Author: User
Tags sybase sybase database

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.