Post reply

LOB data type node does not exist?

  • August 24, 2009 at 12:17 am

    #209811

    I Come up Against twice same issue in SQL 2005 Transaction Replication:

    The Database ID 11, Page (1:53833), slot 0 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

    Please Everybody help , Thanks!

  • August 24, 2009 at 8:13 am

    #1043639

    Did you do what the error message said? If not, please run the following and post the full output

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Do you have a backup that doesn't have this error in it?

    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 2 (of 2 total)

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