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 "syscolpars" ku-database "Error1".
Ukulungisa: Inkomba Engavunyelwe yakhiwe ngempumelelo yento "syscolpars" ku-database "Error1".
Imiphumela ye-DBCC ye- 'Error1'.
I-Service Broker Msg 9675, State 1: Izinhlobo Zemiyalezo zihlaziyiwe: 14.
I-Service Broker Msg 9676, Isifundazwe 1: Kuhlaziyiwe Izinkontileka Zezinsizakalo: 6.
I-Service Broker Msg 9667, State 1: Izinsizakalo zihlaziyiwe: 3.
I-Service Broker Msg 9668, State 1: Imigqa Yezinsizakalo ihlaziyiwe: 3.
I-Service Broker Msg 9669, State 1: Amaphuzu Engxoxo Ahlaziyiwe: 0.
I-Service Broker Msg 9674, State 1: Amaqembu Engxoxo ahlaziyiwe: 0.
IService Broker Msg 9670, State 1: Remote Service Bindings ihlaziyiwe: 0.
I-Service Broker Msg 9605, State 1: Izingxoxo Eziphambili Kuhlaziyiwe: 0.
Msg 8992, Izinga 16, State 1, Line 8
Bheka ikhathalogi Msg 3852, State 1: Row (object_id = 69) in sys.objects (type = S) ayinalo umugqa ofanayo (object_id = 69, column_id = 1) in sys.columns.
Msg 8992, Izinga 16, State 1, Line 8
Bheka ikhathalogi Msg 3852, State 1: Row (object_id = 71) in sys.objects (type = S) ayinalo umugqa ofanayo (object_id = 71, column_id = 1) in sys.columns.
Msg 8992, Izinga 16, State 1, Line 8
Bheka ikhathalogi Msg 3852, State 1: Row (object_id = 72) in sys.objects (type = S) ayinalo umugqa ofanayo (object_id = 72, column_id = 1) in sys.columns.
Msg 8992, Izinga 16, State 1, Line 8
Bheka ikhathalogi Msg 3852, State 1: Row (object_id = 73) in sys.objects (type = S) ayinalo umugqa ofanayo (object_id = 73, column_id = 1) in sys.columns.
I-CHECKDB ithole amaphutha wesabelo esingu-0 namaphutha wokungaguquguquki angu-4 angahlotshaniswa nanoma iyiphi into eyodwa.
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.sysschobjs'.
Kunemigqa engama-2262 emakhasini angama-29 ento “sys.sysschobjs”.
Imiphumela ye-DBCC ye 'sys.syscsrowgroups'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syscsrowgroups”.
Imiphumela ye-DBCC ye 'sys.sysexttables'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysexttables”.
Imiphumela ye-DBCC ye 'sys.syscolpars'.
Ukulungisa: Inkomba eqoqiwe yakhiwe ngempumelelo yento "sys.syscolpars" ku-database "Error1".
Ukulungisa: Ikhasi (1:53) 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.
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:53) 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:53). 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:53) alibonwanga kuskena yize umzali waso (1: 111) no-previous (1: 113) bebhekisa kulo. Bheka noma yimaphi amaphutha wangaphambilini.
Iphutha lilungisiwe.
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:56) lishoda ngesithenjwa esivela ekhasini langaphambilini (1:53). Inkinga yokuxhumeka kwamaketanga okungenzeka.
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-845 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'.
Kunemigqa engama-213 emakhasini angama-21 ento "sys.sysobjvalues".
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.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.sqlagent_jobsteps_logs'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sqlagent_jobsteps_logs”.
Imiphumela ye-DBCC ye-'TestTable '.
Kunemigqa engama-11000 emakhasini angama-110 ento ethi “TestTable”.
Imiphumela ye-DBCC ye 'sys.queue_messages_1977058079'.
Kunemigqa engu-0 emakhasini angu-0 ento “sys.queue_messages_1977058079”.
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-8 ku-database 'Error1'.
I-CHECKDB ixazulule amaphutha wokwabiwa angu-0 namaphutha okungaguquguquki ayi-4 ku-database 'Error1'.
Ukwenziwa kwe-DBCC kuqediwe. Uma i-DBCC iphrinte imilayezo yephutha, xhumana nomphathi wohlelo lwakho.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-checksum engalungile (kulindeleke: 0xeddf7c98; uqobo: 0xed637c9c). Kwenzeke ngesikhathi kufundwa ikhasi (1:53) ku-ID 39 egciniwe nge-offset 0x0000000006a000 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: 0xeddf7c98; uqobo: 0xed637c9c). Kwenzeke ngesikhathi kufundwa ikhasi (1:53) ku-ID 39 egciniwe nge-offset 0x0000000006a000 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: 0xeddf7c98; uqobo: 0xed637c9c). Kwenzeke ngesikhathi kufundwa ikhasi (1:53) ku-ID 39 egciniwe nge-offset 0x0000000006a000 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: 0xeddf7c98; uqobo: 0xed637c9c). Kwenzeke ngesikhathi kufundwa ikhasi (1:53) ku-ID 39 egciniwe nge-offset 0x0000000006a000 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: 0xeddf7c98; uqobo: 0xed637c9c). Kwenzeke ngesikhathi kufundwa ikhasi (1:53) ku-ID 39 egciniwe nge-offset 0x0000000006a000 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: 0xeddf7c98; uqobo: 0xed637c9c). Kwenzeke ngesikhathi kufundwa ikhasi (1:53) ku-ID 39 egciniwe nge-offset 0x0000000006a000 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.
or
Ukulungisa: Inkomba eqoqiwe yakhiwe ngempumelelo yento "syscolpars" ku-database "Error1".
Ukulungisa: Inkomba Engavunyelwe yakhiwe ngempumelelo yento "syscolpars" ku-database "Error1".
Imiphumela ye-DBCC ye- 'Error1'.
I-Service Broker Msg 9675, State 1: Izinhlobo Zemiyalezo zihlaziyiwe: 14.
I-Service Broker Msg 9676, Isifundazwe 1: Kuhlaziyiwe Izinkontileka Zezinsizakalo: 6.
I-Service Broker Msg 9667, State 1: Izinsizakalo zihlaziyiwe: 3.
I-Service Broker Msg 9668, State 1: Imigqa Yezinsizakalo ihlaziyiwe: 3.
I-Service Broker Msg 9669, State 1: Amaphuzu Engxoxo Ahlaziyiwe: 0.
I-Service Broker Msg 9674, State 1: Amaqembu Engxoxo ahlaziyiwe: 0.
IService Broker Msg 9670, State 1: Remote Service Bindings ihlaziyiwe: 0.
I-Service Broker Msg 9605, State 1: Izingxoxo Eziphambili Kuhlaziyiwe: 0.
Msg 8992, Izinga 16, State 1, Line 8
Bheka ikhathalogi Msg 3852, State 1: Row (object_id = 23) in sys.objects (type = S) ayinalo umugqa ofanayo (object_id = 23, column_id = 1) in sys.columns.
Msg 8992, Izinga 16, State 1, Line 8
Bheka ikhathalogi Msg 3852, State 1: Row (object_id = 24) in sys.objects (type = S) ayinalo umugqa ofanayo (object_id = 24, column_id = 1) in sys.columns.
I-CHECKDB ithole amaphutha wesabelo esingu-0 namaphutha wokungaguquguquki angu-2 angahlotshaniswa nanoma iyiphi into eyodwa.
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 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.sysschobjs'.
Kunemigqa engama-2262 emakhasini angama-29 ento “sys.sysschobjs”.
Imiphumela ye-DBCC ye 'sys.syscsrowgroups'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.syscsrowgroups”.
Imiphumela ye-DBCC ye 'sys.sysexttables'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sysexttables”.
Imiphumela ye-DBCC ye 'sys.syscolpars'.
Ukulungisa: Inkomba eqoqiwe yakhiwe ngempumelelo yento "sys.syscolpars" ku-database "Error1".
Ukulungisa: Ikhasi (1:59) 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.
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:59) 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:59). 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:59) alibonwanga kuskena yize umzali waso (1: 111) no-previous (1: 155) bebhekisa kulo. Bheka noma yimaphi amaphutha wangaphambilini.
Iphutha lilungisiwe.
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:112) lishoda ngesithenjwa esivela ekhasini langaphambilini (1:59). Inkinga yokuxhumeka kwamaketanga okungenzeka.
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-832 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'.
Kunemigqa engama-213 emakhasini angama-21 ento "sys.sysobjvalues".
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.sqlagent_jobsteps_logs'.
Kunemigqa engu-0 emakhasini ayi-0 ento “sys.sqlagent_jobsteps_logs”.
Imiphumela ye-DBCC ye-'TestTable '.
Kunemigqa engama-11000 emakhasini angama-110 ento ethi “TestTable”.
Imiphumela ye-DBCC ye 'sys.queue_messages_1977058079'.
Kunemigqa engu-0 emakhasini angu-0 ento “sys.queue_messages_1977058079”.
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-6 ku-database 'Error1'.
I-CHECKDB ixazulule amaphutha wokwabiwa angu-0 namaphutha okungaguquguquki ayi-4 ku-database 'Error1'.
Ukwenziwa kwe-DBCC kuqediwe. Uma i-DBCC iphrinte imilayezo yephutha, xhumana nomphathi wohlelo lwakho.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuhambisana ne-I / O: i-checksum engalungile (kulindeleke: 0x9eb87140; uqobo: 0xdeb84c40). Kwenzeke ngesikhathi kufundwa ikhasi (1:59) kwi-database ID 39 kusethi 0x00000000076000 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: 0x9eb87140; uqobo: 0xdeb84c40). Kwenzeke ngesikhathi kufundwa ikhasi (1:59) kwi-database ID 39 kusethi 0x00000000076000 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: 0x9eb87140; uqobo: 0xdeb84c40). Kwenzeke ngesikhathi kufundwa ikhasi (1:59) kwi-database ID 39 kusethi 0x00000000076000 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: 0x9eb87140; uqobo: 0xdeb84c40). Kwenzeke ngesikhathi kufundwa ikhasi (1:59) kwi-database ID 39 kusethi 0x00000000076000 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-8992 ulandelwa ngu Idatha ye-3852 iphutha iphutha lokuvumelana.
Isithombe-skrini somlayezo wephutha:
or
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 phakathi kwamatafula amabili wohlelo, izobika umyalezo wephutha UMsg 8992 noMsg 3852.
Ungasebenzisa umkhiqizo wethu DataNumen SQL Recovery ukubuyisa idatha kusuka kufayela le-MDF elonakele bese uxazulula leli phutha.
Amafayela Esampula:
Sampula amafayela we-MDF akhohlakele azobangelaUMsg 8992 noMsg 3852 iphutha:
| SQL Server Version | Ifayela le-MDF elonakele | Ifayela le-MDF lilungiswe ngu DataNumen SQL Recovery |
| SQL Server 2014 | Iphutha4_1.mdf | Iphutha4_1_fixed.mdf |
| SQL Server 2014 | Iphutha4_2.mdf | Iphutha4_2_fixed.mdf |