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

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Sql errors 823

Author  Topic 

Starting Member

1 Post

Posted - 2015-03-11 : 12:08:10
Hello everyone.
I have a question….How to fix sql database when generating an errors 823?
Please help me to out this!

Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-11 : 12:16:32
Some links:
Go to Top of Page

Posting Yak Master

212 Posts

Posted - 2015-03-13 : 01:57:13
Error 823 may occur due to either SQL Server database corruption or I/O errors in the database. The error usually indicates that that there are some inconsistency in file system or the database file is corrupt.

To resolve the issues, you can use any of the below methods:

Method 1: Run Chkdsk to find file system inconsistency issues and resolve it.
Method 2: Use DBCC CHECKDB utility to try repairing the damaged database.
Go to Top of Page

Yak Posting Veteran

52 Posts

Posted - 2015-05-27 : 05:34:49
The main reason of SQL error 823 is due to corruption in the page of the database found by the api whenever it read to perform particular transaction.
Go to Top of Page

- Advertisement -