Sunday, February 19, 2012

DBCC CHECKDB Reporting Errors in - SQL Server 2005

HI,
I am getting this ttype of errors in SQL Server 2005, This table have xml
column.
Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID 304720138, index
ID 1, partition ID 72057594055557120, alloc unit ID 72057594058702848 (type
LOB data). The off-row data node at page (4:26), slot 0, text ID 19136512 is
not referenced. [SQLSTATE 42000]
Please give some help on this , what will be the route cause of this problem?
how to resolve it.
Hi
You may want to check out:
http://msdn.microsoft.com/library/de...err_2_0prl.asp
You may also want to check that this has not been re-introduced
http://support.microsoft.com/default...b;en-us;281287
Try dropping and re-creating the index. If the error persists then you
should log it with PSS.
John
"Srikanth" wrote:

> HI,
> I am getting this ttype of errors in SQL Server 2005, This table have xml
> column.
> Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID 304720138, index
> ID 1, partition ID 72057594055557120, alloc unit ID 72057594058702848 (type
> LOB data). The off-row data node at page (4:26), slot 0, text ID 19136512 is
> not referenced. [SQLSTATE 42000]
> Please give some help on this , what will be the route cause of this problem?
> how to resolve it.
>
>

No comments:

Post a Comment