January 12, 2012 at 3:55 am
Hi All,
After running a DBCC CHECKDB On one of our database. I got below error.
Extent (36:16) in database ID 5 is allocated by more than one allocation object.
Msg 8913, Level 16, State 1, Line 1
Extent (36:16) is allocated to 'GAM' and at least one other object.
Is it some thing related to IO operation?
Not able to understand why this error has come.
Can somebody put some light on this.
Thanks in advance
January 12, 2012 at 3:59 am
Small chance, bug in SQL, large chance IO subsystem error, same as all other corruption.
Can't give you any advice on fixing it without seeing all of the output from CheckDB.
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
January 12, 2012 at 4:07 am
Thanks for a quick reply
Here is more detail of DBCC.
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Page (36:16) was not seen in the scan although its parent (38:4256353) and previous (37:4258279) refer to it. Check any previous errors.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 83 refers to child page (36:17) and previous child (36:16), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 84 refers to child page (36:18) and previous child (36:17), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 85 refers to child page (36:19) and previous child (36:18), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 86 refers to child page (36:20) and previous child (36:19), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 87 refers to child page (36:21) and previous child (36:20), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 88 refers to child page (36:22) and previous child (36:21), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 89 refers to child page (36:23) and previous child (36:22), but they were not encountered.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Page (38:4259448) is missing a reference from previous page (36:23). Possible chain linkage problem.
There are 329342272 rows in 7631236 pages for object "XXXX".
CHECKDB found 1 allocation errors and 9 consistency errors in table
CHECKDB found 3 allocation errors and 9 consistency errors in database XXXXX.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (XXXXX)
Can please help to me understand what this mean.
January 12, 2012 at 4:15 am
That is not the entire output of checkDB. Please run the following and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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
January 12, 2012 at 4:47 am
Yes its not the full output. But rest of the tables in that DB, the dbcc out is alright there is no such error message. There was only one table which was the cause for this error output
I posted only error part of it. I hope it will help.
Thanks
January 12, 2012 at 6:22 am
There are two allocation errors that you haven't posted. Please run the command I gave you (which will return only the errors) and post the results
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
January 12, 2012 at 11:10 pm
I appriciate your effort and quick responses.
Here I am posting the full output of DBCC CheckDB. Just the User Table name are edited.
DBCC results for 'XXXXX'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
Msg 8904, Level 16, State 1, Line 1
Extent (36:16) in database ID 5 is allocated by more than one allocation object.
Msg 8913, Level 16, State 1, Line 1
Extent (36:16) is allocated to 'GAM' and at least one other object.
CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object.
DBCC results for 'sys.sysrscols'.
There are 6885 rows in 93 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 321 rows in 8 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysallocunits'.
There are 340 rows in 14 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 39 rows in 5 pages for object "sys.sysfiles1".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysfgfrag'.
There are 22 rows in 1 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysphfg'.
There are 11 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 39 rows in 2 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 16 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 138 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 684 rows in 13 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 6865 rows in 186 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 35 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 827 rows in 42 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 999 rows in 17 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 1106 rows in 432 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 30 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 154 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 1698 rows in 21 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 10 rows in 1 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syscompfragments'.
There are 0 rows in 0 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysqnames'.
There are 97 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 18 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 1017 rows in 21 pages for object "sys.syssoftobjrefs".
DBCC results for 'xx'.
There are 496516 rows in 5063 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 36527 rows in 323 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 26 rows in 1 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 23 rows in 1 pages for object "xx".
DBCC results for 'xx'.
There are 7771805 rows in 287580 pages for object "xx".
DBCC results for 'xx'.
There are 6 rows in 1 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 283 rows in 4 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 12 rows in 1 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 7606539 rows in 110361 pages for object "xx".
DBCC results for 'xxy'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 2934115 rows in 37712 pages for object "xx".
DBCC results for 'xx'.
There are 20712856 rows in 629125 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 3105788 rows in 28494 pages for object "xx".
DBCC results for 'xxe'.
There are 8609 rows in 118 pages for object "xxe".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 3037424 rows in 196241 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 14097 rows in 593 pages for object "xx".
DBCC results for 'xx'.
There are 239522 rows in 5424 pages for object "xx".
DBCC results for 'xx'.
There are 130299730 rows in 2562370 pages for object "xx".
DBCC results for 'xx'.
There are 3044281 rows in 196339 pages for object "xx".
DBCC results for 'xx'.
There are 128458 rows in 7151 pages for object "xx".
DBCC results for 'xx'.
There are 14174 rows in 595 pages for object "xx".
DBCC results for 'xx'.
There are 3249 rows in 93 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 128623 rows in 7157 pages for object "xx".
DBCC results for 'xx'.
There are 38344 rows in 899 pages for object "xx".
DBCC results for 'xx'.
There are 3249 rows in 92 pages for object "xx".
DBCC results for 'xx'.
There are 4919249 rows in 268425 pages for object "xx".
DBCC results for 'xx'.
There are 38344 rows in 898 pages for object "xx".
DBCC results for 'xx'.
There are 8373457 rows in 558128 pages for object "xx".
DBCC results for 'xx'.
There are 4919249 rows in 267731 pages for object "xx".
DBCC results for 'xx'.
There are 117562 rows in 7302 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 3052275 rows in 98461 pages for object "xx".
DBCC results for 'xx'.
There are 8373457 rows in 558126 pages for object "xx".
DBCC results for 'xx'.
There are 80468 rows in 3285 pages for object "xx".
DBCC results for 'xx'.
There are 117562 rows in 7301 pages for object "xx".
DBCC results for 'xx'.
There are 24 rows in 1 pages for object "xx".
DBCC results for 'xx'.
There are 3408977 rows in 16005 pages for object "xx".
DBCC results for 'xx'.
There are 9163602 rows in 235072 pages for object "xx".
DBCC results for 'xx'.
There are 6790936 rows in 120619 pages for object "xx".
DBCC results for 'xx'.
There are 968019 rows in 83146 pages for object "xx".
DBCC results for 'xx'.
There are 8298664 rows in 29745 pages for object "xx".
DBCC results for 'xx'.
There are 543446569 rows in 1266782 pages for object "xx".
DBCC results for 'xx'.
There are 8371506 rows in 19519 pages for object "xx".
DBCC results for 'xx'.
There are 1099828 rows in 2571 pages for object "xx".
DBCC results for 'xx'.
There are 81401900 rows in 189755 pages for object "xx".
DBCC results for 'x'.
There are 40858560 rows in 117755 pages for object "xx".
DBCC results for 'xx'.
There are 9045726 rows in 21092 pages for object "xx".
DBCC results for 'xx'.
There are 496515 rows in 5119 pages for object "xx".
DBCC results for 'xx'.
There are 239522 rows in 1250 pages for object "xx".
DBCC results for 'xx'.
There are 1780 rows in 46 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 802235 rows in 4073 pages for object "xx".
DBCC results for 'xx'.
There are 3474789 rows in 17639 pages for object "xx".
DBCC results for 'xx'.
There are 4043104 rows in 10987 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "Txx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 9 rows in 1 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 15 rows in 1 pages for object "xx".
DBCC results for 'xx'.
There are 39876 rows in 2489 pages for object "xx".
DBCC results for 'xx'.
There are 2077443 rows in 5396 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 3119610 rows in 314965 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 60 rows in 3 pages for object "xx".
DBCC results for 'xx'.
There are 78 rows in 3 pages for object "xx".
DBCC results for 'xx'.
There are 1317 rows in 74 pages for object "xx".
DBCC results for 'xx'.
There are 18089757 rows in 144821 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 46292236 rows in 1031536 pages for object "xx".
DBCC results for 'xx'.
There are 60 rows in 2 pages for object "xx".
DBCC results for 'xx'.
There are 219964 rows in 3636 pages for object "xx".
DBCC results for 'xx'.
There are 85568 rows in 138 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xxx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 5421 rows in 298 pages for object "xx".
DBCC results for 'xx'.
There are 1409763 rows in 94349 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 23307 rows in 1550 pages for object "xx".
DBCC results for 'xx'.
There are 7571 rows in 319 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 1317 rows in 80 pages for object "xx".
DBCC results for 'xx'.
There are 44817 rows in 2505 pages for object "Txx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 3249 rows in 92 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 38344 rows in 898 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 4919246 rows in 267019 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 8373457 rows in 557668 pages for object "xx".
DBCC results for 'xx'.
There are 11210622 rows in 456655 pages for object "xx".
DBCC results for 'xx'.
There are 33890 rows in 2101 pages for object "xx".
DBCC results for 'xx'.
There are 2566718 rows in 12402 pages for object "xx".
DBCC results for 'xx'.
There are 0 rows in 0 pages for object "xx".
DBCC results for 'xx'.
There are 13059420 rows in 1271812 pages for object "xx".
DBCC results for 'xx'.
There are 14836140 rows in 1038453 pages for object "xx".
DBCC results for 'xx'.
There are 14179 rows in 597 pages for object "xx".
DBCC results for 'xx'.
There are 127473 rows in 7105 pages for object "xx".
DBCC results for 'xx'.
Msg 8913, Level 16, State 3, Line 1
Extent (36:16) is allocated to 'xx' and at least one other object.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Page (36:16) was not seen in the scan although its parent (38:4256353) and previous (37:4258279) refer to it. Check any previous errors.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 83 refers to child page (36:17) and previous child (36:16), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 84 refers to child page (36:18) and previous child (36:17), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 85 refers to child page (36:19) and previous child (36:18), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 86 refers to child page (36:20) and previous child (36:19), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 87 refers to child page (36:21) and previous child (36:20), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 88 refers to child page (36:22) and previous child (36:21), but they were not encountered.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Index node page (38:4256353), slot 89 refers to child page (36:23) and previous child (36:22), but they were not encountered.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Page (38:4259448) is missing a reference from previous page (36:23). Possible chain linkage problem.
There are 329342272 rows in 7631236 pages for object "xxxx".
CHECKDB found 1 allocation errors and 9 consistency errors in table 'xxxx' (object ID 1499868410).
DBCC results for 'xxx'.
There are 16444 rows in 107 pages for object "xxx".
DBCC results for 'xxx'.
There are 3064 rows in 88 pages for object "xxx".
DBCC results for 'Txxx'.
There are 2398670 rows in 7428 pages for object "xxx2".
DBCC results for 'xxx'.
There are 38344 rows in 881 pages for object "xxx".
DBCC results for 'Txxx'.
There are 938 rows in 52 pages for object "xx".
DBCC results for 'xxx'.
There are 5547 rows in 331 pages for object "xxx".
DBCC results for 'xxx'.
There are 0 rows in 2 pages for object "xxx".
DBCC results for 'xxx'.
There are 4919249 rows in 268428 pages for object "xxx".
DBCC results for 'xxx'.
There are 36572 rows in 2470 pages for object "xxxx".
DBCC results for 'xxxx'.
There are 13292706 rows in 885750 pages for object "xxx".
DBCC results for 'xxx'.
There are 36572 rows in 2470 pages for object "xxxx".
DBCC results for 'xxxx'.
There are 117677 rows in 7308 pages for object "xxxx".
DBCC results for 'xxx'.
There are 0 rows in 2 pages for object "Txxxx".
DBCC results for 'xxx'.
There are 0 rows in 2 pages for object "xxx".
DBCC results for 'xxx'.
There are 0 rows in 2 pages for object "xxxx".
DBCC results for 'xxx'.
There are 0 rows in 2 pages for object "xxx".
DBCC results for 'xxxx'.
There are 21210 rows in 1389 pages for object "xxxx".
DBCC results for 'xxx'.
There are 63536760 rows in 1245819 pages for object "xxxr".
DBCC results for 'xxx'.
There are 21210 rows in 1393 pages for object "Txxx".
DBCC results for 'xxx'.
There are 10328 rows in 88 pages for object "xxxx".
DBCC results for 'xxx'.
There are 161680 rows in 1192 pages for object "xxx".
DBCC results for 'xxxx'.
There are 283 rows in 3 pages for object "xxxx".
DBCC results for 'xxxx'.
There are 101 rows in 6 pages for object "xxx".
DBCC results for 'xxxx'.
There are 5762 rows in 99 pages for object "xxxx".
DBCC results for 'xxxx'.
There are 161678 rows in 14663 pages for object "xxx".
DBCC results for 'xxx'.
There are 32 rows in 2 pages for object "xxx".
DBCC results for 'xxx'.
There are 67271309 rows in 3485870 pages for object "xxx".
DBCC results for 'xxxx'.
There are 59574 rows in 3989 pages for object "xxxx".
DBCC results for 'xxx'.
There are 0 rows in 2 pages for object "xxx".
DBCC results for 'xxx'.
There are 23996 rows in 1602 pages for object "xxx".
DBCC results for 'xxx'.
There are 133076 rows in 9839 pages for object "xxx".
DBCC results for 'xxx'.
There are 0 rows in 0 pages for object "xxx".
DBCC results for 'xxx'.
There are 0 rows in 0 pages for object "xxx".
DBCC results for 'xxx'.
There are 810 rows in 3 pages for object "xxx".
DBCC results for 'xxx'.
There are 0 rows in 0 pages for object "xxx".
DBCC results for 'xxx'.
There are 0 rows in 0 pages for object "xxx".
DBCC results for 'xxxx'.
There are 1352057 rows in 89858 pages for object "xxx".
DBCC results for 'xxxx'.
There are 2699885 rows in 67384 pages for object "xxx".
DBCC results for 'xxx'.
There are 7526 rows in 317 pages for object "xxxx".
DBCC results for 'xxxx'.
There are 41287 rows in 2306 pages for object "xxxx".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'xxxx'.
There are 2493 rows in 71 pages for object "xxx".
DBCC results for 'xxx'.
There are 38344 rows in 882 pages for object "xxx".
DBCC results for 'xxxx'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'xx'.
There are 4919246 rows in 267767 pages for object "xxx".
DBCC results for 'xxx'.
There are 8373457 rows in 557660 pages for object "xxx".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'xxx'.
There are 34204 rows in 2122 pages for object "xxxx".
DBCC results for 'sys.filestream_tombstone_2073058421'.
There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".
DBCC results for 'sys.syscommittab'.
There are 0 rows in 0 pages for object "sys.syscommittab".
DBCC results for 'xxxx'.
There are 2279071 rows in 26197 pages for object "xxx".
DBCC results for 'xxxx'.
There are 1 rows in 1 pages for object "xxxx".
DBCC results for 'xxxx'.
There are 64580732 rows in 2476438 pages for object "xxxx".
DBCC results for 'xxxx'.
There are 21 rows in 1 pages for object "xxx".
DBCC results for 'xxxx'.
There are 24 rows in 1 pages for object "xx".
CHECKDB found 3 allocation errors and 9 consistency errors in database 'XXXXXX'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (XXXXXX).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Thanks
January 13, 2012 at 2:45 am
Do you have a clean full backup (one without the corruption) and an unbroken chain of log backups?
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
January 13, 2012 at 4:25 am
I have the backup. My question is i want to understand that error. I guess it is a page corruption error.
What you say Gail..
If posible just help to understand that error.
January 13, 2012 at 4:29 am
Exactly, it's a page corruption, likely caused by some problem with the IO subsystem. Basically you have a dedicated extent (extent belonging to one object) that's marked as owned by two different objects. I can think of a few IO-type errors that could cause that.
Take a tail-log backup, then restore full backup from before, all log backups and end with the tail-log backup that you just took, that should recover the DB without corruption right up to the current point.
Then do some investigations of the IO subsystem, check logs, run diagnostics, etc. That's everything from filter drivers right down to the physical disks themselves.
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
January 16, 2012 at 5:21 am
Okay.
Thanks a lot..
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply