Sunday 1 March 2015

SQL SERVER ERROR 8930


“Table error: Object ID O_ID1, index ID I_ID1 cross-object chain linkage. Page P_ID1 points to P_ID2 in object ID O_ID2, index ID I_ID2.”

SQL database user many times encountered an above shown error message while using inbuilt utility DBCC CHECKDB database in ease to recover lost data. This error message displayed is known as error 8930 encountered in SQL database. SQL is referred as best database management and storage application used by the organizations. Occurrence of error 8930 is sign of corruption in database, so data recovery is important issue to tackle.



CAUSES OF ERROR 8930
The main cause of the occurrence of this error is the corruption of the database which doesn't allow the DBCC utility to recover data.
The incorrect page ID reference as shown in error message “P_IDI page refer to P_ID2” is the main cause of the error 8930. Page header corruption, hardware fault and virus attacks can be also are a main reason behind the occurrence of t his error 8930.

SOLUTION
If the error occurs the main concern is to recover data by resolving this error, mostly there are two ways to resolve the error. One is to go to manual solution and another way is to go for repair tool. Manual solutions to resolve this error is to perform hardware diagnose, back up restoration and to know more go to Error 8930 blog




No comments:

Post a Comment

Note: only a member of this blog may post a comment.