“Table
error: Object ID O_ID, index ID I_ID, partition ID PN_ID, alloc unit
ID A_ID (type TYPE). The off-row data node at page P_ID1, slot S_ID1,
text ID TEXT_ID is pointed to by page P_ID2, slot S_ID2 and by page
P_ID3, slot P_ID3.”
Apparently,
you are on the right post if looking fro a solution to fix the very
SQL Error 8974 or the error stated above. SQL Server 2008 is latest
version of SQL which makes database more easier to use and in more
efficient way. It is much improved version. In spite error continues
to frustrate and create problems while accessing database tables. One
such very error is SQL Error 8974 which occurs when two index
records have enlisted an off-row node. This very situation arises
when your database gets corrupted due to hardware malfunctioning,
continuous power outage, abrupt system shut down or virus attack etc.
Know, error puts anyone in panic situation but users don't need to be
so. You can fix it using DBCC CHECKDB command with Repair clause. If
situation continues to be same you are highly advised to make use of
MS SQL Database Repair Software to rectify your damaged database.
0 comments:
Post a Comment