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.
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] [How to troubleshoot Msg 605 with SQL Server] and follow the recommendations there, depending on the Severity level and your current patch level :