Possible index corruption detected. Run DBCC CHECKDB
I got a warning "Possible index corruption detected. Run DBCC CHECKDB" I checked the error logs and they are: "Possible index corruption detected. Run DBCC CHECKDB Error: 9100, Severity: 23, State: 2"
My question will be how to determine which database DBCC will run on? I couldn't find a message indicating that db raised this warning.
Thank,
+3
source to share
1 answer
Try browsing in the SQL Server LOG folder. Your response may be in the log dump file. If you still have a default trace from the time of the incident, you can try to view the trace files (* .trc) in the LOG folder. Hint. Protect trc files by copying them to another folder before reading. I hope you found your root cause.
/ Niels
+2
source to share