Posted - 10/21/2013 : 12:56:24
| Hi all
We had a hardware failure from our host. So server went down but came back eventually.
After that our db went into suspcect mode. I ran following command and got the db back to normal mode.
EXEC sp_resetstatus 'DBName'
ALTER DATABASE DATABASE_NAME SET EMERGENCY
ALTER DATABASE 'DBName' SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('DBName', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE 'DBName' SET MULTI_USER
When i ran follwoing command I got the below message.
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Now when I check the event log I see EventId: 605
Attempt to fetch logical page (1:794766) in database 9 failed. It belongs to allocation unit 72057617472815104 not to 72057616923557888.
I googled and in some forums it was mentioned that it could temp table in certain SP causing the issue.
How do i know which is database 9 and how to find which tables from Allocation unit?
Where do I go from here. Any pointer or help would be highly appreciated.