none
dbcc checkdb error Incorrect PFS free space information for page

    Question

  • Hi,

    I am getting following error on  one of my sql server after running  DBCC checkdb(dbname)

    Incorrect PFS free space information for page (1:155) in object ID 60, index ID 1, 
    partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). 
    Expected value   0_PCT_FULL, actual value 100_PCT_FULL.
    There are 518 rows in 237 pages for object "sys.sysobjvalues".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 
    'sys.sysobjvalues' (object ID 60).


    Kindly suggest on above error.

    Monday, November 11, 2013 3:53 PM

Answers

  • Hi,

    Can you re-post the full output of DBCC CHECKDB(dnbame) WITH ALL ERROR_MSGS, NO INFO_MSGS

    I take it the recommended options is REPAIR_ALLOW_DATA_LOSS?  You should be okay running it if this is the only error message.

    N.B.  Do you have valid database backups?  Make sure that you take a full backup before doing running the REPAIR_ALLOW_DATA_LOSS option (if it turns out to be the right option).  I'd also suggest restoring a copy of this database elsewhere and trialing first.


    Thanks, Andrew
    My blog...

    Monday, November 11, 2013 4:08 PM