Checkdb is giving errror for systemtable | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Checkdb is giving errror for systemtable

Hi Folks,
I am getting some consistency errors in one system table of a user db.Since this is a system table so I am not pretty sure how to handle this situation in sql 2005.More over I really dont know how this consistency error came
I am worried that last backup of this database might also have same consistency error. Can some one help me with the steps to fix this issue.I will be appreciate all your comments
Here are the error information I got from the result pane
DBCC results for ‘sys.sysobjvalues’.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:226) 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.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:227) 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.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:236) 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.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:242) 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.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:246) 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 415 rows in 90 pages for object "sys.sysobjvalues".
CHECKDB found 0 allocation errors and 5 consistency errors in table ‘sys.sysobjvalues’ (object ID 60).
DBCC results for ‘sys.sysclsobjs’.
May be while creating statistics might has corrupted…
You may need to use DAC connection repair this… http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx
We define the following terms related to SQL Server 2005 statistics: • statblob: Statistics Binary Large Object. This object is stored in the system catalogs in an internal catalog view, sys.sysobjvalues. • String Summary: A form of statistics that summarizes the frequency distribution of substrings in a string column. This is used to help estimate selectivity of LIKE predicates. It is stored in the statblob for a string column.
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Have you used the backup of this database elsewhere to see that table is not corrupted, it might be an issue with a page mismatch on this server. It is better to restore the table values from the good known backup. Try running dbcc checkdb with repair_allow_data_loss on the system table sysobjvalues. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>