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: Isalathisi esiDityanisiweyo sakhiwe ngempumelelo kwakhona kwinto ethi "sysobjvalues" kwisiseko sedatha "Impazamo1".
Ulungiso: Isalathiso esingadityaniswanga sakhiwe ngempumelelo kwakhona kwinto ethi “syscopals” kwisiseko sedatha “Error1”.
Iziphumo zeDBCC ze'Error1'.
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 ze-DBCC ze-'sys.syscoppars'.
Ukulungisa: Iphepha (1:63) 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.
Ayikwazanga ukulungisa le mpazamo.
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:61) lilahlekile ireferensi kwiphepha elidlulileyo (1:63). Ingxaki yonxibelelwano lwekhonkco enokwenzeka.
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:63) 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:63). 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:63) alizange libonwe kwiskeni nangona umzali walo (1:111) nangaphambili (1:168) ebhekisela kulo. Jonga naziphi na iimpazamo zangaphambili.
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-881 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'.
Ulungiso: Isalathisi esiDityanisiweyo sakhiwe ngempumelelo kwakhona kwinto ethi "sys.sysobjvalues" kwisiseko sedatha "Impazamo1".
Ukulungisa: Iphepha (1:24) lithengiswe kwizinto ze-ID 60, i-ID yesalathiso 1, i-ID yokwahlula 281474980642816, i-alloc unit ID 281474980642816 (uhlobo lwe-In-row data).
Ukulungisa: Icinyiwe kwikholamu yedatha ye-ID 742981632, into ye-ID 60, i-ID yesalathisi 1, i-ID yecandelo 281474980642816, i-alloc unit ID 71776119065149440 (uhlobo lwedatha ye-LOB) kwiphepha (1: 369), slot 0
Ukulungisa: Icinyiwe kwikholamu yedatha ye-ID 742981632, into ye-ID 60, i-ID yesalathisi 1, i-ID yecandelo 281474980642816, i-alloc unit ID 71776119065149440 (uhlobo lwedatha ye-LOB) kwiphepha (1: 370), slot 0
Ukulungisa: Icinyiwe kwikholamu yedatha ye-ID 742981632, into ye-ID 60, i-ID yesalathisi 1, i-ID yecandelo 281474980642816, i-alloc unit ID 71776119065149440 (uhlobo lwedatha ye-LOB) kwiphepha (1: 371), slot 0
Nksg 8945, iNqanaba 16, i-State 1, i-Line 8
Impazamo yetheyibhile: I-ID ye-Object 60, i-ID yesalathiso 1 iya kuphinda yakhiwe.
Impazamo ilungisiwe.
Nksg 8928, iNqanaba 16, i-State 1, i-Line 8
Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data): Iphepha (1:24) 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 60, i-ID yesalathiso 1, i-ID yokwahlula 281474980642816, i-alloc unit ID 281474980642816 (uhlobo lwe-In-row data), iphepha (1:24). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Impazamo ilungisiwe.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Imposiso yetheyibhile: I-ID ye-Object 60, i-ID yesalathiso 1, i-ID yokwahlula 281474980642816, i-alloc unit ID 281474980642816 (uhlobo lwe-In-row data), iphepha (1:24). 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 60, i-ID yesalathiso 1, i-ID yokwahlula 281474980642816, i-alloc unit ID 281474980642816 (uhlobo lwe-In-row data). Iphepha (1:24) alizange libonwe kwiskeni nangona umzali walo (1:43) nangaphambili (1:213) 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 60, i-ID yesalathiso 1, i-ID yokwahlula 281474980642816, i-alloc unit ID 281474980642816 (uhlobo lwe-In-row data). Iphepha (1:210) lilahlekile ireferensi kwiphepha elidlulileyo (1:24). Ingxaki yonxibelelwano lwekhonkco enokwenzeka.
Impazamo ilungisiwe.
Nksg 8964, iNqanaba 16, i-State 1, i-Line 8
Impazamo yetheyibhile: I-ID ye-Object 60, i-ID yesalathiso 1, i-ID yokwahlula 281474980642816, i-alloc unit ID 71776119065149440 (uhlobo lwedatha ye-LOB). I-off-row data node kwiphepha (1:369), slot 0, umbhalo ID 742981632 akukho reference.
Impazamo ilungisiwe.
Nksg 8964, iNqanaba 16, i-State 1, i-Line 8
Impazamo yetheyibhile: I-ID ye-Object 60, i-ID yesalathiso 1, i-ID yokwahlula 281474980642816, i-alloc unit ID 71776119065149440 (uhlobo lwedatha ye-LOB). I-off-row data node kwiphepha (1:370), slot 0, umbhalo ID 742981632 akukho reference.
Impazamo ilungisiwe.
Nksg 8964, iNqanaba 16, i-State 1, i-Line 8
Impazamo yetheyibhile: I-ID ye-Object 60, i-ID yesalathiso 1, i-ID yokwahlula 281474980642816, i-alloc unit ID 71776119065149440 (uhlobo lwedatha ye-LOB). I-off-row data node kwiphepha (1:371), slot 0, umbhalo ID 742981632 akukho reference.
Impazamo ilungisiwe.
Kukho imiqolo engama-203 kumaphepha angama-20 ezinto “sys.sysobjvalues”.
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-8 zokuhambelana kwitheyibhile 'sys.sysobjvalues' (i-ID yento 60).
I-CHECKDB ilungise iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-8 zokuhambelana kwitheyibhile 'sys.sysobjvalues' (i-ID yento 60).
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.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-12 zokungqinelana kwiziko ledatha 'Error1'.
I-CHECKDB ilungise iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-12 zokungqinelana kwiziko ledatha 'Error1'.
Nksg 824, iNqanaba 24, i-State 2, i-Line 8
SQL Server kuchongwe impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (ekulindeleke: 0xb7bd14b3; eyona: 0xb7df14b2). Yenzekile ngexesha lokufunda kwephepha (1:24) kwi-database ID 39 kwi-offset 0x00000000030000 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 (ekulindeleke: 0xb7bd14b3; eyona: 0xb7df14b2). Yenzekile ngexesha lokufunda kwephepha (1:24) kwi-database ID 39 kwi-offset 0x00000000030000 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 (ekulindeleke: 0xb7bd14b3; eyona: 0xb7df14b2). Yenzekile ngexesha lokufunda kwephepha (1:24) kwi-database ID 39 kwi-offset 0x00000000030000 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 (elindelweyo: 0xc8e2ed96; eyona: 0xb8a2f3df). Yenzekile ngexesha lokufunda kwephepha (1:63) kwi-database ID 39 kwi-offset 0x0000000007e000 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 (elindelweyo: 0xc8e2ed96; eyona: 0xb8a2f3df). Yenzekile ngexesha lokufunda kwephepha (1:63) kwi-database ID 39 kwi-offset 0x0000000007e000 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 (elindelweyo: 0xc8e2ed96; eyona: 0xb8a2f3df). Yenzekile ngexesha lokufunda kwephepha (1:63) kwi-database ID 39 kwi-offset 0x0000000007e000 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 (elindelweyo: 0xc8e2ed96; eyona: 0xb8a2f3df). Yenzekile ngexesha lokufunda kwephepha (1:63) kwi-database ID 39 kwi-offset 0x0000000007e000 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 8945 ibonisa impazamo yetheyibhile eyimpazamo yokungaguquguquki.

