December 16, 2013 at 10:49 am
when i am trying to fetch the rows from particular table ,I am getting the following error,
Error :
Msg 605, Level 21, State 3, Line 1
Attempt to fetch logical page (3:260514) in database 8 failed. It belongs to allocation unit 72057594218545152 not to 72057594219986944.
Msg 5243, Level 22, State 8, Line 1
An inconsistency was detected during an internal operation. Please contact technical support.
Please provide me the solution
Thanks In Advance
December 16, 2013 at 11:16 am
Talk to your DBA. That sounds like an actual physical corruption type of problem.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 16, 2013 at 12:00 pm
Yikes! Not good. A consistency check should be run on the database right away. I hope you have good backups in place.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply