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.

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

Author  Topic 

Kaneko
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!

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-11 : 12:16:32
Some links:

https://support.microsoft.com/kb/828339?wa=wsignin1.0
http://support.microsoft.com/kb/2015755
Go to Top of Page

prett
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

Lincolnburrows
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 -