If you are MS SQL user you might know that it store data in the form of relations or tables. It arranged all the data separately in the form of rows and columns. These rows are divided into numbered partitions which start from 1 to n. All rows are considered as single partition and you can also determine its size. Entire rows of the tables are stored in the form of B tree structure or heap structure. Text data node i.e. leaf nodes of leaves store the actual data and index values for leaf nodes are stored by text index nodes. But while access sometimes you find table discrepancies due to mismatch of child and parent nodes. It happens due to occurrence of SQL Server Error 8961. When it occurs your database becomes inaccessible. You might encounter with error message as cited below:

Server: Msg 8961, Level 23, State

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.

Where, 'state number' might be 1, 2 or 4.

Occurrence of SQL Server Error 8961 indicates that there is a corruption in text objects due to mismatch between child and parent node. But don’t worry you can find the exact cause of error with the help of displayed state number.

• State 1 indicates that there is a mismatch in timestamps between child and parent node
• State 2 occurs when child node is text index node has different size as assume by parent node which was previously text data node having size greater than parent node
• State 4 indicates that actually child node is text index node but it is supposed as text data node by parent node

Once you get the exact cause of SQL Server Error 8961 you can easily fix it by executing DBCC CHECK command. Follow the below steps to resolve the error:

• Repair and restore database from available backup
• Check hardware problems of the system
• Execute DBCC CHECKDB command

But while doing so you will lose your data. So, to repair data base without losing any data you can use MS SQL Database Repair software. It will safely repair SQL Server Error 8961 by using its powerful scanning technology.