Chiratidzo:

Paunenge uchishandisa DBCC CHECKDB ne REPAIR_ALLOW_DATA_LOSS parameter kugadzirisa yakaora .MDF dhatabhesi, seizvi:

DBCC CHECKDB(xxxx, 'REPAIR_ALLOW_DATA_LOSS')

iwe unoona inotevera meseji yekukanganisa:

Gadzirisa: Iyo Clustered indekisi yakabudirira kuvaka patsva yechinhu "syscoppars" mudhatabhesi "Error1".
Gadzirisa: Iyo Nonclustered index yakabudirira kuvakwazve kwechinhu "syscoppars" mudhatabhesi "Error1".
DBCC mhinduro dze'Error1'.
Service Broker Msg 9675, Nyika 1: Mhando dzeMharidzo dzakaongororwa: 14.
Service Broker Msg 9676, State 1: Service Contracts yakaongororwa: 6.
Service Broker Msg 9667, Nyika 1: Masevhisi akaongororwa: 3.
Service Broker Msg 9668, State 1: Service Queues yakaongororwa: 3.
Service Broker Msg 9669, State 1: Nhaurirano Endpoints yakaongororwa: 0.
Service Broker Msg 9674, State 1: Hurukuro Mapoka akaongororwa: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings yakaongororwa: 0.
Service Broker Msg 9605, Nyika 1: Hurukuro Zvinokosha zvakaongororwa: 0.
Msg 8992, Chikamu 16, State 1, Mutsara 8
Tarisa Catalog Msg 3852, State 1: Row (object_id=69) mu sys.objects (mhando=S ) haina mutsara unoenderana (object_id=69,column_id=1) mu sys.columns.
Msg 8992, Chikamu 16, State 1, Mutsara 8
Tarisa Catalog Msg 3852, State 1: Row (object_id=71) mu sys.objects (mhando=S ) haina mutsara unoenderana (object_id=71,column_id=1) mu sys.columns.
Msg 8992, Chikamu 16, State 1, Mutsara 8
Tarisa Catalog Msg 3852, State 1: Row (object_id=72) mu sys.objects (mhando=S ) haina mutsara unoenderana (object_id=72,column_id=1) mu sys.columns.
Msg 8992, Chikamu 16, State 1, Mutsara 8
Tarisa Catalog Msg 3852, State 1: Row (object_id=73) mu sys.objects (mhando=S ) haina mutsara unoenderana (object_id=73,column_id=1) mu sys.columns.
CHECKDB yakawana 0 zvikanganiso zvekugovera uye 4 zvikanganiso zvisina hukama nechero chinhu chimwe chete.
DBCC mhinduro dze 'sys.sysrscols'.
Pane mitsara zana nemakumi mapfumbamwe nemaviri mumapeji gumi nemana echinhu "sys.sysrscols".
DBCC mhinduro dze 'sys.sysrowsets'.
Pane mitsara zana nemakumi mana nemasere mumapeji matatu echinhu “sys.sysrowsets”.
DBCC mhinduro dze 'sys.sysclones'.
Pane mitsara 0 mumapeji 0 echinhu "sys.sysclones".
DBCC mhinduro dze 'sys.sysallocunits'.
Pane mitsara zana nemakumi manomwe nembiri mumapeji maviri echinhu “sys.sysallocunits”.
DBCC mhinduro dze 'sys.sysfiles1'.
Pane mitsara miviri mumapeji 2 echinhu "sys.sysfiles1".
DBCC mhinduro dze 'sys.sysseobjvalues'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysseobjvalues".
DBCC mhinduro dze'sys.syspriorities'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.syspriorities".
DBCC mhinduro dze 'sys.sysdbfrag'.
Pane mitsara mumapeji 0 echinhu “sys.sysdbfrag”.
DBCC mhinduro dze 'sys.sysfgfrag'.
Pane mitsara mumapeji 0 echinhu "sys.sysfgfrag".
DBCC mhinduro dze 'sys.sysdbfiyo'.
Pane mitsara mumapeji 2 echinhu “sys.sysdbfiyo”.
DBCC mhinduro dze 'sys.syspru'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.syspru".
DBCC mhinduro dze 'sys.sysbrickfiles'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysbrickfiles".
DBCC mhinduro dze 'sys.sysphfg'.
Pane mitsara 1 mumapeji 1 echinhu "sys.sysphfg".
DBCC mhinduro dze 'sys.sysprufiles'.
Pane mitsara miviri mumapeji 2 echinhu "sys.sysprufiles".
DBCC mhinduro dze 'sys.sysftinds'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysftinds”.
DBCC mhinduro dze 'sys.sysowners'.
Pane mitsara gumi nemina mumapeji 14 echinhu "sys.sysowners".
DBCC mhinduro dze 'sys.sysdbreg'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysdbreg”.
DBCC mhinduro dze 'sys.sysprivs'.
Pane mitsara zana nemakumi mana mumapeji 140 echinhu “sys.sysprivs”.
DBCC mhinduro dze 'sys.sysschobjs'.
Pane mitsara 2262 mumapeji makumi maviri nemapfumbamwe echinhu "sys.sysschobjs".
DBCC mhinduro dze'sys.syscrowgroups'.
Pane mitsara mumapeji 0 echinhu "sys.syscsrowgroups".
DBCC mhinduro dze 'sys.sysexttables'.
Pane mitsara mumapeji 0 echinhu "sys.sysexttables".
DBCC mhinduro dze 'sys.syscoppars'.
Gadzirisa: Iyo Clustered index yakabudirira kuvaka patsva yechinhu "sys.syscoppars" mudhatabhesi "Error1".
Kugadzirisa: Iyo peji (1:53) yakatorwa kubva kuchinhu ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data).
Gadzirisa: Iyo Nonclustered index yakabudirira kuvakazve chinhu "sys.syscocolpars, nc" mudhatabhesi "Error1".
Msg 8945, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 41, index ID 1 ichavakwa patsva.
Iko kukanganisa kwagadziriswa.
Msg 8928, Chikamu 16, State 1, Mutsara 8
Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data): Peji (1:53) yatadza kugadziriswa. Ona zvimwe zvikanganiso kuti uwane ruzivo.
Iko kukanganisa kwagadziriswa.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data), peji (1:53). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Iko kukanganisa kwagadziriswa.
Msg 8976, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Peji (1:53) haina kuonekwa mu scan kunyange mubereki wayo (1:111) uye yapfuura (1:113) vachireva nezvayo. Tarisa chero zvikanganiso zvekare.
Iko kukanganisa kwagadziriswa.
Msg 8978, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Peji (1:56) haina chirevo kubva papeji yapfuura (1:53). Dambudziko rekubatanidza cheni rinogona kuitika.
Iko kukanganisa kwagadziriswa.
Msg 8945, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 41, index ID 2 ichavakwa patsva.
Iko kukanganisa kwagadziriswa.
Kune 845 mitsetse mumapeji gumi nemashanu yechinhu "sys.syscoppars".
CHECKDB yakawana 0 kukanganisa kwekugoverwa uye 4 kukanganisa kukanganisa mutafura 'sys.syscolpars' (chinhu ID 41).
CHECKDB yakagadzirisa 0 zvikanganiso zvekugovera uye 4 kukanganisa kukanganisa mutafura 'sys.syscolpars' (chinhu ID 41).
DBCC mhinduro dze 'sys.sysxlgns'.
Pane mitsara mumapeji 0 echinhu "sys.sysxlgns".
DBCC mhinduro dze 'sys.sysxsrvs'.
Pane mitsara mumapeji 0 echinhu "sys.sysxsrvs".
DBCC mhinduro dze 'sys.sysnsobjs'.
Pane mitsara 1 mumapeji 1 echinhu "sys.sysnsobjs".
DBCC mhinduro dze 'sys.sysusermsgs'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysusermsgs".
DBCC mhinduro dze 'sys.syscerts'.
Pane mitsara mumapeji 0 echinhu "sys.syscerts".
DBCC mhinduro dze 'sys.sysrmtlgns'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysrmtlgns”.
DBCC mhinduro dze 'sys.syslnklgns'.
Pane mitsara mumapeji 0 echinhu "sys.syslnklgns".
DBCC mhinduro dze 'sys.sysxprops'.
Pane mitsara mumapeji 0 echinhu "sys.sysxprops".
DBCC mhinduro dze 'sys.sysscalartypes'.
Pane mitsara makumi matatu nemina mumapeji 34 echinhu "sys.sysscalartypes".
DBCC mhinduro dze 'sys.systypedsubobjs'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.systypedsubobjs”.
DBCC mhinduro dze 'sys.sysidxstats'.
Pane mitsara mazana maviri nenomwe mumapeji mashanu echinhu "sys.sysidxstats".
DBCC mhinduro dze 'sys.sysicols'.
Kune mitsara mazana matatu nepfumbamwe mumapeji maviri echinhu “sys.sysicols”.
DBCC mhinduro dze 'sys.sysendpts'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysendpts”.
DBCC mhinduro dze 'sys.syswebmethods'.
Pane mitsara mumapeji 0 echinhu "sys.syswebmethods".
DBCC mhinduro dze 'sys.sysbinobjs'.
Pane mitsara makumi maviri nenhatu mumapeji 23 echinhu "sys.sysbinobjs".
DBCC mhinduro dze 'sys.sysaudacts'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysaudacts".
DBCC mhinduro dze 'sys.sysobjvalues'.
Pane mitsara mazana maviri negumi nematatu mumapeji makumi maviri nerimwe echinhu “sys.sysobjvalues”.
DBCC mhinduro dze 'sys.sysccolsegments'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysccolsegments".
DBCC mhinduro dze'sys.syscsdictionaries'.
Pane mitsara mumapeji 0 echinhu "sys.syscsdictionaries".
DBCC mhinduro dze 'sys.sysclsobjs'.
Pane mitsara gumi nematanhatu mumapeji 16 echinhu "sys.sysclsobjs".
DBCC mhinduro dze 'sys.sysrowsetrefs'.
Pane mitsara 0 mumapeji 0 echinhu "sys.sysrowsetrefs".
DBCC mhinduro dze 'sys.sysremsvcbinds'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysremsvcbinds”.
DBCC mhinduro dze 'sys.sysmultiobjrefs'.
Pane mitsara zana nenomwe mumapeji 107 echinhu “sys.sysmultiobjrefs”.
DBCC mhinduro dze 'sys.sysguidrefs'.
Pane mitsara mumapeji 0 echinhu "sys.sysguidrefs".
DBCC mhinduro dze 'sys.sysfoqueues'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysfoqueues".
DBCC mhinduro dze 'sys.syschildinsts'.
Kune mitsetse 0 mumapeji 0 echinhu "sys.syschildinsts".
DBCC mhinduro dze 'sys.syscompfragments'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.syscompfragments".
DBCC mhinduro dze 'sys.sysftsemanticsdb'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysftsemanticsdb”.
DBCC mhinduro dze 'sys.sysftstops'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysftstops”.
DBCC mhinduro dze 'sys.sysftproperties'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysftproperties”.
DBCC mhinduro dze 'sys.sysxmitbody'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysxmitbody”.
DBCC mhinduro dze 'sys.sysfos'.
Pane mitsara mumapeji 0 echinhu "sys.sysfos".
DBCC mhinduro dze 'sys.sysqnames'.
Pane mitsara makumi mapfumbamwe nemasere mumapeji 98 echinhu "sys.sysqnames".
DBCC mhinduro dze 'sys.sysxmlcomponent'.
Pane mitsara zana mumapeji 100 echinhu "sys.sysxmlcomponent".
DBCC mhinduro dze 'sys.sysxmlfacet'.
Pane mitsara zana negumi nembiri mumapeji 112 echinhu “sys.sysxmlfacet”.
DBCC mhinduro dze 'sys.sysxmlplacement'.
Pane mitsara gumi nemipfumbamwe mumapeji 19 echinhu "sys.sysxmlplacement".
DBCC mhinduro dze 'sys.sysobjkeycrypts'.
Pane mitsara 0 mumapeji 0 echinhu "sys.sysobjkeycrypts".
DBCC mhinduro dze 'sys.sysasymkeys'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysasymkeys”.
DBCC mhinduro dze 'sys.syssqlguides'.
Pane mitsara 0 mumapeji 0 echinhu "sys.syssqlguides".
DBCC mhinduro dze 'sys.sysbinsubobjs'.
Pane mitsara mitatu mumapeji 3 echinhu "sys.sysbinsubobjs".
DBCC mhinduro dze 'sys.syssoftobjrefs'.
Kune mitsetse 0 mumapeji 0 echinhu "sys.syssoftobjrefs".
DBCC mhinduro dze 'sys.plan_persist_plan'.
Pane mitsara mumapeji 0 echinhu "sys.plan_persist_plan".
DBCC mhinduro dze 'sys.plan_persist_runtime_stats'.
Pane mitsara mumapeji 0 echinhu "sys.plan_persist_runtime_stats".
DBCC mhinduro dze 'sys.plan_persist_runtime_stats_interval'.
Pane mitsara 0 mumapeji 0 echinhu "sys.plan_persist_runtime_stats_interval".
DBCC mhinduro dze'sys.plan_persist_context_settings'.
Pane mitsara 0 mumapeji 0 echinhu "sys.plan_persist_context_settings".
DBCC mhinduro dze 'sys.sqlagent_jobs'.
Pane mitsara mumapeji 0 echinhu "sys.sqlagent_jobs".
DBCC mhinduro dze 'sys.sqlagent_jobsteps'.
Pane mitsara mumapeji 0 echinhu "sys.sqlagent_jobsteps".
DBCC mhinduro dze 'sys.sqlagent_job_history'.
Pane mitsara 0 mumapeji 0 echinhu "sys.sqlagent_job_history".
DBCC mhinduro dze 'sys.sqlagent_jobsteps_logs'.
Pane mitsara 0 mumapeji 0 echinhu "sys.sqlagent_jobsteps_logs".
DBCC mhinduro dze'TestTable'.
Kune mitsara 11000 mumapeji zana negumi echinhu "TestTable".
DBCC mhinduro dze 'sys.queue_messages_1977058079'.
Pane mitsara 0 mumapeji 0 echinhu "sys.queue_messages_1977058079".
DBCC mhinduro dze 'sys.queue_messages_2009058193'.
Pane mitsara 0 mumapeji 0 echinhu "sys.queue_messages_2009058193".
DBCC mhinduro dze 'sys.queue_messages_2041058307'.
Pane mitsara 0 mumapeji 0 echinhu "sys.queue_messages_2041058307".
DBCC mhinduro dze 'sys.filestream_tombstone_2073058421'.
Pane mitsara 0 mumapeji 0 echinhu "sys.filestream_tombstone_2073058421".
DBCC mhinduro dze 'sys.syscommittab'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.syscommittab”.
DBCC mhinduro dze 'sys.filetable_updates_2105058535'.
Pane mitsara 0 mumapeji 0 echinhu "sys.filetable_updates_2105058535".
DBCC mhinduro dze 'sys.plan_persist_query_text'.
Pane mitsara 0 mumapeji 0 echinhu "sys.plan_persist_query_text".
DBCC mhinduro dze 'sys.plan_persist_query'.
Pane mitsara mumapeji 0 echinhu "sys.plan_persist_query".
CHECKDB yakawana 0 zvikanganiso zvekugovera uye 8 zvikanganiso zvekuenderana mudhatabhesi 'Error1'.
CHECKDB yakagadzirisa 0 zvikanganiso zvekugovera uye 4 zvikanganiso zvekuenderana mudhatabhesi 'Error1'.
DBCC kuuraya kwapera. Kana DBCC yakadhinda mhosho mameseji, bata system yako maneja.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona ine musoro kuenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0xedf7c98; chaiyo: 0xed637c9c). Zvakaitika panguva yekuverenga peji (1:53) mudhatabhesi ID 39 pakubvisa 0x0000000006a000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona ine musoro kuenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0xedf7c98; chaiyo: 0xed637c9c). Zvakaitika panguva yekuverenga peji (1:53) mudhatabhesi ID 39 pakubvisa 0x0000000006a000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona ine musoro kuenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0xedf7c98; chaiyo: 0xed637c9c). Zvakaitika panguva yekuverenga peji (1:53) mudhatabhesi ID 39 pakubvisa 0x0000000006a000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona ine musoro kuenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0xedf7c98; chaiyo: 0xed637c9c). Zvakaitika panguva yekuverenga peji (1:53) mudhatabhesi ID 39 pakubvisa 0x0000000006a000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona ine musoro kuenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0xedf7c98; chaiyo: 0xed637c9c). Zvakaitika panguva yekuverenga peji (1:53) mudhatabhesi ID 39 pakubvisa 0x0000000006a000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona ine musoro kuenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0xedf7c98; chaiyo: 0xed637c9c). Zvakaitika panguva yekuverenga peji (1:53) mudhatabhesi ID 39 pakubvisa 0x0000000006a000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.

