Uphawu:
Xa usebenzisa DBCC CHECKDB kunye REPAIR_ALLOW_DATA_LOSS iparameter ukulungisa idatabase ye.MDF eyonakeleyo, ngolu hlobo:
I-DBCC CHECKDB(xxxx, 'REPAIR_ALLOW_DATA_LOSS')
ubona lo myalezo wemposiso ulandelayo:
Ulungiso: Isalathiso esiDityanisiweyo sakhiwe ngempumelelo kwakhona kwinto ethi "syscolpars" kwisiseko sedatha "Error1".
Ulungiso: Isalathiso esingadityaniswanga sakhiwe ngempumelelo kwakhona kwinto ethi “syscopals” kwisiseko sedatha “Error1”.
Iziphumo zeDBCC ze'Error1'.
Service Broker Msg 9675, State 1: Iindidi zoMyalezo zicazululwe: 14.
Service Broker Msg 9676, State 1: Service Contracts zicazululwe: 6.
Service Broker Msg 9667, State 1: Iinkonzo zihlalutyiweyo: 3.
Service Broker Msg 9668, State 1: Uluhlu lweNkonzo lucazululwe: 3.
Service Broker Msg 9669, State 1: Incoko Endpoints zihlalutyiweyo: 0.
Service Broker Msg 9674, State 1: Amaqela eNgxoxo ahlalutyiweyo: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings zihlalutyiweyo: 0.
Service Broker Msg 9605, State 1: IiNgxoxo eziphambili zicazululwe: 0.
Nksg 8992, iNqanaba 16, i-State 1, i-Line 8
Jonga ikhathalogu Msg 3852, State 1: Umqolo (object_id=69) kwi sys.objects (uhlobo=S ) akanalo umqolo othelekisekayo (object_id=69,column_id=1) kwi sys.columns.
Nksg 8992, iNqanaba 16, i-State 1, i-Line 8
Jonga ikhathalogu Msg 3852, State 1: Umqolo (object_id=71) kwi sys.objects (uhlobo=S ) akanalo umqolo othelekisekayo (object_id=71,column_id=1) kwi sys.columns.
Nksg 8992, iNqanaba 16, i-State 1, i-Line 8
Jonga ikhathalogu Msg 3852, State 1: Umqolo (object_id=72) kwi sys.objects (uhlobo=S ) akanalo umqolo othelekisekayo (object_id=72,column_id=1) kwi sys.columns.
Nksg 8992, iNqanaba 16, i-State 1, i-Line 8
Jonga ikhathalogu Msg 3852, State 1: Umqolo (object_id=73) kwi sys.objects (uhlobo=S ) akanalo umqolo othelekisekayo (object_id=73,column_id=1) kwi sys.columns.
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-4 zokuhambelana ezingahambelani nayo nayiphi na into enye.
Iziphumo zeDBCC ze 'sys.sysrscols'.
Kukho iirowu ezili-1092 kumaphepha ali-14 ezinto “sys.sysrscols”.
Iziphumo zeDBCC ze'sys.sysrowsets'.
Kukho iirowu ezili-148 kumaphepha ama-3 ezinto “sys.sysrowsets”.
Iziphumo zeDBCC ze-'sys.sysclones'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysclones”.
Iziphumo zeDBCC ze-'sys.sysallocunits'.
Kukho iirowu ezili-172 kumaphepha ama-2 ezinto “sys.sysallocunits”.
Iziphumo zeDBCC ze 'sys.sysfiles1'.
Kukho imiqolo emi-2 kwiphepha eli-1 lento "sys.sysfiles1".
Iziphumo zeDBCC ze 'sys.sysseobjvalues'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysseobjvalues”.
Iziphumo zeDBCC ze-'sys.syspriorities'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syspriorities”.
Iziphumo zeDBCC ze 'sys.sysdbfiragi'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento “sys.sysdbfingxowa".
Iziphumo zeDBCC ze 'sys.sysfgfrag'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysfgfrag”.
Iziphumo zeDBCC ze 'sys.sysdbfiiseli'.
Kukho imiqolo eyi-2 kumaphepha ayi-1 yento “sys.sysdbfiiseli".
Iziphumo zeDBCC ze 'sys.syspru'.
Kukho imiqolo emi-0 kumaphepha ayi-0 ezinto “sys.syspru”.
Iziphumo ze-DBCC ze-'sys.sysbrickfiles'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto "sys.sysbrickfiles".
Iziphumo zeDBCC ze 'sys.sysphfg'.
Kukho umqolo om-1 kwiphepha eli-1 lento “sys.sysphfg”.
Iziphumo zeDBCC ze'sys.sysprufiles'.
Kukho imiqolo emi-2 kwiphepha eli-1 lento "sys.sysprufiles".
Iziphumo ze-DBCC ze-'sys.sysftinds'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysftinds”.
Iziphumo zeDBCC ze 'sys.sysowners'.
Kukho iirowu ezili-14 kumaphepha a-1 ezinto “sys.sysowners”.
Iziphumo zeDBCC ze 'sys.sysdbreg'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysdbreg”.
Iziphumo zeDBCC ze 'sys.sysprivs'.
Kukho iirowu ezili-140 kwiphepha eli-1 lento "sys.sysprivs".
Iziphumo zeDBCC ze 'sys.sysschobjs'.
Kukho imiqolo engama-2262 kumaphepha angama-29 ezinto “sys.sysschobjs”.
Iziphumo zeDBCC ze 'sys.syscrowgroups'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto "sys.syscrowgroups".
Iziphumo ze-DBCC ze-'sys.sysexttables'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento "sys.sysexttables".
Iziphumo ze-DBCC ze-'sys.syscoppars'.
Ulungiso: Isalathiso esiDityanisiweyo sakhiwe ngokutsha ngempumelelo kwinto ethi “sys.syscoppars” kwisiseko sedatha “Error1”.
Ukulungisa: Iphepha (1:53) lithengiswe kwizinto ze-ID 41, i-ID yesalathiso 1, i-ID yokwahlula 281474979397632, i-alloc unit ID 281474979397632 (uhlobo lwe-In-row data).
Ulungiso: Isalathiso esingafakwanga sakhiwe ngempumelelo into ethi “sys.syscocolpars, nc” kwisiseko sedatha “Error1”.
Nksg 8945, iNqanaba 16, i-State 1, i-Line 8
Impazamo yetheyibhile: I-ID ye-Object 41, i-ID yesalathiso 1 iya kuphinda yakhiwe.
Impazamo ilungisiwe.
Nksg 8928, iNqanaba 16, i-State 1, i-Line 8
Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data): Iphepha (1:53) alikwazanga kuqhutyelwa phambili. Bona ezinye iimpazamo ngeenkcukacha.
Impazamo ilungisiwe.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Imposiso yetheyibhile: I-ID ye-Object 41, i-ID yesalathiso 1, i-ID yokwahlula 281474979397632, i-alloc unit ID 281474979397632 (uhlobo lwe-In-row data), iphepha (1:53). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Impazamo ilungisiwe.
Nksg 8976, iNqanaba 16, i-State 1, i-Line 8
Imposiso yetheyibhile: I-ID ye-Object 41, i-ID yesalathiso 1, i-ID yokwahlula 281474979397632, i-alloc unit ID 281474979397632 (uhlobo lwe-In-row data). Iphepha (1:53) alizange libonwe kwiskeni nangona umzali walo (1:111) nangaphambili (1:113) ebhekisela kulo. Jonga naziphi na iimpazamo zangaphambili.
Impazamo ilungisiwe.
Nksg 8978, iNqanaba 16, i-State 1, i-Line 8
Imposiso yetheyibhile: I-ID ye-Object 41, i-ID yesalathiso 1, i-ID yokwahlula 281474979397632, i-alloc unit ID 281474979397632 (uhlobo lwe-In-row data). Iphepha (1:56) lilahlekile ireferensi kwiphepha elidlulileyo (1:53). Ingxaki yonxibelelwano lwekhonkco enokwenzeka.
Impazamo ilungisiwe.
Nksg 8945, iNqanaba 16, i-State 1, i-Line 8
Impazamo yetheyibhile: I-ID ye-Object 41, i-ID yesalathiso 2 iya kuphinda yakhiwe.
Impazamo ilungisiwe.
Kukho iirowu ezingama-845 kumaphepha ali-15 ezinto “sys.syscoppars”.
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-4 zokuhambelana kwitheyibhile 'sys.syscocolpars' (i-ID yento 41).
I-CHECKDB ilungise iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-4 zokungqinelana kwitheyibhile 'sys.syscocolpars' (i-ID yento 41).
Iziphumo zeDBCC ze 'sys.sysxlgns'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysxlgns”.
Iziphumo zeDBCC ze 'sys.sysxsrvs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysxsrvs”.
Iziphumo zeDBCC ze 'sys.sysnsobjs'.
Kukho umqolo om-1 kwiphepha eli-1 lento “sys.sysnsobjs”.
Iziphumo zeDBCC ze 'sys.sysusermsgs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysusermsgs”.
Iziphumo zeDBCC ze-'sys.syscerts'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syscerts”.
Iziphumo zeDBCC ze-'sys.sysrmtlgns'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysrmtlgns”.
Iziphumo zeDBCC ze-'sys.syslnklgns'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syslnklgns”.
Iziphumo zeDBCC ze-'sys.sysxprops'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysxprops”.
Iziphumo zeDBCC ze-'sys.sysscalartypes'.
Kukho imiqolo engama-34 kwiphepha eli-1 lento "sys.sysscalartypes".
Iziphumo zeDBCC ze 'sys.systypedsubobjs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.systypedsubobjs”.
Iziphumo ze-DBCC ze-'sys.sysidxstats'.
Kukho iirowu ezingama-207 kumaphepha ama-5 ezinto “sys.sysidxstats”.
Iziphumo ze-DBCC ze-'sys.sysicols'.
Kukho imiqolo engama-399 kumaphepha ama-2 ezinto “sys.sysicols”.
Iziphumo zeDBCC ze'sys.sysendpts'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysendpts”.
Iziphumo ze-DBCC ze-'sys.syswebmethods'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syswebmethods”.
Iziphumo zeDBCC ze 'sys.sysbinobjs'.
Kukho imiqolo engama-23 kumaphepha a-1 ezinto “sys.sysbinobjs”.
Iziphumo ze-DBCC ze-'sys.sysaudacts'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento "sys.sysaudacts".
Iziphumo zeDBCC ze 'sys.sysobjvalues'.
Kukho imiqolo engama-213 kumaphepha angama-21 ezinto “sys.sysobjvalues”.
Iziphumo zeDBCC ze 'sys.sysccolsegments'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysccolsegments”.
Iziphumo ze-DBCC ze-'sys.syscsdictionaries'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento "sys.syscsdictionaries".
Iziphumo zeDBCC ze 'sys.sysclsobjs'.
Kukho iirowu ezili-16 kwiphepha eli-1 lento "sys.sysclsobjs".
Iziphumo zeDBCC ze 'sys.sysrowsetrefs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysrowsetrefs”.
Iziphumo zeDBCC ze 'sys.sysremsvcbinds'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysremsvcbinds”.
Iziphumo zeDBCC ze 'sys.sysmultiobjrefs'.
Kukho iirowu ezili-107 kumaphepha a-1 ezinto “sys.sysmultiobjrefs”.
Iziphumo zeDBCC ze 'sys.sysguidrefs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysguidrefs”.
Iziphumo zeDBCC ze-'sys.sysfoqueues'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysfoqueues”.
Iziphumo ze-DBCC ze-'sys.syschildinsts'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syschildinsts”.
Iziphumo zeDBCC ze 'sys.syscompfragments'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syscompfragments”.
Iziphumo zeDBCC ze 'sys.sysftsemanticsdb'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysftsemanticsdb”.
Iziphumo zeDBCC ze 'sys.sysftstops'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysftstops”.
Iziphumo zeDBCC ze 'sys.sysftproperties'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysftproperties”.
Iziphumo ze-DBCC ze-'sys.sysxmitbody'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento “sys.sysxmitbody”.
Iziphumo zeDBCC ze-'sys.sysfos'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysfos”.
Iziphumo zeDBCC ze 'sys.sysqnames'.
Kukho imiqolo engama-98 kwiphepha eli-1 lento "sys.sysqnames".
Iziphumo zeDBCC ze 'sys.sysxmlcomponent'.
Kukho iirowu ezili-100 kwiphepha eli-1 lento "sys.sysxmlcomponent".
Iziphumo zeDBCC ze 'sys.sysxmlfacet'.
Kukho iirowu ezili-112 kwiphepha eli-1 lento "sys.sysxmlfacet".
Iziphumo ze-DBCC ze-'sys.sysxmlplacement'.
Kukho iirowu ezili-19 kwiphepha eli-1 lento "sys.sysxmlplacement".
Iziphumo zeDBCC ze 'sys.sysobjkeycrypts'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysobjkeycrypts”.
Iziphumo zeDBCC ze 'sys.sysasymkeys'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysasymkeys”.
Iziphumo zeDBCC ze 'sys.syssqlguides'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto "sys.syssqlguides".
Iziphumo zeDBCC ze 'sys.sysbinsubobjs'.
Kukho imiqolo emi-3 kwiphepha eli-1 lento "sys.sysbinsubobjs".
Iziphumo zeDBCC ze 'sys.syssoftobjrefs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syssoftobjrefs”.
Iziphumo ze-DBCC ze-'sys.plan_persist_plan'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.plan_persist_plan”.
Iziphumo ze-DBCC ze-'sys.plan_persist_runtime_stats'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.plan_persist_runtime_stats”.
Iziphumo ze-DBCC ze-'sys.plan_persist_runtime_stats_interval'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.plan_persist_runtime_stats_interval”.
Iziphumo zeDBCC ze-'sys.plan_persist_context_settings'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.plan_persist_context_settings”.
Iziphumo zeDBCC ze 'sys.sqlagent_jobs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sqlagent_jobs”.
Iziphumo zeDBCC ze 'sys.sqlagent_jobsteps'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sqlagent_jobsteps”.
Iziphumo zeDBCC ze 'sys.sqlagent_job_history'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sqlagent_job_history”.
Iziphumo zeDBCC ze 'sys.sqlagent_jobsteps_logs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sqlagent_jobsteps_logs”.
Iziphumo zeDBCC ze'TestTable'.
Kukho i-11000 imiqolo kumaphepha ali-110 into "TestTable".
Iziphumo zeDBCC ze-'sys.queue_messages_1977058079'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.queue_messages_1977058079”.
Iziphumo zeDBCC ze-'sys.queue_messages_2009058193'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.queue_messages_2009058193”.
Iziphumo zeDBCC ze-'sys.queue_messages_2041058307'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.queue_messages_2041058307”.
Iziphumo zeDBCC ze 'sys.filestream_tombstone_2073058421'.
Kukho imiqolo eyi-0 kumaphepha e-0 into "sys.filestream_tombstone_2073058421".
Iziphumo zeDBCC ze 'sys.syscommittab'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento “sys.syscommittab”.
Iziphumo zeDBCC ze-'sys.filetable_updates_2105058535'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.filetable_updates_2105058535”.
Iziphumo zeDBCC ze-'sys.plan_persist_query_text'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto "sys.plan_persist_query_text".
Iziphumo ze-DBCC ze-'sys.plan_persist_query'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento “sys.plan_persist_query”.
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezisi-8 zokungqinelana kwiziko ledatha 'Error1'.
I-CHECKDB ilungise iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-4 zokungqinelana kwiziko ledatha 'Error1'.
Ukuphunyezwa kweDBCC kugqityiwe. Ukuba i-DBCC iprinte imiyalezo yemposiso, qhagamshelana nomphathi wakho wenkqubo.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchongwe impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelekileyo: 0xedf7c98; eyona: 0xed637c9c). Yenzekile ngexesha lokufunda kwephepha (1:53) kwi-database ID 39 kwi-offset 0x0000000006a000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchongwe impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelekileyo: 0xedf7c98; eyona: 0xed637c9c). Yenzekile ngexesha lokufunda kwephepha (1:53) kwi-database ID 39 kwi-offset 0x0000000006a000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchongwe impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelekileyo: 0xedf7c98; eyona: 0xed637c9c). Yenzekile ngexesha lokufunda kwephepha (1:53) kwi-database ID 39 kwi-offset 0x0000000006a000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchongwe impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelekileyo: 0xedf7c98; eyona: 0xed637c9c). Yenzekile ngexesha lokufunda kwephepha (1:53) kwi-database ID 39 kwi-offset 0x0000000006a000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchongwe impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelekileyo: 0xedf7c98; eyona: 0xed637c9c). Yenzekile ngexesha lokufunda kwephepha (1:53) kwi-database ID 39 kwi-offset 0x0000000006a000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchongwe impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelekileyo: 0xedf7c98; eyona: 0xed637c9c). Yenzekile ngexesha lokufunda kwephepha (1:53) kwi-database ID 39 kwi-offset 0x0000000006a000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
or
Ulungiso: Isalathiso esiDityanisiweyo sakhiwe ngempumelelo kwakhona kwinto ethi "syscolpars" kwisiseko sedatha "Error1".
Ulungiso: Isalathiso esingadityaniswanga sakhiwe ngempumelelo kwakhona kwinto ethi “syscopals” kwisiseko sedatha “Error1”.
Iziphumo zeDBCC ze'Error1'.
Service Broker Msg 9675, State 1: Iindidi zoMyalezo zicazululwe: 14.
Service Broker Msg 9676, State 1: Service Contracts zicazululwe: 6.
Service Broker Msg 9667, State 1: Iinkonzo zihlalutyiweyo: 3.
Service Broker Msg 9668, State 1: Uluhlu lweNkonzo lucazululwe: 3.
Service Broker Msg 9669, State 1: Incoko Endpoints zihlalutyiweyo: 0.
Service Broker Msg 9674, State 1: Amaqela eNgxoxo ahlalutyiweyo: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings zihlalutyiweyo: 0.
Service Broker Msg 9605, State 1: IiNgxoxo eziphambili zicazululwe: 0.
Nksg 8992, iNqanaba 16, i-State 1, i-Line 8
Jonga ikhathalogu Msg 3852, State 1: Umqolo (object_id=23) kwi sys.objects (uhlobo=S ) akanalo umqolo othelekisekayo (object_id=23,column_id=1) kwi sys.columns.
Nksg 8992, iNqanaba 16, i-State 1, i-Line 8
Jonga ikhathalogu Msg 3852, State 1: Umqolo (object_id=24) kwi sys.objects (uhlobo=S ) akanalo umqolo othelekisekayo (object_id=24,column_id=1) kwi sys.columns.
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-2 zokuhambelana ezingahambelani nayo nayiphi na into enye.
Iziphumo zeDBCC ze 'sys.sysrscols'.
Kukho iirowu ezili-1092 kumaphepha ali-14 ezinto “sys.sysrscols”.
Iziphumo zeDBCC ze'sys.sysrowsets'.
Kukho iirowu ezili-148 kumaphepha ama-3 ezinto “sys.sysrowsets”.
Iziphumo zeDBCC ze-'sys.sysclones'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysclones”.
Iziphumo zeDBCC ze-'sys.sysallocunits'.
Kukho iirowu ezili-172 kumaphepha ama-2 ezinto “sys.sysallocunits”.
Iziphumo zeDBCC ze 'sys.sysfiles1'.
Kukho imiqolo emi-2 kwiphepha eli-1 lento "sys.sysfiles1".
Iziphumo zeDBCC ze 'sys.sysseobjvalues'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysseobjvalues”.
Iziphumo zeDBCC ze-'sys.syspriorities'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syspriorities”.
Iziphumo zeDBCC ze 'sys.sysdbfiragi'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento “sys.sysdbfingxowa".
Iziphumo zeDBCC ze 'sys.sysfgfrag'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysfgfrag”.
Iziphumo zeDBCC ze 'sys.sysdbfiiseli'.
Kukho imiqolo eyi-2 kumaphepha ayi-1 yento “sys.sysdbfiiseli".
Iziphumo zeDBCC ze 'sys.syspru'.
Kukho imiqolo emi-0 kumaphepha ayi-0 ezinto “sys.syspru”.
Iziphumo zeDBCC ze 'sys.sysowners'.
Kukho iirowu ezili-14 kumaphepha a-1 ezinto “sys.sysowners”.
Iziphumo zeDBCC ze 'sys.sysdbreg'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysdbreg”.
Iziphumo zeDBCC ze 'sys.sysprivs'.
Kukho iirowu ezili-140 kwiphepha eli-1 lento "sys.sysprivs".
Iziphumo zeDBCC ze 'sys.sysschobjs'.
Kukho imiqolo engama-2262 kumaphepha angama-29 ezinto “sys.sysschobjs”.
Iziphumo zeDBCC ze 'sys.syscrowgroups'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto "sys.syscrowgroups".
Iziphumo ze-DBCC ze-'sys.sysexttables'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento "sys.sysexttables".
Iziphumo ze-DBCC ze-'sys.syscoppars'.
Ulungiso: Isalathiso esiDityanisiweyo sakhiwe ngokutsha ngempumelelo kwinto ethi “sys.syscoppars” kwisiseko sedatha “Error1”.
Ukulungisa: Iphepha (1:59) lithengiswe kwizinto ze-ID 41, i-ID yesalathiso 1, i-ID yokwahlula 281474979397632, i-alloc unit ID 281474979397632 (uhlobo lwe-In-row data).
Ulungiso: Isalathiso esingafakwanga sakhiwe ngempumelelo into ethi “sys.syscocolpars, nc” kwisiseko sedatha “Error1”.
Nksg 8945, iNqanaba 16, i-State 1, i-Line 8
Impazamo yetheyibhile: I-ID ye-Object 41, i-ID yesalathiso 1 iya kuphinda yakhiwe.
Impazamo ilungisiwe.
Nksg 8928, iNqanaba 16, i-State 1, i-Line 8
Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data): Iphepha (1:59) alikwazanga kuqhutyelwa phambili. Bona ezinye iimpazamo ngeenkcukacha.
Impazamo ilungisiwe.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Imposiso yetheyibhile: I-ID ye-Object 41, i-ID yesalathiso 1, i-ID yokwahlula 281474979397632, i-alloc unit ID 281474979397632 (uhlobo lwe-In-row data), iphepha (1:59). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Impazamo ilungisiwe.
Nksg 8976, iNqanaba 16, i-State 1, i-Line 8
Imposiso yetheyibhile: I-ID ye-Object 41, i-ID yesalathiso 1, i-ID yokwahlula 281474979397632, i-alloc unit ID 281474979397632 (uhlobo lwe-In-row data). Iphepha (1:59) alizange libonwe kwiskeni nangona umzali walo (1:111) nangaphambili (1:155) ebhekisela kulo. Jonga naziphi na iimpazamo zangaphambili.
Impazamo ilungisiwe.
Nksg 8978, iNqanaba 16, i-State 1, i-Line 8
Imposiso yetheyibhile: I-ID ye-Object 41, i-ID yesalathiso 1, i-ID yokwahlula 281474979397632, i-alloc unit ID 281474979397632 (uhlobo lwe-In-row data). Iphepha (1:112) lilahlekile ireferensi kwiphepha elidlulileyo (1:59). Ingxaki yonxibelelwano lwekhonkco enokwenzeka.
Impazamo ilungisiwe.
Nksg 8945, iNqanaba 16, i-State 1, i-Line 8
Impazamo yetheyibhile: I-ID ye-Object 41, i-ID yesalathiso 2 iya kuphinda yakhiwe.
Impazamo ilungisiwe.
Kukho iirowu ezingama-832 kumaphepha ali-15 ezinto “sys.syscoppars”.
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-4 zokuhambelana kwitheyibhile 'sys.syscocolpars' (i-ID yento 41).
I-CHECKDB ilungise iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-4 zokungqinelana kwitheyibhile 'sys.syscocolpars' (i-ID yento 41).
Iziphumo zeDBCC ze 'sys.sysxlgns'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysxlgns”.
Iziphumo zeDBCC ze 'sys.sysxsrvs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysxsrvs”.
Iziphumo zeDBCC ze 'sys.sysnsobjs'.
Kukho umqolo om-1 kwiphepha eli-1 lento “sys.sysnsobjs”.
Iziphumo zeDBCC ze 'sys.sysusermsgs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysusermsgs”.
Iziphumo zeDBCC ze-'sys.syscerts'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syscerts”.
Iziphumo zeDBCC ze-'sys.sysrmtlgns'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysrmtlgns”.
Iziphumo zeDBCC ze-'sys.syslnklgns'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syslnklgns”.
Iziphumo zeDBCC ze-'sys.sysxprops'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysxprops”.
Iziphumo zeDBCC ze-'sys.sysscalartypes'.
Kukho imiqolo engama-34 kwiphepha eli-1 lento "sys.sysscalartypes".
Iziphumo zeDBCC ze 'sys.systypedsubobjs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.systypedsubobjs”.
Iziphumo ze-DBCC ze-'sys.sysidxstats'.
Kukho iirowu ezingama-207 kumaphepha ama-5 ezinto “sys.sysidxstats”.
Iziphumo ze-DBCC ze-'sys.sysicols'.
Kukho imiqolo engama-399 kumaphepha ama-2 ezinto “sys.sysicols”.
Iziphumo zeDBCC ze'sys.sysendpts'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysendpts”.
Iziphumo ze-DBCC ze-'sys.syswebmethods'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syswebmethods”.
Iziphumo zeDBCC ze 'sys.sysbinobjs'.
Kukho imiqolo engama-23 kumaphepha a-1 ezinto “sys.sysbinobjs”.
Iziphumo ze-DBCC ze-'sys.sysaudacts'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento "sys.sysaudacts".
Iziphumo zeDBCC ze 'sys.sysobjvalues'.
Kukho imiqolo engama-213 kumaphepha angama-21 ezinto “sys.sysobjvalues”.
Iziphumo zeDBCC ze 'sys.sysccolsegments'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysccolsegments”.
Iziphumo ze-DBCC ze-'sys.syscsdictionaries'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento "sys.syscsdictionaries".
Iziphumo zeDBCC ze 'sys.sysclsobjs'.
Kukho iirowu ezili-16 kwiphepha eli-1 lento "sys.sysclsobjs".
Iziphumo zeDBCC ze 'sys.sysrowsetrefs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysrowsetrefs”.
Iziphumo zeDBCC ze 'sys.sysremsvcbinds'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysremsvcbinds”.
Iziphumo zeDBCC ze 'sys.sysxmitqueue'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento "sys.sysxmitqueue".
Iziphumo zeDBCC ze-'sys.sysrts'.
Kukho umqolo om-1 kwiphepha eli-1 lento "sys.sysrts".
Iziphumo zeDBCC ze'sys.sysconvgroup'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto "sys.sysconvgroup".
Iziphumo zeDBCC ze-'sys.sysdesend'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysdesend”.
Iziphumo zeDBCC ze-'sys.sysdercv'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysdercv”.
Iziphumo zeDBCC ze 'sys.syssingleobjrefs'.
Kukho imiqolo eyi-171 kumaphepha a-1 ezinto “sys.syssingleobjrefs”.
Iziphumo zeDBCC ze 'sys.sysmultiobjrefs'.
Kukho iirowu ezili-107 kumaphepha a-1 ezinto “sys.sysmultiobjrefs”.
Iziphumo zeDBCC ze 'sys.sysguidrefs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysguidrefs”.
Iziphumo zeDBCC ze-'sys.sysfoqueues'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysfoqueues”.
Iziphumo ze-DBCC ze-'sys.syschildinsts'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syschildinsts”.
Iziphumo zeDBCC ze 'sys.syscompfragments'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syscompfragments”.
Iziphumo zeDBCC ze 'sys.sysftsemanticsdb'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysftsemanticsdb”.
Iziphumo zeDBCC ze 'sys.sysftstops'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysftstops”.
Iziphumo zeDBCC ze 'sys.sysftproperties'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysftproperties”.
Iziphumo ze-DBCC ze-'sys.sysxmitbody'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento “sys.sysxmitbody”.
Iziphumo zeDBCC ze-'sys.sysfos'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysfos”.
Iziphumo zeDBCC ze 'sys.sysqnames'.
Kukho imiqolo engama-98 kwiphepha eli-1 lento "sys.sysqnames".
Iziphumo zeDBCC ze 'sys.sysxmlcomponent'.
Kukho iirowu ezili-100 kwiphepha eli-1 lento "sys.sysxmlcomponent".
Iziphumo zeDBCC ze 'sys.sysxmlfacet'.
Kukho iirowu ezili-112 kwiphepha eli-1 lento "sys.sysxmlfacet".
Iziphumo ze-DBCC ze-'sys.sysxmlplacement'.
Kukho iirowu ezili-19 kwiphepha eli-1 lento "sys.sysxmlplacement".
Iziphumo zeDBCC ze 'sys.sysobjkeycrypts'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysobjkeycrypts”.
Iziphumo zeDBCC ze 'sys.sysasymkeys'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sysasymkeys”.
Iziphumo zeDBCC ze 'sys.syssqlguides'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto "sys.syssqlguides".
Iziphumo zeDBCC ze 'sys.sysbinsubobjs'.
Kukho imiqolo emi-3 kwiphepha eli-1 lento "sys.sysbinsubobjs".
Iziphumo zeDBCC ze 'sys.syssoftobjrefs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.syssoftobjrefs”.
Iziphumo ze-DBCC ze-'sys.plan_persist_plan'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.plan_persist_plan”.
Iziphumo ze-DBCC ze-'sys.plan_persist_runtime_stats'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.plan_persist_runtime_stats”.
Iziphumo ze-DBCC ze-'sys.plan_persist_runtime_stats_interval'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.plan_persist_runtime_stats_interval”.
Iziphumo zeDBCC ze-'sys.plan_persist_context_settings'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.plan_persist_context_settings”.
Iziphumo zeDBCC ze 'sys.sqlagent_jobs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sqlagent_jobs”.
Iziphumo zeDBCC ze 'sys.sqlagent_jobsteps'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sqlagent_jobsteps”.
Iziphumo zeDBCC ze 'sys.sqlagent_job_history'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sqlagent_job_history”.
Iziphumo zeDBCC ze 'sys.sqlagent_jobsteps_logs'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.sqlagent_jobsteps_logs”.
Iziphumo zeDBCC ze'TestTable'.
Kukho i-11000 imiqolo kumaphepha ali-110 into "TestTable".
Iziphumo zeDBCC ze-'sys.queue_messages_1977058079'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.queue_messages_1977058079”.
Iziphumo zeDBCC ze-'sys.queue_messages_2009058193'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.queue_messages_2009058193”.
Iziphumo zeDBCC ze-'sys.queue_messages_2041058307'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.queue_messages_2041058307”.
Iziphumo zeDBCC ze 'sys.filestream_tombstone_2073058421'.
Kukho imiqolo eyi-0 kumaphepha e-0 into "sys.filestream_tombstone_2073058421".
Iziphumo zeDBCC ze 'sys.syscommittab'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento “sys.syscommittab”.
Iziphumo zeDBCC ze-'sys.filetable_updates_2105058535'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto “sys.filetable_updates_2105058535”.
Iziphumo zeDBCC ze-'sys.plan_persist_query_text'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 ezinto "sys.plan_persist_query_text".
Iziphumo ze-DBCC ze-'sys.plan_persist_query'.
Kukho imiqolo eyi-0 kumaphepha ayi-0 yento “sys.plan_persist_query”.
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezisi-6 zokungqinelana kwiziko ledatha 'Error1'.
I-CHECKDB ilungise iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-4 zokungqinelana kwiziko ledatha 'Error1'.
Ukuphunyezwa kweDBCC kugqityiwe. Ukuba i-DBCC iprinte imiyalezo yemposiso, qhagamshelana nomphathi wakho wenkqubo.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchonge impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelweyo: 0x9eb87140; eyona: 0xdeb84c40). Yenzekile ngexesha lokufunda kwephepha (1:59) kwi-database ID 39 kwi-offset 0x00000000076000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchonge impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelweyo: 0x9eb87140; eyona: 0xdeb84c40). Yenzekile ngexesha lokufunda kwephepha (1:59) kwi-database ID 39 kwi-offset 0x00000000076000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchonge impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelweyo: 0x9eb87140; eyona: 0xdeb84c40). Yenzekile ngexesha lokufunda kwephepha (1:59) kwi-database ID 39 kwi-offset 0x00000000076000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchonge impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (elindelweyo: 0x9eb87140; eyona: 0xdeb84c40). Yenzekile ngexesha lokufunda kwephepha (1:59) kwi-database ID 39 kwi-offset 0x00000000076000 kwifayile 'C: Iifayile zeNkquboMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.
apho 'Imposiso1' ligama lesiseko sedatha esonakeleyo se-MDF elungiswayo.
UMsg 8992 ilandelwe ngu UMsg 3852 imposiso yimpazamo yokungaguquguquki.
Umfanekiso weskrini wemposiso:
or
Ingcaciso echanekileyo:
Kwi SQL Server MDF database, zininzi iitafile zenkqubo isetyenziselwa ukugcina ubume kunye nedatha yemeta yedatabase.
Xa i-CHECKDB ifumanisa ukuba kukho ukungangqinelani phakathi kweetafile ezimbini zesixokelelwano, iya kuchaza umyalezo wemposiso Msg 8992 kunye noMsg 3852.
Ungasebenzisa imveliso yethu DataNumen SQL Recovery ukubuyisela idatha kwifayile ye-MDF eyonakele kwaye uyisombulule le mpazamo.
Iifayili zesampulu:
Isampulu yeefayile zeMDF ezonakeleyo eziya kubangela iMsg 8992 kunye noMsg 3852 imposiso:
| SQL Server Inguqulelo | Ifayile ye-MDF eyonakele | Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery |
| SQL Server 2014 | Imposiso4_1.mdf | Imposiso4_1_fixed.mdf |
| SQL Server 2014 | Imposiso4_2.mdf | Imposiso4_2_fixed.mdf |