Uphawu:
Lapho usebenzisa I-DBCC CHECKDB nge LUNGISA_ALLOW_DATA_LOSS ipharamitha ukulungisa i-database eyonakele ye-MDD, enjengale:
I-DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')
ubona umlayezo wephutha olandelayo:
Ukulungisa: Inkomba eqoqiwe yakhiwe ngempumelelo yento "sysobjvalues" ku-database "Error1".
Ukulungisa: Inkomba Engavunyelwe yakhiwe ngempumelelo yento "syscolpars" ku-database "Error1".
Imiphumela ye-DBCC ye- 'Error1'.
Imiphumela ye-DBCC ye 'sys.sysrscols'.
Kunemigqa engu-1092 emakhasini ayi-14 ento “sys.sysrscols”.
Imiphumela ye-DBCC ye 'sys.sysrowsets'.
Kunemigqa eyi-148 emakhasini ama-3 ento “sys.sysrowsets”.
Imiphumela ye-DBCC ye 'sys.sysclones'.
Kunemigqa engu-0 emakhasini ayi-0 ento ethi “sys.sysclones”.
Imiphumela ye-DBCC ye 'sys.sysallocunits'.
Kunemigqa eyi-172 emakhasini ama-2 ento ethi "sys.sysallocunits".
Imiphumela ye-DBCC ye 'sys.sysfiles1'.
Kunemigqa emi-2 emakhasini ayi-1 ento ethi "sys.sysfiles1".
Imiphumela ye-DBCC ye 'sys.sysseobjvalues'.
Kunemigqa engu-0 emakhasini ayi-0 ento ethi "sys.sysseobjvalues".
Imiphumela ye-DBCC ye 'sys.syspriorities'.
Kunemigqa engu-0 emakhasini ayi-0 ento ethi “sys.syspriorities”.
Imiphumela ye-DBCC ye 'sys.sysdbfumqubuko '.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysdbfingubo endala ”.
Imiphumela ye-DBCC ye 'sys.sysfgfrag'.
Kunemigqa engu-0 emakhasini ayi-0 ento ethi “sys.sysfgfrag”.
Imiphumela ye-DBCC ye 'sys.sysdbfiles '.
Kunemigqa engu-2 emakhasini ayi-1 ento “sys.sysdbfiles ”.
Imiphumela ye-DBCC ye 'sys.syspru'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syspru”.
Imiphumela ye-DBCC ye 'sys.sysbrickfiles'.
Kunemigqa engu-0 emakhasini ayi-0 ento ethi “sys.sysbrickfiles”.
Imiphumela ye-DBCC ye 'sys.sysphfg'.
Kunemigqa engu-1 emakhasini ayi-1 ento ethi “sys.sysphfg”.
Imiphumela ye-DBCC ye 'sys.sysprufiles'.
Kunemigqa emi-2 emakhasini ayi-1 ento ethi "sys.sysprufiles".
Imiphumela ye-DBCC ye 'sys.sysftinds'.
Kunemigqa engu-0 emakhasini angu-0 ento “sys.sysftinds”.
Imiphumela ye-DBCC yama-'syssersers '.
Kunemigqa eyi-14 kumakhasi ayi-1 wento ethi "sys.sysowners".
Imiphumela ye-DBCC ye 'sys.sysdbreg'.
Kunemigqa engu-0 emakhasini angu-0 ento “sys.sysdbreg”.
Imiphumela ye-DBCC ye 'sys.sysprivs'.
Kunemigqa eyi-140 emakhasini ayi-1 ento ethi "sys.sysprivs".
Imiphumela ye-DBCC ye 'sys.syscolpars'.
Ukulungisa: Ikhasi (1:63) lisuswe endaweni ye-ID 41, i-index ID 1, i-ID yokuhlukanisa 281474979397632, i-unit unit ID 281474979397632 (thayipha idatha esemgqeni).
Ukulungisa: Inkomba Engavunyelwe yakhiwe ngempumelelo yento "sys.syscolpars, nc" ku-database "Error1".
Msg 8945, Izinga 16, State 1, Line 8
Iphutha lethebula: I-ID yento 41, i-ID yenkomba 1 izokwakhiwa kabusha.
Ayikwazanga ukulungisa leli phutha.
Msg 8978, Izinga 16, State 1, Line 8
Iphutha lethebula: I-ID yento 41, i-index ID 1, ukwahlukanisa i-ID 281474979397632, i-unit unit ID 281474979397632 (thayipha idatha esemgqeni). Ikhasi (1:61) lishoda ngesithenjwa esivela ekhasini langaphambilini (1:63). Inkinga yokuxhumeka kwamaketanga okungenzeka.
Iphutha lilungisiwe.
Msg 8928, Izinga 16, State 1, Line 8
Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data): Ikhasi (1:63) alikwazanga ukucutshungulwa. Bona amanye amaphutha ngemininingwane.
Iphutha lilungisiwe.
Msg 8939, Izinga 16, State 98, Line 8
Iphutha lethebula: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data), page (1:63). Ukuhlolwa (IS_OFF (BUF_IOERR, pBUF-> bstat)) kwehlulekile. Amanani angama-2057 no -4.
Iphutha lilungisiwe.
Msg 8976, Izinga 16, State 1, Line 8
Iphutha lethebula: I-ID yento 41, i-index ID 1, i-ID yokuhlukanisa 281474979397632, i-unit unit ID 281474979397632 (thayipha idatha esemgqeni). Ikhasi (1:63) alibonwanga kuskena yize umzali waso (1: 111) no-previous (1: 168) bebhekisa kulo. Bheka noma yimaphi amaphutha wangaphambilini.
Iphutha lilungisiwe.
Msg 8945, Izinga 16, State 1, Line 8
Iphutha lethebula: I-ID yento 41, i-ID yenkomba 2 izokwakhiwa kabusha.
Iphutha lilungisiwe.
Kunemigqa engama-881 emakhasini ayi-15 ento “sys.syscolpars”.
I-CHECKDB ithole amaphutha wesabelo ama-0 namaphutha wokungaguquguquki angu-4 kuthebula 'sys.syscolpars' (into ID 41).
I-CHECKDB ixazulule amaphutha wokwabiwa angu-0 namaphutha wokungaguquguquki ama-4 kuthebula 'sys.syscolpars' (into ID 41).
Imiphumela ye-DBCC ye 'sys.sysxlgns'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysxlgns”.
Imiphumela ye-DBCC ye 'sys.sysxsrvs'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysxsrvs”.
Imiphumela ye-DBCC ye 'sys.sysnsobjs'.
Kunemigqa eyi-1 emakhasini e-1 wento ethi "sys.sysnsobjs".
Imiphumela ye-DBCC ye 'sys.sysusermsgs'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysusermsgs”.
Imiphumela ye-DBCC ye- 'sys.syscerts'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syscerts”.
Imiphumela ye-DBCC ye 'sys.sysrmtlgns'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysrmtlgns”.
Imiphumela ye-DBCC ye 'sys.syslnklgns'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syslnklgns”.
Imiphumela ye-DBCC ye 'sys.sysxprops'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysxprops”.
Imiphumela ye-DBCC ye 'sys.sysscalartypes'.
Kunemigqa engama-34 emakhasini ayi-1 ento ethi “sys.sysscalartypes”
Imiphumela ye-DBCC ye 'sys.systypedsubobjs'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.systypedsubobjs”.
Imiphumela ye-DBCC ye 'sys.sysidxstats'.
Kunemigqa engama-207 emakhasini ama-5 ento ethi "sys.sysidxstats".
Imiphumela ye-DBCC ye 'sys.sysiscols'.
Kunemigqa engama-399 emakhasini ama-2 ento ethi "sys.sysiscols".
Imiphumela ye-DBCC ye 'sys.sysendpts'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysendpts”.
Imiphumela ye-DBCC ye 'sys.syswebmethods'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syswebmethods”.
Imiphumela ye-DBCC ye 'sys.sysbinobjs'.
Kunemigqa engama-23 emakhasini ayi-1 ento ethi "sys.sysbinobjs".
Imiphumela ye-DBCC ye 'sys.sysaudacts'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysaudacts”.
Imiphumela ye-DBCC ye 'sys.sysobjvalues'.
Ukulungisa: Inkomba eqoqiwe yakhiwe ngempumelelo yento "sys.sysobjvalues" ku-database "Error1".
Ukulungisa: Ikhasi (1:24) lisuswe endaweni ye-ID 60, i-index ID 1, i-ID yokuhlukanisa 281474980642816, i-unit unit ID 281474980642816 (thayipha idatha esemgqeni).
Ukulungisa: Kususwe ikholomu yedatha engaphandle komugqa ene-ID 742981632, ye-ID yento 60, i-index ID 1, ukwahlukanisa i-ID 281474980642816, i-unit unit ID 71776119065149440 (thayipha idatha ye-LOB) ekhasini (1: 369), slot 0.
Ukulungisa: Kususwe ikholomu yedatha engaphandle komugqa ene-ID 742981632, ye-ID yento 60, i-index ID 1, ukwahlukanisa i-ID 281474980642816, i-unit unit ID 71776119065149440 (thayipha idatha ye-LOB) ekhasini (1: 370), slot 0.
Ukulungisa: Kususwe ikholomu yedatha engaphandle komugqa ene-ID 742981632, ye-ID yento 60, i-index ID 1, ukwahlukanisa i-ID 281474980642816, i-unit unit ID 71776119065149440 (thayipha idatha ye-LOB) ekhasini (1: 371), slot 0.
Msg 8945, Izinga 16, State 1, Line 8
Iphutha lethebula: I-ID yento 60, i-ID yenkomba 1 izokwakhiwa kabusha.
Iphutha lilungisiwe.
Msg 8928, Izinga 16, State 1, Line 8
Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data): Ikhasi (1:24) alikwazanga ukucutshungulwa. Bona amanye amaphutha ngemininingwane.
Iphutha lilungisiwe.
Msg 8939, Izinga 16, State 98, Line 8
Iphutha lethebula: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data), page (1:24). Ukuhlolwa (IS_OFF (BUF_IOERR, pBUF-> bstat)) kwehlulekile. Amanani angama-2057 no -4.
Iphutha lilungisiwe.
Msg 8939, Izinga 16, State 98, Line 8
Iphutha lethebula: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data), page (1:24). Ukuhlolwa (IS_OFF (BUF_IOERR, pBUF-> bstat)) kwehlulekile. Amanani angama-2057 no -4.
Iphutha lilungisiwe.
Msg 8976, Izinga 16, State 1, Line 8
Iphutha lethebula: I-ID yento 60, i-index ID 1, i-ID yokuhlukanisa 281474980642816, i-unit unit ID 281474980642816 (thayipha idatha esemgqeni). Ikhasi (1:24) alibonwanga kuskena yize umzali waso (1: 43) no-previous (1: 213) bebhekisa kulo. Bheka noma yimaphi amaphutha wangaphambilini.
Iphutha lilungisiwe.
Msg 8978, Izinga 16, State 1, Line 8
Iphutha lethebula: I-ID yento 60, i-index ID 1, ukwahlukanisa i-ID 281474980642816, i-unit unit ID 281474980642816 (thayipha idatha esemgqeni). Ikhasi (1:210) lishoda ngesithenjwa esivela ekhasini langaphambilini (1:24). Inkinga yokuxhumeka kwamaketanga okungenzeka.
Iphutha lilungisiwe.
Msg 8964, Izinga 16, State 1, Line 8
Iphutha lethebula: I-ID yento 60, i-ID 1 yenkomba, i-ID yokuhlukanisa 281474980642816, i-unit unit ID 71776119065149440 (thayipha idatha ye-LOB). I-node yedatha eku-off ekhasini (1: 369), islot 0, umbhalo ID 742981632 awukhonjisiwe.
Iphutha lilungisiwe.
Msg 8964, Izinga 16, State 1, Line 8
Iphutha lethebula: I-ID yento 60, i-ID 1 yenkomba, i-ID yokuhlukanisa 281474980642816, i-unit unit ID 71776119065149440 (thayipha idatha ye-LOB). I-node yedatha eku-off ekhasini (1: 370), islot 0, umbhalo ID 742981632 awukhonjisiwe.
Iphutha lilungisiwe.
Msg 8964, Izinga 16, State 1, Line 8
Iphutha lethebula: I-ID yento 60, i-ID 1 yenkomba, i-ID yokuhlukanisa 281474980642816, i-unit unit ID 71776119065149440 (thayipha idatha ye-LOB). I-node yedatha eku-off ekhasini (1: 371), islot 0, umbhalo ID 742981632 awukhonjisiwe.
Iphutha lilungisiwe.
Kunemigqa engama-203 emakhasini angama-20 ento "sys.sysobjvalues".
I-CHECKDB ithole amaphutha wesabelo ama-0 namaphutha wokungaguquguquki angu-8 kuthebula 'sys.sysobjvalues' (into ID 60).
I-CHECKDB ilungise amaphutha okwabiwa okungu-0 namaphutha okungaguquguquki ayi-8 kuthebula 'sys.sysobjvalues' (into ID 60).
Imiphumela ye-DBCC ye 'sys.syscscsegsegments'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syscscsegsegments”.
Imiphumela ye-DBCC ye 'sys.syscsdictionaries'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syscsdictionaries”.
Imiphumela ye-DBCC ye 'sys.sysclsobjs'.
Kunemigqa engu-16 emakhasini ayi-1 ento “sys.sysclsobjs”.
Imiphumela ye-DBCC ye 'sys.sysrowsetrefs'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysrowsetrefs”.
Imiphumela ye-DBCC ye 'sys.sysremsvcbinds'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysremsvcbinds”.
Imiphumela ye-DBCC ye 'sys.sysxmitqueue'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysxmitqueue”.
Imiphumela ye-DBCC ye 'sys.sysrts'.
Kunemigqa engu-1 emakhasini angu-1 ento ethi “sys.sysrts”.
Imiphumela ye-DBCC ye 'sys.sysconvgroup'.
Kunemigqa engu-0 emakhasini angu-0 ento “sys.sysconvgroup”.
Imiphumela ye-DBCC ye 'sys.sysdesend'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysdesend”.
Imiphumela ye-DBCC ye 'sys.sysdercv'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysdercv”.
Imiphumela ye-DBCC ye 'sys.syssingleobjrefs'.
Kunemigqa eyi-171 emakhasini ayi-1 ento ethi "sys.syssingleobjrefs".
Imiphumela ye-DBCC ye 'sys.sysmultiobjrefs'.
Kunemigqa eyi-107 kumakhasi ayi-1 wento ethi "sys.sysmultiobjrefs".
Imiphumela ye-DBCC ye 'sys.sysguidrefs'.
Kunemigqa engu-0 emakhasini ayi-0 ento ethi “sys.sysguidrefs”.
Imiphumela ye-DBCC ye 'sys.sysfoqueues'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysfoqueues”.
Imiphumela ye-DBCC ye 'sys.syschildinsts'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syschildinsts”.
Imiphumela ye-DBCC ye 'sys.syscompfragments'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syscompfragments”.
Imiphumela ye-DBCC ye 'sys.sysftsemanticsdb'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysftsemanticsdb”.
Imiphumela ye-DBCC ye 'sys.sysftstops'.
Kunemigqa engu-0 emakhasini angu-0 ento “sys.sysftstops”.
Imiphumela ye-DBCC ye 'sys.sysftproperties'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysftproperties”.
Imiphumela ye-DBCC ye 'sys.sysxmitbody'.
Kunemigqa engu-0 emakhasini ayi-0 ento ethi "sys.sysxmitbody".
Imiphumela ye-DBCC ye- 'sys.sysfos'.
Kunemigqa engu-0 emakhasini ayi-0 ento ethi “sys.sysfos”.
Imiphumela ye-DBCC yama 'sys.sysqnames'.
Kunemigqa engama-98 kumakhasi ayi-1 ento ethi "sys.sysqnames".
Imiphumela ye-DBCC ye 'sys.sysxmlcomponent'.
Kunemigqa eyi-100 kumakhasi ayi-1 ento ethi "sys.sysxmlcomponent".
Imiphumela ye-DBCC ye 'sys.sysxmlfacet'.
Kunemigqa eyi-112 emakhasini ayi-1 ento ethi "sys.sysxmlfacet".
Imiphumela ye-DBCC ye 'sys.sysxmlplacement'.
Kunemigqa eyi-19 kumakhasi ayi-1 ento ethi "sys.sysxmlplacement".
Imiphumela ye-DBCC ye 'sys.sysobjkeycrypts'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysobjkeycrypts”.
Imiphumela ye-DBCC ye 'sys.sysasymkeys'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysasymkeys”.
Imiphumela ye-DBCC ye 'sys.syssqlguides'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syssqlguides”.
Imiphumela ye-DBCC ye 'sys.sysbinsubobjs'.
Kunemigqa emi-3 kumakhasi ayi-1 ento ethi "sys.sysbinsubobjs".
Imiphumela ye-DBCC ye 'sys.syssoftobjrefs'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syssoftobjrefs”.
Imiphumela ye-DBCC ye 'sys.plan_persist_plan'.
Kunemigqa engu-0 emakhasini angu-0 ento “sys.plan_persist_plan”.
Imiphumela ye-DBCC ye 'sys.plan_persist_runtime_stats'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.plan_persist_runtime_stats”.
Imiphumela ye-DBCC ye 'sys.plan_persist_runtime_stats_interval'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.plan_persist_runtime_stats_interval”.
Imiphumela ye-DBCC ye 'sys.plan_persist_context_settings'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.plan_persist_context_settings”.
Imiphumela ye-DBCC ye 'sys.sqlagent_jobs'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sqlagent_jobs”.
Imiphumela ye-DBCC ye 'sys.sqlagent_jobsteps'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sqlagent_jobsteps”.
Imiphumela ye-DBCC ye 'sys.sqlagent_job_history'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sqlagent_job_history”.
Imiphumela ye-DBCC ye 'sys.queue_messages_2009058193'.
Kunemigqa engu-0 emakhasini angu-0 ento “sys.queue_messages_2009058193”.
Imiphumela ye-DBCC ye 'sys.queue_messages_2041058307'.
Kunemigqa engu-0 emakhasini angu-0 ento “sys.queue_messages_2041058307”.
Imiphumela ye-DBCC ye 'sys.filestream_tombstone_2073058421'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.filestream_tombstone_2073058421”.
Imiphumela ye-DBCC ye 'sys.syscommittab'.
Kunemigqa engu-0 emakhasini ayi-0 ento ethi “sys.syscommittab”.
Imiphumela ye-DBCC ye 'sys.filetable_updates_2105058535'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.filetable_updates_2105058535”.
Imiphumela ye-DBCC ye 'sys.plan_persist_query_text'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.plan_persist_query_text”.
Imiphumela ye-DBCC ye 'sys.plan_persist_query'.
Kunemigqa engu-0 emakhasini ayi-0 ento ethi "sys.plan_persist_query".
I-CHECKDB ithole amaphutha wokwabiwa angu-0 namaphutha wokuvumelana okungu-12 ku-database 'Error1'.
I-CHECKDB ixazulule amaphutha wokwabiwa angu-0 namaphutha okungaguquguquki ayi-12 ku-database 'Error1'.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuhambisana ne-I / O: i-checksum engalungile (kulindeleke: 0xb7bd14b3; uqobo: 0xb7df14b2). Kwenzeke ngesikhathi kufundwa ikhasi (1:24) ku-ID 39 egciniwe nge-offset 0x00000000030000 kufayela 'C: Program FilesMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.mdf '. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuhambisana ne-I / O: i-checksum engalungile (kulindeleke: 0xb7bd14b3; uqobo: 0xb7df14b2). Kwenzeke ngesikhathi kufundwa ikhasi (1:24) ku-ID 39 egciniwe nge-offset 0x00000000030000 kufayela 'C: Program FilesMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.mdf '. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuhambisana ne-I / O: i-checksum engalungile (kulindeleke: 0xb7bd14b3; uqobo: 0xb7df14b2). Kwenzeke ngesikhathi kufundwa ikhasi (1:24) ku-ID 39 egciniwe nge-offset 0x00000000030000 kufayela 'C: Program FilesMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.mdf '. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-checksum engalungile (kulindeleke: 0xc8e2ed96; uqobo: 0xb8a2f3df). Kwenzeke ngesikhathi kufundwa ikhasi (1:63) ku-database ID 39 kusethi 0x0000000007e000 kufayela 'C: Program FilesMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.mdf '. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-checksum engalungile (kulindeleke: 0xc8e2ed96; uqobo: 0xb8a2f3df). Kwenzeke ngesikhathi kufundwa ikhasi (1:63) ku-database ID 39 kusethi 0x0000000007e000 kufayela 'C: Program FilesMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.mdf '. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-checksum engalungile (kulindeleke: 0xc8e2ed96; uqobo: 0xb8a2f3df). Kwenzeke ngesikhathi kufundwa ikhasi (1:63) ku-database ID 39 kusethi 0x0000000007e000 kufayela 'C: Program FilesMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.mdf '. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-checksum engalungile (kulindeleke: 0xc8e2ed96; uqobo: 0xb8a2f3df). Kwenzeke ngesikhathi kufundwa ikhasi (1:63) ku-database ID 39 kusethi 0x0000000007e000 kufayela 'C: Program FilesMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.mdf '. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
lapho i-'Error1 'igama le-database ekhohlakele ye-MDF elungiswa.
Idatha ye-8945 ikhombisa iphutha letafula okuyiphutha lokuvumelana.
Isithombe-skrini somlayezo wephutha:
Incazelo eqondile:
Phakathi ku SQL Server Imininingwane ye-MDF, kuningi amatafula wesistimu isetshenziselwe ukugcina ukwakheka nedatha ye-meta yedatha.
Lapho i-CHECKDB ithola ukuthi kunokungahambisani kwelinye lamatafula wohlelo, izobika umyalezo wephutha Msg 8945, 8978, 8928, 8939, njll. bese uzama ukulungisa amaphutha. Uma ingakwazi ukulungisa iphutha, khona-ke ukutakula kwehluleka futhi kuzoholela emaphutheni amaningi, njenge Idatha ye-824.
Ungasebenzisa umkhiqizo wethu DataNumen SQL Recovery ukubuyisa idatha kusuka kufayela le-MDF elonakele bese uxazulula leli phutha.
Amafayela Esampula:
Sampula amafayela we-MDF akhohlakele azobangela Idatha ye-8945 iphutha:
| SQL Server Version | Ifayela le-MDF elonakele | Ifayela le-MDF lilungiswe ngu DataNumen SQL Recovery |
| SQL Server 2014 | Iphutha5.mdf | Iphutha5_fixed.mdf |