DBCC found errors, how to fix?

Question

Post reply

DBCC found errors, how to fix?

winsysadmin

Old Hand

Points: 315
More actions
February 25, 2009 at 1:01 pm

#200226

I've included the log. Any ideas on how to fix these errors?
==============================================
Server: Msg 1505, Level 16, State 1, Line 1
CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is 'Database Administrators'.
Server: Msg 1505, Level 16, State 1, Line 1
CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is 'type 24, len 16'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 0, index ID 0: Page (1:166140) could not be processed. See other errors for details.
DBCC results for 'MOMReporting'.
Repairing this error requires other errors to be corrected first.
CHECKDB found 1 allocation errors and 0 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 874 rows in 17 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 241 rows in 12 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3211 rows in 48 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 843 rows in 136 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 58 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 22 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:589) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:2424) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:2425) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:2426) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:2427) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 5079 rows in 26 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'ProcessRule'.
Could not repair this error.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:2428) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:2429) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3683) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3684) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3685) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3686) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3687) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3720) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4564) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3728) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3729) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3731) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3732) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3733) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3734) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4565) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3747) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3751) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3768) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3769) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4566) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4567) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:6884) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:3773) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4233) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4247) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4282) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4553) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4554) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:6886) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4557) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4558) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4559) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4562) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:4563) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:6952) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:6953) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
There are 5893 rows in 259 pages for object 'ProcessRule'.
CHECKDB found 42 allocation errors and 0 consistency errors in table 'ProcessRule' (object ID 2099048).
DBCC results for 'AlertEventSuppression'.
There are 13180 rows in 326 pages for object 'AlertEventSuppression'.
DBCC results for 'AlertHistory'.
There are 27921 rows in 2954 pages for object 'AlertHistory'.
DBCC results for 'AlertLevel'.
There are 7 rows in 1 pages for object 'AlertLevel'.
DBCC results for 'ProcessRuleComment'.
There are 10365 rows in 6088 pages for object 'ProcessRuleComment'.
DBCC results for 'AlertToEvent'.
There are 1889 rows in 18 pages for object 'AlertToEvent'.
DBCC results for 'ProcessRuleMembership'.
There are 5896 rows in 49 pages for object 'ProcessRuleMembership'.
DBCC results for 'Component'.
There are 64 rows in 1 pages for object 'Component'.
DBCC results for 'ProcessRuleToNotifyGroup'.
There are 235 rows in 2 pages for object 'ProcessRuleToNotifyGroup'.
DBCC results for 'Computer'.
There are 850 rows in 25 pages for object 'Computer'.
DBCC results for 'ProcessRuleToScript'.
There are 309 rows in 3 pages for object 'ProcessRuleToScript'.
DBCC results for 'ProviderInstance'.
There are 0 rows in 1 pages for object 'ProviderInstance'.
DBCC results for 'ProviderType'.
There are 7 rows in 1 pages for object 'ProviderType'.
DBCC results for 'ComputerAttribute'.
There are 3479 rows in 57 pages for object 'ComputerAttribute'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:70210) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:64704), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166137) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
DBCC results for 'ResolutionState'.
There are 7 rows in 1 pages for object 'ResolutionState'.
DBCC results for 'ComputerAttributeDefinition'.
There are 0 rows in 1 pages for object 'ComputerAttributeDefinition'.
DBCC results for 'RuleType'.
There are 14 rows in 1 pages for object 'RuleType'.
DBCC results for 'ComputerResponsibility'.
There are 114 rows in 3 pages for object 'ComputerResponsibility'.
DBCC results for 'RuleTypeToProviderType'.
There are 36 rows in 1 pages for object 'RuleTypeToProviderType'.
DBCC results for 'ComputerRule'.
There are 70 rows in 6 pages for object 'ComputerRule'.
DBCC results for 'SampledNumericData'.
There are 189128131 rows in 1518227 pages for object 'SampledNumericData'.
DBCC results for 'SampledNumericDataSource'.
Repairing this error requires other errors to be corrected first.
There are 6663 rows in 72 pages for object 'SampledNumericDataSource'.
CHECKDB found 1 allocation errors and 0 consistency errors in table 'SampledNumericDataSource' (object ID 658101385).
DBCC results for 'Script'.
Repairing this error requires other errors to be corrected first.
There are 54 rows in 3 pages for object 'Script'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166196) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166199) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166221) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
CHECKDB found 1 allocation errors and 0 consistency errors in table 'Script' (object ID 706101556).
DBCC results for 'ComputerRuleToProcessRuleGroup'.
There are 110 rows in 1 pages for object 'ComputerRuleToProcessRuleGroup'.
DBCC results for 'StringLocalization'.
There are 0 rows in 0 pages for object 'StringLocalization'.
DBCC results for 'ComputerToComputerRule'.
There are 2455 rows in 20 pages for object 'ComputerToComputerRule'.
DBCC results for 'Task'.
There are 0 rows in 0 pages for object 'Task'.
DBCC results for 'Configuration'.
There are 50 rows in 2 pages for object 'Configuration'.
DBCC results for 'TodayStatistics'.
There are 1 rows in 1 pages for object 'TodayStatistics'.
DBCC results for 'MOMReplicationTimeStamp'.
There are 1 rows in 1 pages for object 'MOMReplicationTimeStamp'.
DBCC results for 'User'.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166222) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166304) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166306) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166307) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166140) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166216) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166218) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166220) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166223) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166308) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166309) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:166310) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:161760), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
There are 129854 rows in 1335 pages for object 'User'.
CHECKDB found 15 allocation errors and 0 consistency errors in table 'User' (object ID 866102126).
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'DasServers'.
There are 1 rows in 1 pages for object 'DasServers'.
DBCC results for 'UserDefinedField'.
There are 5 rows in 1 pages for object 'UserDefinedField'.
DBCC results for 'Event'.
There are 4587340 rows in 760613 pages for object 'Event'.
DBCC results for 'Vendor'.
There are 0 rows in 0 pages for object 'Vendor'.
DBCC results for 'EventConsolidated'.
There are 9809 rows in 200 pages for object 'EventConsolidated'.
DBCC results for 'AuditLog'.
There are 0 rows in 0 pages for object 'AuditLog'.
DBCC results for 'EventParam'.
There are 73809536 rows in 1087576 pages for object 'EventParam'.
DBCC results for 'AuditLogValues'.
There are 0 rows in 0 pages for object 'AuditLogValues'.
DBCC results for 'EventParamName'.
There are 14 rows in 1 pages for object 'EventParamName'.
DBCC results for 'GroomLock'.
There are 2 rows in 1 pages for object 'GroomLock'.
DBCC results for 'EventSource'.
There are 1108 rows in 22 pages for object 'EventSource'.
DBCC results for 'EventType'.
There are 6 rows in 1 pages for object 'EventType'.
DBCC results for 'GroomAttribute'.
There are 5 rows in 1 pages for object 'GroomAttribute'.
DBCC results for 'GroomHistory'.
There are 4371159 rows in 35021 pages for object 'GroomHistory'.
DBCC results for 'GroomJob'.
There are 9 rows in 1 pages for object 'GroomJob'.
DBCC results for 'GroomJobCriteria'.
There are 17 rows in 1 pages for object 'GroomJobCriteria'.
DBCC results for 'GuiClass'.
There are 0 rows in 0 pages for object 'GuiClass'.
DBCC results for 'KBase'.
There are 0 rows in 0 pages for object 'KBase'.
DBCC results for 'KBaseComment'.
There are 0 rows in 0 pages for object 'KBaseComment'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5741163) in database ID 8 is allocated in the SGAM (1:5623553) and PFS (1:5734392), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5741168) in database ID 8 is allocated in the SGAM (1:5623553) and PFS (1:5734392), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5741172) in database ID 8 is allocated in the SGAM (1:5623553) and PFS (1:5734392), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5741173) in database ID 8 is allocated in the SGAM (1:5623553) and PFS (1:5734392), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5741174) in database ID 8 is allocated in the SGAM (1:5623553) and PFS (1:5734392), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
DBCC results for 'KBaseHistory'.
There are 0 rows in 0 pages for object 'KBaseHistory'.
DBCC results for 'KBaseSection'.
Repairing this error requires other errors to be corrected first.
There are 11 rows in 1 pages for object 'KBaseSection'.
CHECKDB found 1 allocation errors and 0 consistency errors in table 'KBaseSection' (object ID 1589580701).
DBCC results for 'KpcType'.
Repairing this error requires other errors to be corrected first.
There are 4 rows in 1 pages for object 'KpcType'.
CHECKDB found 1 allocation errors and 0 consistency errors in table 'KpcType' (object ID 1637580872).
DBCC results for 'License'.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:6170266) in database ID 8 is allocated in the SGAM (1:6134785) and PFS (1:6163056), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:6170270) in database ID 8 is allocated in the SGAM (1:6134785) and PFS (1:6163056), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 1797581442, index ID 1. Page (1:124) is missing references from parent (unknown) and previous (page (0:0)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 1845581613, index ID 1. Page (1:175) is missing references from parent (unknown) and previous (page (0:0)) nodes. Possible bad root entry in sysindexes.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
There are 11 rows in 5 pages for object 'License'.
CHECKDB found 4 allocation errors and 0 consistency errors in table 'License' (object ID 1685581043).
DBCC results for 'MessageDll'.
Repairing this error requires other errors to be corrected first.
There are 96 rows in 1 pages for object 'MessageDll'.
CHECKDB found 1 allocation errors and 0 consistency errors in table 'MessageDll' (object ID 1701581100).
DBCC results for 'MonitorView'.
There are 0 rows in 1 pages for object 'MonitorView'.
DBCC results for 'NotifyGroup'.
Could not repair this error.
There are 24 rows in 2 pages for object 'NotifyGroup'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'NotifyGroup' (object ID 1797581442).
DBCC results for 'NotifyGroupMember'.
Could not repair this error.
There are 14 rows in 2 pages for object 'NotifyGroupMember'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'NotifyGroupMember' (object ID 1845581613).
DBCC results for 'NotifyHistory'.
There are 0 rows in 0 pages for object 'NotifyHistory'.
DBCC results for 'Operator'.
There are 0 rows in 1 pages for object 'Operator'.
DBCC results for 'DasLog'.
There are 11532 rows in 328 pages for object 'DasLog'.
DBCC results for 'Akm'.
There are 0 rows in 0 pages for object 'Akm'.
DBCC results for 'PerfmonCounterScale'.
There are 214 rows in 4 pages for object 'PerfmonCounterScale'.
DBCC results for 'AkmToMonitorView'.
There are 0 rows in 0 pages for object 'AkmToMonitorView'.
DBCC results for 'Alert'.
There are 15168 rows in 3844 pages for object 'Alert'.
CHECKDB found 67 allocation errors and 2 consistency errors in database 'MOMReporting'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MOMReporting repair_allow_data_loss).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The statement has been terminated.
========================================================================
Any help is greatly appreciated. Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

This doesn't look good. Do you have any idea when it started? Do you have a clean backup of this database?

How important is the data in this database? Will losing a fair bit from assorted tables be a disaster?

Take a read through this - http://www.sqlservercentral.com/articles/65804/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Paul Randal One Orange Chip Points: 29544 More actions · Answer 2

Hmm - you've already lost some cdata by running repair. Can you post the results of running CHECKDB again please so I can see what's still left broken?

DBCC CHECKDB (yourdb) WITH NO_INFOMSGS, ALL_ERRORMSGS

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

winsysadmin Old Hand Points: 315 More actions · Answer 3

Thanks for the replies!

I've run the DBCC command as suggested and here is the log file

==================================================

Server: Msg 8928, Level 16, State 6, Line 1

Object ID 0, index ID 0: Page (1:166140) could not be processed. See other errors for details.