dbcc check db error

  • Can anyone tell me what this means and how to correct it please.

    thanks

    Incorrect PFS free space information for page (1:295) in object ID 1131151075, index ID 1, partition ID 72057594050772992, alloc unit ID 72057594059554816 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL

  • Try DBCC UPDATEUSAGE



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


  • The DBCC above should correct this and you should be sure that you run a DBCC CHECKDB after it to be sure there are no other issues.

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

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