I have a user which has a database on a harddrive that is
failing. The database is corrupt, the validated database on
the harddrive is also corrupt.They have no backup form
before the database became corrupt. I have been able to
unload the majority of the tables.
I have narrowed the corrupt data to 3 - 4 tables. When I
attempt to unload one of the corrupt tables I get:
***** SQL error: Internal database error *** ERROR ***
Assertion failed:
101412 (9.0.2.3886)
Page number on page does not match page requested --
transaction rolled back
The database 'XYZ' could not be unloaded.
I have tried unloading ( Unordered ) just in case teh index
was corrupt with no luck.

Are there any more things that I can try before opening a
case with support.

Thanks in Advance,
Dave

Hi Dave,

Dave Westphal wrote:
There's only one extra step you might be able to try, if you're willing
to forego some 'data in the middle' of these tables. Basically the
approach is to select the bottom and top data set of the tables and
output these results into a file:

"To salvage data from the corrupt tables" (halfway down the page)
http://www.sybase.com/detail?id=1039322

Any future steps would be to call technical support and ask for a
database salvage (which is billed as an separate engagement beyond the
scope of the technical case):

http://www.sybase.com/contactus/support/

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

If you have all the transaction logs since the time the database was
created, you could use dbtran to translate them to SQL and executed them
against a new database to recreate the corrupted database.

This is only helpful if you have never truncated and deleted your
transaction log.

Dave Westphal wrote: