August 17, 2005 at 7:51 am
When I try to run a job that updates some records in a table the job fails and I get the following error:
Error Detail Records: Error: -2147467259 (80004005); Provider Error: 623 (26F) Error string: Could not retrieve row from page by RID because logical page (1:14548) is not a data page.
Rid pageid is (1:14548) and row num is 0x15. Page pointer = 0x7bcae000, Pa... Process Exit Code 1. The step failed.
I run dbcc checkDB and it tells me that it found consistency errors, I run dbcc checkDB with repair_allow_data_loss, and it fix the errors, but as soon as I run the job again, the same error occurs, just on another page. I tried to fix this with dbcc several times, without success. This job has worker for over a year without problems, but now I'm stuck. Anyone got any idea?
Morten
August 18, 2005 at 1:42 am
If this is happening to the same table object, I'd try reindexing it.
August 18, 2005 at 11:46 am
Before re-indexing I'd execute DBCC CHECKALLOC first ...
My 'standard' DBCC 'triage' is:
DBCC CHECKDB
DBCC CHECKALLOC
DBCC CHECKCATALOG
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply