DBCC CHECKDB (database) WITH ALL_ERRORMSGS

Yesterday, I received approximately 200 error messages from the T-SQL DBCC
CHECKDB(database) WITH ALL_ERRORMSGS command.
Listed below are some of the output errors that I received.
Please let me know the best way to resolve these errors.
Thank You,
DBCC results for 'ACC_CNTRL_LOG'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 797961919, index ID 0: Page (1:80654) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 797961919, index ID 0, page (1:80654). Test
(m_freeCnt == freeCnt) failed. Values are 213 and 245.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 797961919, index ID 0: Page (1:81930) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 797961919, index ID 0, page (1:81930). Test
(m_freeCnt == freeCnt) failed. Values are 207 and 239.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:75016) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:75016). Test
(m_freeCnt == freeCnt) failed. Values are 221 and 253.
There are 3549 rows in 58 pages for object 'ACC_CNTRL_LOG'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:81936) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:81936). Test
(m_freeCnt == freeCnt) failed. Values are 221 and 253.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:81938) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:81938). Test
(m_freeCnt == freeCnt) failed. Values are 213 and 245.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:83168) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:83168). Test
(m_freeCnt == freeCnt) failed. Values are 219 and 251.
There are 254060 rows in 6235 pages for object 'USER_ATTR'.
CHECKDB found 0 allocation errors and 8 consistency errors in table
'USER_ATTR' (object ID 826486023).
DBCC results for 'ATTRIBUTE_SUMMARY'.
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1975730141, index ID 3, page (1:80730). Test
(m_freeCnt == freeCnt) failed. Values are 24 and 56.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 3. Page (1:80730) was not seen
in the scan although its parent (1:15408) and previous (1:76422) refer to it.
Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 3. Page (1:84752) is missing a
reference from previous page (1:80730). Possible chain linkage problem.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1975730141, index ID 4: Page (1:79858) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4, page (1:79858). Test
(m_freeCnt == freeCnt) failed. Values are 24 and 56.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4. Page (1:79858) was not seen
in the scan although its parent (1:81368) and previous (1:74375) refer to it.
Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4. Page (1:84893) is missing a
reference from previous page (1:79858). Possible chain linkage problem.
There are 153206 rows in 3650 pages for object 'ATTRIBUTE_SUMMARY'.
CHECKDB found 0 allocation errors and 12 consistency errors in table
'ATTRIBUTE_SUMMARY' (
You might want to review this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=738137&SiteID=1
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:57321F20-58C5-4BA8-9EA4-2222531294F9@.microsoft.com...
> Yesterday, I received approximately 200 error messages from the T-SQL DBCC
> CHECKDB(database) WITH ALL_ERRORMSGS command.
> Listed below are some of the output errors that I received.
> Please let me know the best way to resolve these errors.
> Thank You,
>
> DBCC results for 'ACC_CNTRL_LOG'.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 797961919, index ID 0: Page (1:80654) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 797961919, index ID 0, page (1:80654). Test
> (m_freeCnt == freeCnt) failed. Values are 213 and 245.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 797961919, index ID 0: Page (1:81930) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 797961919, index ID 0, page (1:81930). Test
> (m_freeCnt == freeCnt) failed. Values are 207 and 239.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:75016) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:75016). Test
> (m_freeCnt == freeCnt) failed. Values are 221 and 253.
> There are 3549 rows in 58 pages for object 'ACC_CNTRL_LOG'.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:81936) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:81936). Test
> (m_freeCnt == freeCnt) failed. Values are 221 and 253.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:81938) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:81938). Test
> (m_freeCnt == freeCnt) failed. Values are 213 and 245.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:83168) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:83168). Test
> (m_freeCnt == freeCnt) failed. Values are 219 and 251.
> There are 254060 rows in 6235 pages for object 'USER_ATTR'.
> CHECKDB found 0 allocation errors and 8 consistency errors in table
> 'USER_ATTR' (object ID 826486023).
>
> DBCC results for 'ATTRIBUTE_SUMMARY'.
> Server: Msg 8939, Level 16, State 106, Line 1
> Table error: Object ID 1975730141, index ID 3, page (1:80730). Test
> (m_freeCnt == freeCnt) failed. Values are 24 and 56.
> Server: Msg 8976, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 3. Page (1:80730) was not seen
> in the scan although its parent (1:15408) and previous (1:76422) refer to
> it.
> Check any previous errors.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 3. Page (1:84752) is missing a
> reference from previous page (1:80730). Possible chain linkage problem.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 1975730141, index ID 4: Page (1:79858) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4, page (1:79858). Test
> (m_freeCnt == freeCnt) failed. Values are 24 and 56.
> Server: Msg 8976, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4. Page (1:79858) was not seen
> in the scan although its parent (1:81368) and previous (1:74375) refer to
> it.
> Check any previous errors.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4. Page (1:84893) is missing a
> reference from previous page (1:79858). Possible chain linkage problem.
> There are 153206 rows in 3650 pages for object 'ATTRIBUTE_SUMMARY'.
> CHECKDB found 0 allocation errors and 12 consistency errors in table
> 'ATTRIBUTE_SUMMARY' (