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