• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 476
  • Last Modified:

SQL server error message 823

SQL server error 823?

is this means database is corrupted?
0
mshox1
Asked:
mshox1
  • 2
1 Solution
 
derekkrommCommented:
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.
0
 
mshox1Author Commented:
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
0
 
derekkrommCommented:
You run the dbcc checkdb in Query Analyzer.

I suggest still running it in case there are any additional underlying issues.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now