Post reply

Issue reading Lob data in SQL Server 2008R2

  • June 7, 2012 at 6:44 am

    #257561

    I have a large table with a few ntext columns.

    When i try to do a simple select on the data, after about 3 mins i get this error:

    Msg 7105, Level 22, State 11, Line 1

    The Database ID Database ID, Page (N:N), slot N for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.

    I have done a dbcc check table and it found nothing. I found reference to this issue in SQL 2005 but it was supposed to be fixed in SP2

    http://www.sqlskills.com/BLOGS/PAUL/post/Couple-of-LOB-corruption-bugs-fixed-in-the-latest-CUs-for-2005.aspx

    Im not sure how to resolve this as it looks like a bug in sql. Anyone have any ideas on how i can read my data?

  • June 7, 2012 at 6:53 am

    #1498124

    You're running in read uncommitted isolation level?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply