asked
Objects table corrupted at sharepoint_config database
I am using Sql server 2005 and sharepoint 2007 into cluster envirnoment. After DBCC checkdb notice that Dbo.Objects table corrupted at sharepoint_config database.Error is as below DBCC results for 'Objects'. Msg 4514, Level 96, State 1, Line 88 Incorrect PFS free space information for page (1:3756) in object ID 53575229, index ID 1, partition ID 72057594044809216, alloc unit ID 72057594043695104 (type LOB data). Expected value 80_PCT_FULL, actual value 95_PCT_FULL. Msg 8979, Level 16, State 1, Line 1 Table error: Object ID 53575229, index ID 1, partition ID 72057594064809216, alloc unit ID 72057594049596736 (type In-row data). Page (1:3555s (page (1:3862)) nodes. Possible bad root entry in system catalog. There are 333 rows in 444 pages for object "Objects". CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'Objects' (object ID 53575229). repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (SharePoint_Config.dbo.Objects). DBCC execution completed. If DBCC printed error messages, contact your system administrator. can you please help how to repair corrup object with no data loss and no risk to envirnoment. Do we need downtime for it. Thnaku for your support in advance.
My first thought would be confirm that you have a valid backup of the database just in case. Secondly, I'd follow the advice given in this thread,
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e34bbbab-6413-4377-9bcb-29abb9af543d/dbcc-checkdb-errors?forum=sqldisasterrecovery. This seems to match what you are experiencing. As Paul mentions, you will need to put the database into single user mode in order to do this. It's essentially taking it offline. I might take a backup of the database in it's current state, restore it somewhere, run DBCC checkdb to see if the error is still present and then try to fix it. You would be able to confirm that no data loss occurred and all is well. You can then plan and execute the fix on the live database. Hope that helps!
18 People are following this question.
