Friday, July 17, 2009

Error 8936 in SQL Server

SQL Server supports b-tree indexes to give fast query results. The pages of B-tree indexes are referred as index nodes, with the top node called as root node. However, the middle nodes are termed as branch nodes and bottom level nodes are denoted as leaf nodes. If table indexes get corrupted, SQL Server reports errors and you fail to access your database. To cope up such situations, you need to use your most recent database backup and restore the lost information. At times, backup fails to restore and thus, it becomes necessary that you use SQL Repair applications.

You might receive the below error message with your SQL Server database:

Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID O_ID, index ID I_ID. B-tree chain linkage mismatch. P_ID1->next = P_ID2, but P_ID2->Prev = P_ID3.


This error occurs when SQL Server detects a break in logical page chain at any level of B-tree. It can happen at any level including root and leaf levels. The error message conveys that the next page pointer of page of P_ID1 points page P_ID2,which is different from page P_ID3, pointed by but page P_ID2's previous page pointer.


To solve the present issue, you should consider these methods:

• You should run hardware diagnostics as the above problem could occur due to hardware issues. Isolate the hardware issues, if any.
• If the problem persists, restore the database from a clean backup
• In case of unavailability of clean backup, you should run DBCC CHECKDB command to detect the amount of corruption and observe the suggested repair clause. You can then run DBCC CHECKDB command with the suggested repair clause
• If database still remains in corrupted state, you should use commercial SQL recovery tools.

SQL Repair software are advanced tools that can efficiently repair and restore damaged SQL Server databases. Such applications are equipped with graphically rich user interface, to-the-point documentation and read-only design. You can use these tools in any case of SQL database corruption.

Stellar Phoenix SQL Recovery is a complete repair tool for damaged SQL Server databases. It supports safe database repair for SQL Server 2008, 2005 and 2000. This SQL Recovery software is available with self-descriptive interface and restores all database objects (tables, user defined data types and functions, triggers, stored procedures, views, rules etc.). The software is compatible with Windows Vista, XP, 2003, 2000, and NT.

No comments:

Post a Comment