SQL fatal error 823

Naresh Ede asked on April 10, 2018 19:41

Hi guys I had restored the database to my local. I can able to see all the tables in object explorer, but I can't able to get data in it, because it is showing SQL error : fatal error 823.

I read somewhere that, we can able to see the errors in the table suspected_pages.

Select * from suspected_pages

I got some records in that table with event_type 3.

How i can able to resolve those errors, because I'm confused after seeing the Microsoft documentation.

If anybody faced this kind of issue, please help me in resolving this.

Thanks

Naresh Ede

sql fatal error 823

Correct Answer

Peter Mogilnitski answered on April 11, 2018 04:45

You have either file system or disk issue. 823 error messages are reported only for failed OS IO operation errors. Given that, you need to check your system event log for any disk or file system related entries. You will need to fix the disk or file system problems or else the corruption will return. Read more

0 votesVote for this answer Unmark Correct answer

Recent Answers

Peter Mogilnitski answered on April 11, 2018 03:18

Does DBCC CHECKDB show any errors?

0 votesVote for this answer Mark as a Correct answer

Naresh Ede answered on April 11, 2018 03:30

Yes, too many errors

0 votesVote for this answer Mark as a Correct answer