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.
| Author |
Topic |
|
Mits
Starting Member
48 Posts |
 Posted - 2013-10-21 : 12:56:24
|
| Hi allWe 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_USERWhen i ran follwoing command I got the below message. DBCC checkdb('DBName')GO Msg 8921, Level 16, State 1, Line 1Check 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: 605Attempt 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 regardsMitesh |
|
|
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)-ChadMicrosoft Certified Master SQL Server 2008 |
 |
|
|
|
|
|
Event Id: 605