Umfanekiso weskrini wemposiso:

Umfanekiso weskrini womyalezo wemposiso "Impazamo yetheyibhile: I-ID yento ##, isalathiso se-ID ## siza kuphinda yakhiwe."

Ingcaciso echanekileyo:

Kwi SQL Server MDF database, zininzi iitafile zenkqubo isetyenziselwa ukugcina ubume kunye nedatha yemeta yedatabase.

Xa i-CHECKDB ifumanisa ukuba kukho ukungangqinelani kwenye yeetafile zesixokelelwano, izakuchaza umyalezo wemposiso. Msg 8945, 8978, 8928, 8939, njl. kwaye uzame ukulungisa iimpazamo. Ukuba ayikwazi ukulungisa impazamo, ke ukubuyiswa akuphumeleli kwaye kuya kukhokelela kwiimpazamo ezininzi, ezifana UMsg 824.

Ungasebenzisa imveliso yethu DataNumen SQL Recovery ukubuyisela idatha kwifayile ye-MDF eyonakele kwaye uyisombulule le mpazamo.

Iifayili zesampulu:

Isampulu yeefayile zeMDF ezonakeleyo eziya kubangela i UMsg 8945 imposiso:

SQL Server Inguqulelo Ifayile ye-MDF eyonakele Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery
SQL Server 2014 Impazamo5.mdf Imposiso5_ilungisiwe.mdf