question

sqlLearner 1 avatar image
sqlLearner 1 asked

Fetch logical page TempDB Failed

I am getting this error in TempDB. Does anyone know the best way to approach it? I can restart the sql instance if needed after hours to rebuild tempdb. Attempt to fetch logical page (1:38947) in database 2 failed. It belongs to allocation unit 5836965899133452288 not to 1369395632473440256. I am running SQL Server 2008R2 SP1
sql-server-2008-r2tsqltempdb
3 comments
10 |1200

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

sp_lock avatar image sp_lock commented ·
Did you follow the suggestions from your previous post? http://ask.sqlservercentral.com/questions/108258/tempdb-fetch-logical-page-failed.html If you did and it is the same server then you maybe looking at a bog or disk corruption/issues. Are you able to validate that your disk sub-system is "sound" and you have enough space (where tempdb sits)?
3 Likes 3 ·
KenJ avatar image KenJ commented ·
Now that you've had a chance to visit the original question, did you try @Kev Riley's suggestion and follow the steps in the support article for troubleshooting 605 errors?
1 Like 1 ·
sqlLearner 1 avatar image sqlLearner 1 commented ·
Yes I have a plenty of space. I forgot I asked that question on this forum before.
0 Likes 0 ·

1 Answer

·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
after hours to rebuild tempdb ??? Tempdb is recreated when you (re-)start SQL. I assume this is not taking hours ...
1 comment
10 |1200

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

KenJ avatar image KenJ commented ·
I would probably read it more like, "I can restart the SQL instance if needed after [business] hours [in order] to rebuild tempdb"
0 Likes 0 ·

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.