Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2012
    Posts
    3

    Arrow Unanswered: CHECKDB found 12 consistency errors

    Hi,
    Please help. My Maintenanace plan is failing because of this error.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 569873197. The text, ntext, or image node at page (1:13952), slot 42, text ID 49266360320 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 12 consistency errors in table 'Orientation_ChkList' (object ID 569873197).
    [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 12 consistency errors in database.

    How can I check which rows in this table is corrupted? I have three image fields in this table. This is happening since long time and restore from backup won't work here. any ideas please? Thanks.
    Last edited by guru1; 02-27-12 at 14:57. Reason: Update

  2. #2
    Join Date
    Jun 2011
    Posts
    31
    Provided Answers: 1

    Thumbs up CHECKDB found 12 consistency errors

    Run DBCC CHECKTABLE command on each table and check error log message, it will report the corrupt table.

    To Repair run:
    DBCC CHECKTABLE
    (
    your_table_name
    [REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD]
    )
    Note: Do to this, your database must be in single-user mode and may loss some data.

  3. #3
    Join Date
    Feb 2012
    Posts
    3

    Arrow CHECKDB found 12 consistency errors

    Thanks.
    When I put database in singleuser mode I can't access any tables or cannot run the query. Would you guide please.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    wait...you have a window open in SQL Server Manglement Studio

    You then put the DB in Single User Mode, and you can't access it?

    I think you have done something different
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2012
    Posts
    3

    Arrow

    Yes.
    I opened the database in Sql management studio then went to options and put it in single user mode.

    Then in the database node on the tables right click and open the table.
    I get the connection failed message - server rejected connection message.
    appreciate your help.
    Thanks.

  6. #6
    Join Date
    Jun 2011
    Posts
    31
    Provided Answers: 1

    Arrow CHECKDB found 12 consistency errors

    Hello Guru,

    Sorry for late reply. i was out of work station. To set your database to single user mode; follow the steps describe here.. How to: Set a Database to Single-user Mode (SQL Server Management Studio)

    Regards,
    Addision Philip
    SQL recovery is possible with database recovery advisor

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •