Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
StuartQ
Starting Member
2 Posts |
 Posted - 2011-07-28 : 12:45:21
|
| We were receiving the following error message today "Fatal error 605 occurred at Jul 28 2011 4:15PM. Note the error and time, and contact your system administrator."Upon investigation, errors were found in TempDB when running DBCC CHECKDB. We restarted the SQL Service and the errors disappeared - both the Fatal Errors and the DBCC CHECKDB errors. My question is, do we have cause for concern with that machine? Are there any particular areas we should focus on in preventing this from happening again?Many ThanksResults of running "DBCC CHECKDB ('tempdb')" below:DBCC results for 'tempdb'.DBCC results for 'sys.sysrowsetcolumns'.There are 1367 rows in 29 pages for object "sys.sysrowsetcolumns".DBCC results for 'sys.sysrowsets'.There are 252 rows in 5 pages for object "sys.sysrowsets".DBCC results for 'sysallocunits'.There are 267 rows in 11 pages for object "sysallocunits".DBCC results for 'sys.sysfiles1'.There are 2 rows in 1 pages for object "sys.sysfiles1".DBCC results for 'sys.syshobtcolumns'.There are 1367 rows in 32 pages for object "sys.syshobtcolumns".DBCC results for 'sys.syshobts'.There are 252 rows in 4 pages for object "sys.syshobts".DBCC results for 'sys.sysftinds'.There are 0 rows in 0 pages for object "sys.sysftinds".DBCC results for 'sys.sysserefs'.There are 267 rows in 2 pages for object "sys.sysserefs".DBCC results for 'sys.sysowners'.There are 14 rows in 1 pages for object "sys.sysowners".DBCC results for 'sys.sysprivs'.There are 121 rows in 1 pages for object "sys.sysprivs".DBCC results for 'sys.sysschobjs'.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:5974) is missing a reference from previous page (1:176263). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:25905) is missing a reference from previous page (1:176262). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:25909) is missing a reference from previous page (1:176257). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:30952) is missing a reference from previous page (1:176259). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:30955) is missing a reference from previous page (1:176260). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:63000) is missing a reference from previous page (1:176258). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:63003) is missing a reference from previous page (1:176261). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:136960) is missing a reference from previous page (1:176256). Possible chain linkage problem.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176256) was not seen in the scan although its parent (1:203) and previous (1:30227) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176257) was not seen in the scan although its parent (1:203) and previous (1:63006) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176258) was not seen in the scan although its parent (1:203) and previous (1:25907) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176259) was not seen in the scan although its parent (1:203) and previous (1:35331) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176260) was not seen in the scan although its parent (1:203) and previous (1:25904) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176261) was not seen in the scan although its parent (1:203) and previous (1:181160) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176262) was not seen in the scan although its parent (1:203) and previous (1:35334) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176263) was not seen in the scan although its parent (1:203) and previous (1:222111) refer to it. Check any previous errors.There are 246 rows in 125 pages for object "sys.sysschobjs".CHECKDB found 0 allocation errors and 16 consistency errors in table 'sys.sysschobjs' (object ID 34).DBCC results for 'sys.syscolpars'.There are 1247 rows in 117 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 27 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 438 rows in 15 pages for object "sys.sysidxstats".DBCC results for 'sys.sysiscols'.There are 418 rows in 3 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.sysobjvalues'.There are 307 rows in 94 pages for object "sys.sysobjvalues".DBCC results for 'sys.sysclsobjs'.There are 14 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 138 rows in 1 pages for object "sys.syssingleobjrefs".DBCC results for 'sys.sysmultiobjrefs'.There are 102 rows in 1 pages for object "sys.sysmultiobjrefs".DBCC results for 'sys.sysdbfiles'.There are 2 rows in 1 pages for object "sys.sysdbfiles".DBCC results for 'sys.sysguidrefs'.There are 0 rows in 0 pages for object "sys.sysguidrefs".DBCC results for 'sys.sysqnames'.There are 91 rows in 1 pages for object "sys.sysqnames".DBCC results for 'sys.sysxmlcomponent'.There are 93 rows in 1 pages for object "sys.sysxmlcomponent".DBCC results for 'sys.sysxmlfacet'.There are 97 rows in 1 pages for object "sys.sysxmlfacet".DBCC results for 'sys.sysxmlplacement'.There are 17 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 0 rows in 0 pages for object "sys.sysbinsubobjs".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________0000000186E9'.There are 22 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________0000000186E9".DBCC results for '#Records____________________________________________________________________________________________________________000000018C28'.There are 2 rows in 2 pages for object "#Records____________________________________________________________________________________________________________000000018C28".DBCC results for 'sys.service_broker_map'.There are 23 rows in 1 pages for object "sys.service_broker_map".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________0000000177D6'.There are 100 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________0000000177D6".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________000000017777'.There are 26 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________000000017777".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________00000001775B'.There are 45 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________00000001775B".DBCC results for '#JobDescriptions____________________________________________________________________________________________________000000018C29'.There are 25 rows in 2 pages for object "#JobDescriptions____________________________________________________________________________________________________000000018C29".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________000000018607'.There are 16 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________000000018607".DBCC results for '#perms______________________________________________________________________________________________________________000000018C37'.There are 1 rows in 1 pages for object "#perms______________________________________________________________________________________________________________000000018C37".DBCC results for '#TotalResults_______________________________________________________________________________________________________000000018D04'.There are 537 rows in 4 pages for object "#TotalResults_______________________________________________________________________________________________________000000018D04".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________0000000178D2'.There are 253 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________0000000178D2".DBCC results for '#perms______________________________________________________________________________________________________________000000018CE3'.There are 1 rows in 1 pages for object "#perms______________________________________________________________________________________________________________000000018CE3".DBCC results for '#Records____________________________________________________________________________________________________________000000018C32'.There are 4 rows in 2 pages for object "#Records____________________________________________________________________________________________________________000000018C32".DBCC results for '#JobDescriptions____________________________________________________________________________________________________000000018C33'.There are 1 rows in 2 pages for object "#JobDescriptions____________________________________________________________________________________________________000000018C33".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________000000018CB4'.There are 0 rows in 0 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________000000018CB4".DBCC results for '#TotalResults_______________________________________________________________________________________________________000000018C41'.There are 15 rows in 2 pages for object "#TotalResults_______________________________________________________________________________________________________000000018C41".CHECKDB found 0 allocation errors and 16 consistency errors in database 'tempdb'.repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (tempdb).DBCC results for 'tempdb'.DBCC results for 'sys.sysrowsetcolumns'.There are 1370 rows in 29 pages for object "sys.sysrowsetcolumns".DBCC results for 'sys.sysrowsets'.There are 253 rows in 5 pages for object "sys.sysrowsets".DBCC results for 'sysallocunits'.There are 268 rows in 11 pages for object "sysallocunits".DBCC results for 'sys.sysfiles1'.There are 2 rows in 1 pages for object "sys.sysfiles1".DBCC results for 'sys.syshobtcolumns'.There are 1370 rows in 32 pages for object "sys.syshobtcolumns".DBCC results for 'sys.syshobts'.There are 253 rows in 4 pages for object "sys.syshobts".DBCC results for 'sys.sysftinds'.There are 0 rows in 0 pages for object "sys.sysftinds".DBCC results for 'sys.sysserefs'.There are 268 rows in 2 pages for object "sys.sysserefs".DBCC results for 'sys.sysowners'.There are 14 rows in 1 pages for object "sys.sysowners".DBCC results for 'sys.sysprivs'.There are 121 rows in 1 pages for object "sys.sysprivs".DBCC results for 'sys.sysschobjs'.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:5974) is missing a reference from previous page (1:176263). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:25905) is missing a reference from previous page (1:176262). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:25909) is missing a reference from previous page (1:176257). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:30952) is missing a reference from previous page (1:176259). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:30955) is missing a reference from previous page (1:176260). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:63000) is missing a reference from previous page (1:176258). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:63003) is missing a reference from previous page (1:176261). Possible chain linkage problem.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:136960) is missing a reference from previous page (1:176256). Possible chain linkage problem.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176256) was not seen in the scan although its parent (1:203) and previous (1:30227) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176257) was not seen in the scan although its parent (1:203) and previous (1:63006) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176258) was not seen in the scan although its parent (1:203) and previous (1:25907) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176259) was not seen in the scan although its parent (1:203) and previous (1:35331) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176260) was not seen in the scan although its parent (1:203) and previous (1:25904) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176261) was not seen in the scan although its parent (1:203) and previous (1:181160) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176262) was not seen in the scan although its parent (1:203) and previous (1:35334) refer to it. Check any previous errors.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). Page (1:176263) was not seen in the scan although its parent (1:203) and previous (1:222111) refer to it. Check any previous errors.There are 247 rows in 125 pages for object "sys.sysschobjs".CHECKDB found 0 allocation errors and 16 consistency errors in table 'sys.sysschobjs' (object ID 34).DBCC results for 'sys.syscolpars'.There are 1250 rows in 118 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 27 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 438 rows in 15 pages for object "sys.sysidxstats".DBCC results for 'sys.sysiscols'.There are 418 rows in 3 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.sysobjvalues'.There are 307 rows in 94 pages for object "sys.sysobjvalues".DBCC results for 'sys.sysclsobjs'.There are 14 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 138 rows in 1 pages for object "sys.syssingleobjrefs".DBCC results for 'sys.sysmultiobjrefs'.There are 102 rows in 1 pages for object "sys.sysmultiobjrefs".DBCC results for 'sys.sysdbfiles'.There are 2 rows in 1 pages for object "sys.sysdbfiles".DBCC results for 'sys.sysguidrefs'.There are 0 rows in 0 pages for object "sys.sysguidrefs".DBCC results for 'sys.sysqnames'.There are 91 rows in 1 pages for object "sys.sysqnames".DBCC results for 'sys.sysxmlcomponent'.There are 93 rows in 1 pages for object "sys.sysxmlcomponent".DBCC results for 'sys.sysxmlfacet'.There are 97 rows in 1 pages for object "sys.sysxmlfacet".DBCC results for 'sys.sysxmlplacement'.There are 17 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 0 rows in 0 pages for object "sys.sysbinsubobjs".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________0000000186E9'.There are 22 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________0000000186E9".DBCC results for '#Records____________________________________________________________________________________________________________000000018C28'.There are 2 rows in 2 pages for object "#Records____________________________________________________________________________________________________________000000018C28".DBCC results for 'sys.service_broker_map'.There are 23 rows in 1 pages for object "sys.service_broker_map".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________0000000177D6'.There are 100 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________0000000177D6".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________000000017777'.There are 26 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________000000017777".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________00000001775B'.There are 45 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________00000001775B".DBCC results for '#JobDescriptions____________________________________________________________________________________________________000000018C29'.There are 25 rows in 2 pages for object "#JobDescriptions____________________________________________________________________________________________________000000018C29".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________000000018607'.There are 16 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________000000018607".DBCC results for '#perms______________________________________________________________________________________________________________000000018C37'.There are 1 rows in 1 pages for object "#perms______________________________________________________________________________________________________________000000018C37".DBCC results for '#TotalResults_______________________________________________________________________________________________________000000018D04'.There are 537 rows in 4 pages for object "#TotalResults_______________________________________________________________________________________________________000000018D04".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________0000000178D2'.There are 253 rows in 1 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________0000000178D2".DBCC results for '#perms______________________________________________________________________________________________________________000000018CE3'.There are 1 rows in 1 pages for object "#perms______________________________________________________________________________________________________________000000018CE3".DBCC results for '#Records____________________________________________________________________________________________________________000000018C32'.There are 4 rows in 2 pages for object "#Records____________________________________________________________________________________________________________000000018C32".DBCC results for '#JobDescriptions____________________________________________________________________________________________________000000018C33'.There are 1 rows in 2 pages for object "#JobDescriptions____________________________________________________________________________________________________000000018C33".DBCC results for '#thar_tempIDtbl_____________________________________________________________________________________________________000000018CB4'.There are 0 rows in 0 pages for object "#thar_tempIDtbl_____________________________________________________________________________________________________000000018CB4".DBCC results for '#TotalResults_______________________________________________________________________________________________________000000018C41'.There are 15 rows in 2 pages for object "#TotalResults_______________________________________________________________________________________________________000000018C41".CHECKDB found 0 allocation errors and 16 consistency errors in database 'tempdb'.repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (tempdb).Msg 605, Level 21, State 3, Line 1Attempt to fetch logical page (1:176261) in database 2 failed. It belongs to allocation unit 170158898806784 not to 281474978938880. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
StuartQ
Starting Member
2 Posts |
Posted - 2011-07-29 : 08:47:23
|
| Thank you for your response.We've not been able to find any disk errors in the event log. Do you have any more suggestions, or require any more information? |
 |
|
|
|
|
|
|
|
TempDB Corruption Question