Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Event Id: 605

Author  Topic 

Mits
Starting Member

48 Posts

Posted - 2013-10-21 : 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
DBCC checkdb('DBName')
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.

DBCC checkdb('DBName')
GO
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.

Kind regards

Mitesh

chadmat
The Chadinator

1974 Posts

Posted - 2013-10-24 : 14:33:52
Do you have a backup?

You can get the database either by selecting from sysdatabases, or:

SELECT DB_NAME(9)



-Chad
Microsoft Certified Master SQL Server 2008
Go to Top of Page
   

- Advertisement -