Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBCC CheckDB And Consistency errors in table sys.sysobjvalues Expand / Collapse
Author
Message
Posted Wednesday, June 3, 2009 10:26 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 7:19 AM
Points: 550, Visits: 1,067
Good day,
I've setup a maint job on my SQL 2008 server. (I have not installed SP1 yet)
For one of my databases I get a consistency error in a system table sys.sysobjectvalues.

I've browsed the net, and saw that this error is coming from the days of 2005, and that it was supposed to be fixed in SQL 2005 SP2 or SP3.

The one option for me to fix this is to run the DBCC CheckDB with repair_allow_data_loss, but I'm a bit hestistant to do it...

What caused this error? and what options do I have to fix this?
Post #728656
Posted Thursday, June 4, 2009 12:44 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 42,822, Visits: 35,952
Please run the following and post the full output here.

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




Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #728701
Posted Thursday, June 4, 2009 2:15 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 7:19 AM
Points: 550, Visits: 1,067
Here it is:



Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:55360) 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.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysobjvalues' (object ID 60).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'AnchorDirect'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (AnchorDirect).


Post #728736
Posted Thursday, June 4, 2009 2:27 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 42,822, Visits: 35,952
Take a look at this article. http://www.sqlservercentral.com/articles/65804/. There's a section with exactly that error and a discussion on it. I think it's one of the first errors discussed.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #728741
Posted Tuesday, July 30, 2013 7:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 7:11 AM
Points: 37, Visits: 338
Thank you very much so it means that i should run the CheckDB with the Repair_Allow_Data_Loss option, if this is the only error that there is, it will not actually delete any data.
Post #1478980
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse