![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
We have a customer where it looks like their database and all their backups are corrupt. I am seeing a "checksum failure on page 11661" error when unloading the database. Is there a way to unload the db so that dbunload ignores errors and just continues with the unload? I was able to unload the entire db except for one table. This table happens to be the largest in the db. This customer's production db is now down. Thanks, Doug p.s. version 10.0.1.3415 |
#3
| |||
| |||
|
|
Doug, you might want to try the UNLOAD SELECT statement with an ORDER BY ... until it stops with the error. Then try a second time with the reversed order (ASC replaced by DESC or vice versa). With some luck there'll be only a small window of missing rows. Of course there's always the chance to open a support case with Sybase for data salvation, they got tools to dig deeper than we users. HTH Reimer Doug Stone wrote: We have a customer where it looks like their database and all their backups are corrupt. I am seeing a "checksum failure on page 11661" error when unloading the database. Is there a way to unload the db so that dbunload ignores errors and just continues with the unload? I was able to unload the entire db except for one table. This table happens to be the largest in the db. This customer's production db is now down. Thanks, Doug p.s. version 10.0.1.3415 |
![]() |
| Thread Tools | |
| Display Modes | |
| |