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 index yakabudirira kuvakwazve kwechinhu "sysobjvalues" mudhatabhesi "Error1".
Gadzirisa: Iyo Nonclustered index yakabudirira kuvakwazve kwechinhu "syscoppars" mudhatabhesi "Error1".
DBCC mhinduro dze'Error1'.
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.syscoppars'.
Kugadzirisa: Iyo peji (1:63) 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.
Hatina kukwanisa kugadzirisa kukanganisa uku.
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:61) haina chirevo kubva papeji yapfuura (1:63). Dambudziko rekubatanidza cheni rinogona kuitika.
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:63) 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:63). 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:63) haina kuonekwa mu scan kunyange mubereki wayo (1:111) uye yapfuura (1:168) vachireva nezvayo. Tarisa chero zvikanganiso zvekare.
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 881 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'.
Gadzirisa: Iyo Clustered indekisi yakabudirira kuvaka patsva yechinhu "sys.sysobjvalues" mudhatabhesi "Error1".
Kugadzirisa: Iyo peji (1:24) yakatorwa kubva kuchinhu ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data).
Kugadzirisa: Yakadzimwa off-row data column ine ID 742981632, yechinhu ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data) pane peji (1:369), 0.
Kugadzirisa: Yakadzimwa off-row data column ine ID 742981632, yechinhu ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data) pane peji (1:370), 0.
Kugadzirisa: Yakadzimwa off-row data column ine ID 742981632, yechinhu ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data) pane peji (1:371), 0.
Msg 8945, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 60, index ID 1 ichavakwa patsva.
Iko kukanganisa kwagadziriswa.
Msg 8928, Chikamu 16, State 1, Mutsara 8
Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data): Peji (1:24) yatadza kugadziriswa. Ona zvimwe zvikanganiso kuti uwane ruzivo.
Iko kukanganisa kwagadziriswa.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data), peji (1:24). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Iko kukanganisa kwagadziriswa.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data), peji (1:24). 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 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). Peji (1:24) haina kuonekwa mu scan kunyange mubereki wayo (1:43) uye yapfuura (1:213) vachireva nezvayo. Tarisa chero zvikanganiso zvekare.
Iko kukanganisa kwagadziriswa.
Msg 8978, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). Peji (1:210) haina chirevo kubva papeji yapfuura (1:24). Dambudziko rekubatanidza cheni rinogona kuitika.
Iko kukanganisa kwagadziriswa.
Msg 8964, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (mhando LOB data). Iyo off-row data node pane peji (1:369), slot 0, chinyorwa ID 742981632 haina kutaurwa.
Iko kukanganisa kwagadziriswa.
Msg 8964, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (mhando LOB data). Iyo off-row data node pane peji (1:370), slot 0, chinyorwa ID 742981632 haina kutaurwa.
Iko kukanganisa kwagadziriswa.
Msg 8964, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (mhando LOB data). Iyo off-row data node pane peji (1:371), slot 0, chinyorwa ID 742981632 haina kutaurwa.
Iko kukanganisa kwagadziriswa.
Pane mitsara mazana maviri negumi nematatu mumapeji makumi maviri nerimwe echinhu “sys.sysobjvalues”.
CHECKDB yakawana 0 kukanganisa kwekugoverwa uye 8 zvikanganiso zvekuenderana mutafura 'sys.sysobjvalues' (chinhu ID 60).
CHECKDB yakagadzirisa 0 zvikanganiso zvekugovera uye 8 zvikanganiso zvekuenderana mutafura 'sys.sysobjvalues' (chinhu ID 60).
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.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 12 zvikanganiso zvekuenderana mudhatabhesi 'Error1'.
CHECKDB yakagadzirisa 0 zvikanganiso zvekugovera uye 12 zvikanganiso zvekuenderana mudhatabhesi 'Error1'.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona kukanganisa-kwakavakirwa I/O kukanganisa: cheki isiriyo (inotarisirwa: 0xb7bd14b3; chaiyo: 0xb7df14b2). Zvakaitika panguva yekuverenga peji (1:24) mudhatabhesi ID 39 pakubvisa 0x00000000030000 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-kwakavakirwa I/O kukanganisa: cheki isiriyo (inotarisirwa: 0xb7bd14b3; chaiyo: 0xb7df14b2). Zvakaitika panguva yekuverenga peji (1:24) mudhatabhesi ID 39 pakubvisa 0x00000000030000 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-kwakavakirwa I/O kukanganisa: cheki isiriyo (inotarisirwa: 0xb7bd14b3; chaiyo: 0xb7df14b2). Zvakaitika panguva yekuverenga peji (1:24) mudhatabhesi ID 39 pakubvisa 0x00000000030000 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-kwakavakirwa I / O kukanganisa: cheki isiriyo (inotarisirwa: 0xc8e2ed96; chaiyo: 0xb8a2f3df). Zvakaitika panguva yekuverenga peji (1:63) mudhatabhesi ID 39 pakubvisa 0x0000000007e000 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-kwakavakirwa I / O kukanganisa: cheki isiriyo (inotarisirwa: 0xc8e2ed96; chaiyo: 0xb8a2f3df). Zvakaitika panguva yekuverenga peji (1:63) mudhatabhesi ID 39 pakubvisa 0x0000000007e000 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-kwakavakirwa I / O kukanganisa: cheki isiriyo (inotarisirwa: 0xc8e2ed96; chaiyo: 0xb8a2f3df). Zvakaitika panguva yekuverenga peji (1:63) mudhatabhesi ID 39 pakubvisa 0x0000000007e000 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-kwakavakirwa I / O kukanganisa: cheki isiriyo (inotarisirwa: 0xc8e2ed96; chaiyo: 0xb8a2f3df). Zvakaitika panguva yekuverenga peji (1:63) mudhatabhesi ID 39 pakubvisa 0x0000000007e000 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 8945 inoratidza kukanganisa kwetafura inova kukanganisa kwekusagadzikana.
Screenshot yemhosho meseji:
Tsanangudzo Yakananga:
mune SQL Server MDF database, kune akawanda system tables inoshandiswa kuchengetedza chimiro uye meta data yedatabase.
Kana CHECKDB ikaona paine kusawirirana mune imwe yematafura system, inoshuma meseji yekukanganisa. Msg 8945, 8978, 8928, 8939, nezvimwe. uye edza kugadzirisa zvikanganiso. Kana iyo isingakwanisi kugadzirisa kukanganisa, ipapo kupora kunokundikana uye kunotungamirira kune zvikanganiso zvakawanda, zvakadai Msg 824.
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 iyo Msg 8945 mhosho:
| SQL Server mhando | Uori MDF faira | MDF faira rakagadziriswa ne DataNumen SQL Recovery |
| SQL Server 2014 | Kukanganisa5.mdf | Error5_fixed.mdf |