question

sqlLearner 1 avatar image
sqlLearner 1 asked

TempDB Fetch Logical page Failed

I am getting this error in tempDB from time to time. I stopped the sql service and deleted all tempdbs and restarted it but still get the issue. Any suggestions on how I can resolve this issue? Error: 605, Severity: 21, State: 3. Attempt to fetch logical page (8:74) in database 2 failed. It belongs to allocation unit 8430850909295017984 not to 6989706194734219264.
sql-server-2008-r2dbatempdbpage
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
Look at these articles from Microsoft: [FIX: You receive error 605 and error 824 when you run a query that inserts data into a temporary table in SQL Server][1] [How to troubleshoot Msg 605 with SQL Server][2] and follow the recommendations there, depending on the Severity level and your current patch level [1]: http://support.microsoft.com/kb/960770 [2]: http://support.microsoft.com/kb/2015739
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.