Skip to Content
0
Former Member
Oct 25, 2015 at 09:23 AM

ASE 15.5, not able to select from a table:

27 Views

Hey,

Live backup restored to Reporting server and while selecting from the table ASE engine crashed
dbcc checktable(pm_schedule) says, page 8583904,partition ID 262552269 of object 262552269, contains an orphan row at offset 44 which is marked committed delete and is not.

An attempt was made to fetch logical page 8583905 for database pmt, object 'pm_schedule' (262552269), from cache 'default data cache'. Wrong logical page '1768843040' was found in cache.

1. select * into to different table failed
2. bcp failed
3. dbcc checktable((pm_schedule) - failed


Please do let me know if there is any option to recover the data completely.</p>