SQL server error message 823

Posted on 2007-08-02
Last Modified: 2007-12-19
SQL server error 823?

is this means database is corrupted?
Question by:mshox1
    LVL 15

    Expert Comment

    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.

    Author Comment

    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?


    LVL 15

    Accepted Solution

    You run the dbcc checkdb in Query Analyzer.

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

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now