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).
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.