Search for questions :
My Profile
Categories

Animesh

Open Question Bookmark and Share

How to resolve MS SQL Server Error 8961 ?

Some of the tables in the SQL Server are corrupted due to some virus attack in my computer. As a result of which when I am trying to get access to the tables, the database is displaying the following error message:

Server: Msg 8961, Level 23, State < state_number >
Table error: Object ID O_ID. The text, ntext, or image node at page P_ID1, slot S_ID1, text ID TEXT_ID does not match its reference from page P_ID2, slot S_ID2.

Can anybody tell me what the meaning of the above error message and why this is occurring? Also tell the possible solution to resolve the issue. I am looking for some suggestions

277 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (2)

David 		In order to solve the problem, you need to follow below steps:

1. Check your system for possible hardware problems
2. Restore database from clean backup, if available
3. Execute DBCC CHECKDB command without using repair clause if no valid backup is available. Again run DBCC CHECKDB but with the repair clause suggested by the previous check

If problem still persist than you need to use third party sql database recovery software to repair your database.

Posted 50 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!


JimmyRead 		The above error message occurs when there is difference between the parent node and child node of the tables in SQL Server. When the timestamps in the parent node and the child node does not matches with each other. It can also occur when the child node is in text index node and is having a different size in comparison to the parent node. The error message can also occur when the child node is in text index node and the parent node is in text data node or vice versa.

In order to get rid of the error messages so that you can access the tables in SQL Server, you will have to first check out your computer for any hardware problems. If there is any hardware error, restore the database from clean backup. Use the following command DBCC CHECKDB to repair the damaged tables. If the table is repaired then its okay otherwise use 3rd party utility software called MS SQL Database Repair which will automatically repair the crashed table without any kind of data loss.


Posted 277 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0