on 10-25-2015 9:23 AM
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>
Dears, As I conveyed before when I realized the issue took another backup and there was no issues with that backup. I am searching for an option to recover the table from the cache corrupted dump.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It seems like a table corruption so start searching table on a clean backup or restore again a clean backup.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
looks like there might be cache corruption. Try restarting server. If the error is transient it will go away.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am fine with that option but just think about one thing. We all take backup believing the product does the integrity of the backup right? since we need to restore daily for the report generation we hit the issue immediately and could take another backup. If that was not the situation and we realize later where we will have that image???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dears,
It is a logical corruption happened during the dump, the source doesn't have any issue. I have tried all the index forcing combination it didn't help me.
dbcc checktable also doesnt work. Lookig for an option to recover the complete data
Table Corrupt: Attempted to get page 8583905, partition ID 262552269; got page 0, partition ID 0.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Prior of the BCP out or the select into as suggested by Cory, you might run dbcc tablealloc with fix option - dbcc tablealloc("pm_schedule", full, fix) - in single user mode. If the logical page number mentioned on the error comes from an index, drop index prior of BCP out (you may use ddlgen to have the complete SQL for recreate the indexes).
Regards,
Victoria.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Try doing a select using another index if the object has any indexes.
select * from yourtable (index indexname)
select * from yourtable (index indexname)
or try writing "where clauses" that avoid the page.
select * from yourtable (index indexname) where col_a<abc or col_a>xyz
There are also dbcc print page command...
You would want to examine the prior page in a table to see the next page pointer.
Cory Sane
If I answered your question correctly, please identify the reply as correct or helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.