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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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  
 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.03 seconds. Powered By: Snitz Forums 2000