How can I get data from a corrupt table?

[Former Member]

I have an production database that is inconsistent. Actually it just affect one table (a big table with about 37kk rows). If I try unload it, I got an error. If I try to select with an order by, I got an error. Using select * from table an then export data, I can get about first 15kk.

On this link, I show you output log this message https://www.evernote.com/shard/s39/sh/b3705200-255f-4bd0-bf0f-b3b1431420c7/519df905b680e068a87d2d9a0...

I need to recover this data since it holds some government info that I need to store for 5 years. As I know all my backups are corrupted too.

Please, help me!!!

[justin_willey]

You say that if you try the select with an order you get the error, are there other indexes you can try to order by to get the rows in different orders?

I have had a success in the past with getting almost half the rows by ordering Ascending, and then almost all the rest by ordering Descending.

[VolkerBarth]

FWIW: Have your backups been validated? (No, that's no "know-it-all" suggestion, I'm just asking whether that corruption had gone unnoticed through full validation...)

[Former Member]

No, unfortunately our backups currently isn't validated, it's an 85gb database used 24x7 and validate slows out system. Any clue?

[VolkerBarth]

Maybe you could run the validation on a copy of the backup (or a backup in read-only mode) on a separate box? - That will take time (and resources), for sure, however, an invalid backup is not much better than none at all...

[justin_willey]

This seems to be a product for MSSql Server only not SQL Anywhere which is the subject of this forum.

[VolkerBarth]

I just thought how to handle such inappropriate advertising - report it or just downvote?

[Former Member]

Place a call with technical support. The support team has some tools that offer at least the possibility of salvaging the data in your database, if they cannot work around the corruption problem in some other way.

[Breck_Carter]

Sadly, SQL Anywhere doesn't have any tools for dealing with corrupted data.

Since you can run a SELECT * to get the "first 15K", perhaps you can figure out another "SELECT * WHERE some-column > some-value" that will give you the data on the other side of the bad page.

Good luck!

[Former Member]

Try SQL Database Recovery retrieves all data stored within SQL server .MDF files such as tables, triggers, views, stored procedures with damaged unique keys, primary keys and foreign keys. Deleted files are also successfully recovered and saved in a separate batch file for further use.

[MarkCulp]

How does this answer apply to the question? Zote is not using SQL Server, he is using SQL Anywhere!