<div>
Try running DBCC CHECKDB on the database. If it reports errors, correct those (it will detail how). If not, check your system event logs for any disk-related errors.
</div>


Try running DBCC CHECKDB on the database. If it reports errors, correct those (it will detail how). If not, check your system event logs for any disk-related errors.

<div>
1. How to run dbcc checkdb? &nbsp;from Dos command? &nbsp; we are using SQL database.<br />
<br />
2. I tried earlier use &quot;select count(*) from table&quot; query, get this 823 again. &nbsp;but I then<br />
&nbsp; &nbsp;did the 'truncate table'. &nbsp; to erase everyting on the table. &nbsp;then I do the bcp &quot;in&quot; to copy<br />
&nbsp; &nbsp;the backup data (was created earlier by bcp &quot;out&quot; command. &nbsp;after that, &nbsp;the database working<br />
&nbsp; properly again.<br />
<br />
&nbsp;-- so do you know what is the root cuase of this issues?<br />
<br />
thanks<br />
<br />
mshox1<br />

</div>


1. How to run dbcc checkdb?  from Dos command?   we are using SQL database.

2. I tried earlier use "select count(*) from table" query, get this 823 again.  but I then
   did the 'truncate table'.   to erase everyting on the table.  then I do the bcp "in" to copy
   the backup data (was created earlier by bcp "out" command.  after that,  the database working
  properly again.

 -- so do you know what is the root cuase of this issues?

thanks

mshox1


<div>
<div class="content wysiwyg-content">
SQL server error 823?<br />
<br />
is this means database is corrupted?<br />

</div>
</div>


SQL server error 823?

is this means database is corrupted?


SQL server error message 823

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.