2

I received an alert "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 would be how will I determine which database to run DBCC on? I couldn't find a message pointing to which db raised this alert.

Thank you,

Stackoverflowuser
  • 203
  • 3
  • 12

1 Answers1

1

Try to look in the SQL Server LOG-folder. Your answer could be in a dump log-file. If you still have a default trace from the time of the incident, you could try to look in the trace-files (*.trc) in the LOG-folder. Hint - Secure the trc-files by copying them to another folder before reading. I hope you find your root-cause.

/niels

nielsgrove
  • 59
  • 1
  • 2