SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Event Id: 605
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Mits
Starting Member

United Kingdom
48 Posts

Posted - 10/21/2013 :  12:56:24  Show Profile  Reply with Quote
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

USA
1974 Posts

Posted - 10/24/2013 :  14:33:52  Show Profile  Visit chadmat's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000