or

Gadzirisa: Iyo Clustered indekisi yakabudirira kuvaka patsva yechinhu "syscoppars" mudhatabhesi "Error1".
Gadzirisa: Iyo Nonclustered index yakabudirira kuvakwazve kwechinhu "syscoppars" mudhatabhesi "Error1".
DBCC mhinduro dze'Error1'.
Service Broker Msg 9675, Nyika 1: Mhando dzeMharidzo dzakaongororwa: 14.
Service Broker Msg 9676, State 1: Service Contracts yakaongororwa: 6.
Service Broker Msg 9667, Nyika 1: Masevhisi akaongororwa: 3.
Service Broker Msg 9668, State 1: Service Queues yakaongororwa: 3.
Service Broker Msg 9669, State 1: Nhaurirano Endpoints yakaongororwa: 0.
Service Broker Msg 9674, State 1: Hurukuro Mapoka akaongororwa: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings yakaongororwa: 0.
Service Broker Msg 9605, Nyika 1: Hurukuro Zvinokosha zvakaongororwa: 0.
Msg 8992, Chikamu 16, State 1, Mutsara 8
Tarisa Catalog Msg 3852, State 1: Row (object_id=23) mu sys.objects (mhando=S ) haina mutsara unoenderana (object_id=23,column_id=1) mu sys.columns.
Msg 8992, Chikamu 16, State 1, Mutsara 8
Tarisa Catalog Msg 3852, State 1: Row (object_id=24) mu sys.objects (mhando=S ) haina mutsara unoenderana (object_id=24,column_id=1) mu sys.columns.
CHECKDB yakawana 0 zvikanganiso zvekugovera uye 2 zvikanganiso zvisina hukama nechero chinhu chimwe chete.
DBCC mhinduro dze 'sys.sysrscols'.
Pane mitsara zana nemakumi mapfumbamwe nemaviri mumapeji gumi nemana echinhu "sys.sysrscols".
DBCC mhinduro dze 'sys.sysrowsets'.
Pane mitsara zana nemakumi mana nemasere mumapeji matatu echinhu “sys.sysrowsets”.
DBCC mhinduro dze 'sys.sysclones'.
Pane mitsara 0 mumapeji 0 echinhu "sys.sysclones".
DBCC mhinduro dze 'sys.sysallocunits'.
Pane mitsara zana nemakumi manomwe nembiri mumapeji maviri echinhu “sys.sysallocunits”.
DBCC mhinduro dze 'sys.sysfiles1'.
Pane mitsara miviri mumapeji 2 echinhu "sys.sysfiles1".
DBCC mhinduro dze 'sys.sysseobjvalues'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysseobjvalues".
DBCC mhinduro dze'sys.syspriorities'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.syspriorities".
DBCC mhinduro dze 'sys.sysdbfrag'.
Pane mitsara mumapeji 0 echinhu “sys.sysdbfrag”.
DBCC mhinduro dze 'sys.sysfgfrag'.
Pane mitsara mumapeji 0 echinhu "sys.sysfgfrag".
DBCC mhinduro dze 'sys.sysdbfiyo'.
Pane mitsara mumapeji 2 echinhu “sys.sysdbfiyo”.
DBCC mhinduro dze 'sys.syspru'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.syspru".
DBCC mhinduro dze 'sys.sysowners'.
Pane mitsara gumi nemina mumapeji 14 echinhu "sys.sysowners".
DBCC mhinduro dze 'sys.sysdbreg'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysdbreg”.
DBCC mhinduro dze 'sys.sysprivs'.
Pane mitsara zana nemakumi mana mumapeji 140 echinhu “sys.sysprivs”.
DBCC mhinduro dze 'sys.sysschobjs'.
Pane mitsara 2262 mumapeji makumi maviri nemapfumbamwe echinhu "sys.sysschobjs".
DBCC mhinduro dze'sys.syscrowgroups'.
Pane mitsara mumapeji 0 echinhu "sys.syscsrowgroups".
DBCC mhinduro dze 'sys.sysexttables'.
Pane mitsara mumapeji 0 echinhu "sys.sysexttables".
DBCC mhinduro dze 'sys.syscoppars'.
Gadzirisa: Iyo Clustered index yakabudirira kuvaka patsva yechinhu "sys.syscoppars" mudhatabhesi "Error1".
Kugadzirisa: Iyo peji (1:59) yakatorwa kubva kuchinhu ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data).
Gadzirisa: Iyo Nonclustered index yakabudirira kuvakazve chinhu "sys.syscocolpars, nc" mudhatabhesi "Error1".
Msg 8945, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 41, index ID 1 ichavakwa patsva.
Iko kukanganisa kwagadziriswa.
Msg 8928, Chikamu 16, State 1, Mutsara 8
Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data): Peji (1:59) yatadza kugadziriswa. Ona zvimwe zvikanganiso kuti uwane ruzivo.
Iko kukanganisa kwagadziriswa.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data), peji (1:59). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Iko kukanganisa kwagadziriswa.
Msg 8976, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Peji (1:59) haina kuonekwa mu scan kunyange mubereki wayo (1:111) uye yapfuura (1:155) vachireva nezvayo. Tarisa chero zvikanganiso zvekare.
Iko kukanganisa kwagadziriswa.
Msg 8978, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Peji (1:112) haina chirevo kubva papeji yapfuura (1:59). Dambudziko rekubatanidza cheni rinogona kuitika.
Iko kukanganisa kwagadziriswa.
Msg 8945, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 41, index ID 2 ichavakwa patsva.
Iko kukanganisa kwagadziriswa.
Kune 832 mitsetse mumapeji gumi nemashanu yechinhu "sys.syscoppars".
CHECKDB yakawana 0 kukanganisa kwekugoverwa uye 4 kukanganisa kukanganisa mutafura 'sys.syscolpars' (chinhu ID 41).
CHECKDB yakagadzirisa 0 zvikanganiso zvekugovera uye 4 kukanganisa kukanganisa mutafura 'sys.syscolpars' (chinhu ID 41).
DBCC mhinduro dze 'sys.sysxlgns'.
Pane mitsara mumapeji 0 echinhu "sys.sysxlgns".
DBCC mhinduro dze 'sys.sysxsrvs'.
Pane mitsara mumapeji 0 echinhu "sys.sysxsrvs".
DBCC mhinduro dze 'sys.sysnsobjs'.
Pane mitsara 1 mumapeji 1 echinhu "sys.sysnsobjs".
DBCC mhinduro dze 'sys.sysusermsgs'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysusermsgs".
DBCC mhinduro dze 'sys.syscerts'.
Pane mitsara mumapeji 0 echinhu "sys.syscerts".
DBCC mhinduro dze 'sys.sysrmtlgns'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysrmtlgns”.
DBCC mhinduro dze 'sys.syslnklgns'.
Pane mitsara mumapeji 0 echinhu "sys.syslnklgns".
DBCC mhinduro dze 'sys.sysxprops'.
Pane mitsara mumapeji 0 echinhu "sys.sysxprops".
DBCC mhinduro dze 'sys.sysscalartypes'.
Pane mitsara makumi matatu nemina mumapeji 34 echinhu "sys.sysscalartypes".
DBCC mhinduro dze 'sys.systypedsubobjs'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.systypedsubobjs”.
DBCC mhinduro dze 'sys.sysidxstats'.
Pane mitsara mazana maviri nenomwe mumapeji mashanu echinhu "sys.sysidxstats".
DBCC mhinduro dze 'sys.sysicols'.
Kune mitsara mazana matatu nepfumbamwe mumapeji maviri echinhu “sys.sysicols”.
DBCC mhinduro dze 'sys.sysendpts'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysendpts”.
DBCC mhinduro dze 'sys.syswebmethods'.
Pane mitsara mumapeji 0 echinhu "sys.syswebmethods".
DBCC mhinduro dze 'sys.sysbinobjs'.
Pane mitsara makumi maviri nenhatu mumapeji 23 echinhu "sys.sysbinobjs".
DBCC mhinduro dze 'sys.sysaudacts'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysaudacts".
DBCC mhinduro dze 'sys.sysobjvalues'.
Pane mitsara mazana maviri negumi nematatu mumapeji makumi maviri nerimwe echinhu “sys.sysobjvalues”.
DBCC mhinduro dze 'sys.sysccolsegments'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysccolsegments".
DBCC mhinduro dze'sys.syscsdictionaries'.
Pane mitsara mumapeji 0 echinhu "sys.syscsdictionaries".
DBCC mhinduro dze 'sys.sysclsobjs'.
Pane mitsara gumi nematanhatu mumapeji 16 echinhu "sys.sysclsobjs".
DBCC mhinduro dze 'sys.sysrowsetrefs'.
Pane mitsara 0 mumapeji 0 echinhu "sys.sysrowsetrefs".
DBCC mhinduro dze 'sys.sysremsvcbinds'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysremsvcbinds”.
DBCC mhinduro dze 'sys.sysxmitqueue'.
Pane mitsara mumapeji 0 echinhu "sys.sysxmitqueue".
DBCC mhinduro dze 'sys.sysrts'.
Pane mitsara 1 mumapeji 1 echinhu "sys.sysrts".
DBCC mhinduro dze 'sys.sysconvgroup'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysconvgroup".
DBCC mhinduro dze 'sys.sysdesend'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysdesend”.
DBCC mhinduro dze 'sys.sysdercv'.
Pane mitsara mumapeji 0 echinhu "sys.sysdercv".
DBCC mhinduro dze 'sys.syssingleobjrefs'.
Pane mitsara zana nemakumi manomwe neimwe mumapeji 171 echinhu “sys.syssingleobjrefs”.
DBCC mhinduro dze 'sys.sysmultiobjrefs'.
Pane mitsara zana nenomwe mumapeji 107 echinhu “sys.sysmultiobjrefs”.
DBCC mhinduro dze 'sys.sysguidrefs'.
Pane mitsara mumapeji 0 echinhu "sys.sysguidrefs".
DBCC mhinduro dze 'sys.sysfoqueues'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.sysfoqueues".
DBCC mhinduro dze 'sys.syschildinsts'.
Kune mitsetse 0 mumapeji 0 echinhu "sys.syschildinsts".
DBCC mhinduro dze 'sys.syscompfragments'.
Pane mitsetse 0 mumapeji 0 echinhu "sys.syscompfragments".
DBCC mhinduro dze 'sys.sysftsemanticsdb'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysftsemanticsdb”.
DBCC mhinduro dze 'sys.sysftstops'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysftstops”.
DBCC mhinduro dze 'sys.sysftproperties'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysftproperties”.
DBCC mhinduro dze 'sys.sysxmitbody'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysxmitbody”.
DBCC mhinduro dze 'sys.sysfos'.
Pane mitsara mumapeji 0 echinhu "sys.sysfos".
DBCC mhinduro dze 'sys.sysqnames'.
Pane mitsara makumi mapfumbamwe nemasere mumapeji 98 echinhu "sys.sysqnames".
DBCC mhinduro dze 'sys.sysxmlcomponent'.
Pane mitsara zana mumapeji 100 echinhu "sys.sysxmlcomponent".
DBCC mhinduro dze 'sys.sysxmlfacet'.
Pane mitsara zana negumi nembiri mumapeji 112 echinhu “sys.sysxmlfacet”.
DBCC mhinduro dze 'sys.sysxmlplacement'.
Pane mitsara gumi nemipfumbamwe mumapeji 19 echinhu "sys.sysxmlplacement".
DBCC mhinduro dze 'sys.sysobjkeycrypts'.
Pane mitsara 0 mumapeji 0 echinhu "sys.sysobjkeycrypts".
DBCC mhinduro dze 'sys.sysasymkeys'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.sysasymkeys”.
DBCC mhinduro dze 'sys.syssqlguides'.
Pane mitsara 0 mumapeji 0 echinhu "sys.syssqlguides".
DBCC mhinduro dze 'sys.sysbinsubobjs'.
Pane mitsara mitatu mumapeji 3 echinhu "sys.sysbinsubobjs".
DBCC mhinduro dze 'sys.syssoftobjrefs'.
Kune mitsetse 0 mumapeji 0 echinhu "sys.syssoftobjrefs".
DBCC mhinduro dze 'sys.plan_persist_plan'.
Pane mitsara mumapeji 0 echinhu "sys.plan_persist_plan".
DBCC mhinduro dze 'sys.plan_persist_runtime_stats'.
Pane mitsara mumapeji 0 echinhu "sys.plan_persist_runtime_stats".
DBCC mhinduro dze 'sys.plan_persist_runtime_stats_interval'.
Pane mitsara 0 mumapeji 0 echinhu "sys.plan_persist_runtime_stats_interval".
DBCC mhinduro dze'sys.plan_persist_context_settings'.
Pane mitsara 0 mumapeji 0 echinhu "sys.plan_persist_context_settings".
DBCC mhinduro dze 'sys.sqlagent_jobs'.
Pane mitsara mumapeji 0 echinhu "sys.sqlagent_jobs".
DBCC mhinduro dze 'sys.sqlagent_jobsteps'.
Pane mitsara mumapeji 0 echinhu "sys.sqlagent_jobsteps".
DBCC mhinduro dze 'sys.sqlagent_job_history'.
Pane mitsara 0 mumapeji 0 echinhu "sys.sqlagent_job_history".
DBCC mhinduro dze 'sys.sqlagent_jobsteps_logs'.
Pane mitsara 0 mumapeji 0 echinhu "sys.sqlagent_jobsteps_logs".
DBCC mhinduro dze'TestTable'.
Kune mitsara 11000 mumapeji zana negumi echinhu "TestTable".
DBCC mhinduro dze 'sys.queue_messages_1977058079'.
Pane mitsara 0 mumapeji 0 echinhu "sys.queue_messages_1977058079".
DBCC mhinduro dze 'sys.queue_messages_2009058193'.
Pane mitsara 0 mumapeji 0 echinhu "sys.queue_messages_2009058193".
DBCC mhinduro dze 'sys.queue_messages_2041058307'.
Pane mitsara 0 mumapeji 0 echinhu "sys.queue_messages_2041058307".
DBCC mhinduro dze 'sys.filestream_tombstone_2073058421'.
Pane mitsara 0 mumapeji 0 echinhu "sys.filestream_tombstone_2073058421".
DBCC mhinduro dze 'sys.syscommittab'.
Pane mitsetse 0 mumapeji 0 echinhu “sys.syscommittab”.
DBCC mhinduro dze 'sys.filetable_updates_2105058535'.
Pane mitsara 0 mumapeji 0 echinhu "sys.filetable_updates_2105058535".
DBCC mhinduro dze 'sys.plan_persist_query_text'.
Pane mitsara 0 mumapeji 0 echinhu "sys.plan_persist_query_text".
DBCC mhinduro dze 'sys.plan_persist_query'.
Pane mitsara mumapeji 0 echinhu "sys.plan_persist_query".
CHECKDB yakawana 0 zvikanganiso zvekugovera uye 6 zvikanganiso zvekuenderana mudhatabhesi 'Error1'.
CHECKDB yakagadzirisa 0 zvikanganiso zvekugovera uye 4 zvikanganiso zvekuenderana mudhatabhesi 'Error1'.
DBCC kuuraya kwapera. Kana DBCC yakadhinda mhosho mameseji, bata system yako maneja.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona kukanganisa kunoenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0x9eb87140; chaiyo: 0xdeb84c40). Zvakaitika panguva yekuverenga peji (1:59) mudhatabhesi ID 39 pakubvisa 0x00000000076000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona kukanganisa kunoenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0x9eb87140; chaiyo: 0xdeb84c40). Zvakaitika panguva yekuverenga peji (1:59) mudhatabhesi ID 39 pakubvisa 0x00000000076000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona kukanganisa kunoenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0x9eb87140; chaiyo: 0xdeb84c40). Zvakaitika panguva yekuverenga peji (1:59) mudhatabhesi ID 39 pakubvisa 0x00000000076000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona kukanganisa kunoenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0x9eb87140; chaiyo: 0xdeb84c40). Zvakaitika panguva yekuverenga peji (1:59) mudhatabhesi ID 39 pakubvisa 0x00000000076000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.

uko 'Error1' izita rehuori MDF dhatabhesi iri kugadziriswa.

Msg 8992 uchiteverwa Msg 3852 kukanganisa kukanganisa kunoenderana.

Screenshot yemhosho meseji:

or

Tsanangudzo Yakananga:

mune SQL Server MDF database, kune akawanda system tables inoshandiswa kuchengetedza chimiro uye meta data yedatabase.

Kana CHECKDB ikaona paine kusawirirana pakati pematafura maviri ehurongwa, inoshuma meseji yekukanganisa Msg 8992 uye Msg 3852.

Unogona kushandisa chigadzirwa chedu DataNumen SQL Recovery kuti uwanezve data kubva kune yakaora MDF faira uye kugadzirisa kukanganisa uku.

Sample Files:

Sample huwori MDF mafaera anokonzeresa iyoMsg 8992 uye Msg 3852 mhosho:

SQL Server mhando Uori MDF faira MDF faira rakagadziriswa ne DataNumen SQL Recovery
SQL Server 2014 Error4_1.mdf Error4_1_fixed.mdf
SQL Server 2014 Error4_2.mdf Error4_2_fixed.mdf

References: