Alamar:

Lokacin amfani DBCC CHECKDB tare da GYARA_ALLOW_DATA_LOSS siga don gyara m .MDF database, kamar wannan:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

ka ga sakon kuskure mai zuwa:

Gyara: An sake gina ginshiƙan gungu don abin “sysobjvalues” a cikin “Error1”.
Gyara: successfullyididdigar cungiyoyin da ba a yi nasara ba an sake sake gina shi don abin "syscolpars" a cikin bayanan "Error1"
Sakamakon DBCC don 'Error1'.
Sakamakon DBCC don 'sys.sysrscols'.
Akwai layuka 1092 a cikin shafuka 14 don abu “sys.sysrscols”.
Sakamakon DBCC don 'sys.sysrowsets'.
Akwai layuka 148 a cikin shafuka 3 don abu “sys.sysrowsets”.
Sakamakon DBCC na 'sys.sysclones'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysclones”.
Sakamakon DBCC na 'sys.sysallocunits'.
Akwai layuka 172 a cikin shafuka 2 don abu “sys.sysallocunits”.
Sakamakon DBCC na 'sys.sysfiles1'.
Akwai layi 2 a cikin shafuka 1 don abu “sys.sysfiles1”.
Sakamakon DBCC na 'sys.sysseobjvalues'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysseobjvalues”.
Sakamakon DBCC don 'sys.syspriorities'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syspriorities”.
Sakamakon DBCC na 'sys.sysdbfrag '.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysdbfrag ”.
Sakamakon DBCC na 'sys.sysfgfrag'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysfgfrag”.
Sakamakon DBCC na 'sys.sysdbfiles '.
Akwai layuka 2 a cikin shafuka 1 don abu “sys.sysdbfiles ”.
Sakamakon DBCC don 'sys.syspru'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syspru”.
Sakamakon DBCC don 'sys.sysbrickfiles'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysbrickfiles”.
Sakamakon DBCC don 'sys.sysphfg'.
Akwai layuka 1 a cikin shafuka 1 don abu “sys.sysphfg”.
Sakamakon DBCC don 'sys.sysprufiles'.
Akwai layuka 2 a cikin shafuka 1 don abu “sys.sysprufiles”.
Sakamakon DBCC don 'sys.sysftinds'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysftinds”.
Sakamakon DBCC na 'sys.sysowners'.
Akwai layuka 14 a cikin shafuka 1 don abu “sys.sysowners”.
Sakamakon DBCC don 'sys.sysdbreg'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysdbreg”.
Sakamakon DBCC don 'sys.sysprivs'.
Akwai layuka 140 a cikin shafuka 1 don abu “sys.sysprivs”.
Sakamakon DBCC don 'sys.syscolpars'.
Gyara: An rarraba shafin (1: 63) daga ID ID 41, ID index, lambar ID 1, sanya ID na lamba 281474979397632 (rubuta In-jere data).
Gyara: successfullyididdigar cungiya ba tare da nasara ba an sake gina shi don abu "sys.syscolpars, nc" a cikin bayanan "Error1"
Msg 8945, Level 16, Jihar 1, Layin 8
Kuskuren tebur: ID ɗin ID 41, za a sake gina ID na 1.
An kasa gyara wannan kuskuren.
Msg 8978, Level 16, Jihar 1, Layin 8
Kuskuren tebur: ID na ID na 41, ID na ID 1, ID na bangare 281474979397632, sanya ID naúrar 281474979397632 (rubuta In-jere data). Shafi (1:61) ya rasa nassi daga shafi na baya (1:63). Matsalar haɗi mai haɗari.
An gyara kuskuren.
Msg 8928, Level 16, Jihar 1, Layin 8
ID ɗin abu 41, ID mai lamba 1, ID ɗin ɓoye 281474979397632, sanya ID naúrar 281474979397632 (rubuta In-jere data): Shafi (1: 63) ba za a iya sarrafa shi ba. Duba wasu kurakurai don cikakkun bayanai.
An gyara kuskuren.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID ɗin ID 41, ID na ƙididdiga 1, ID ɗin ɓoye 281474979397632, sanya ID ɗin naúrar 281474979397632 (sanya In-jere data), shafi na (1: 63). Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 2057 da -4.
An gyara kuskuren.
Msg 8976, Level 16, Jihar 1, Layin 8
Kuskuren tebur: ID na ID na 41, ID na ID 1, ID na bangare 281474979397632, sanya ID naúrar 281474979397632 (rubuta In-jere data). Ba a ga Shafi (1:63) a cikin hoton ba kodayake mahaifanta (1: 111) da wanda ya gabata (1: 168) suna nuni gare shi. Duba duk kurakuran da suka gabata.
An gyara kuskuren.
Msg 8945, Level 16, Jihar 1, Layin 8
Kuskuren tebur: ID ɗin ID 41, za a sake gina ID na 2.
An gyara kuskuren.
Akwai layuka 881 a cikin shafuka 15 don abu “sys.syscolpars”.
CHECKDB ya sami kurakurai kasafi 0 da kuskuren daidaito 4 a teburin 'sys.syscolpars' (ID ID 41).
CHECKDB ya gyara kurakuran kasafi 0 da kuskuren daidaito 4 a cikin teburin 'sys.syscolpars' (ID ID 41).
Sakamakon DBCC na 'sys.sysxlgns'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysxlgns”.
Sakamakon DBCC don 'sys.sysxsrvs'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysxsrvs”.
Sakamakon DBCC don 'sys.sysnsobjs'.
Akwai layuka 1 a cikin shafi 1 don abu “sys.sysnsobjs”.
Sakamakon DBCC na 'sys.sysusermsgs'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysusermsgs”.
Sakamakon DBCC don 'sys.syscerts'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syscerts”.
Sakamakon DBCC na 'sys.sysrmtlgns'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysrmtlgns”.
Sakamakon DBCC na 'sys.syslnklgns'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syslnklgns”.
Sakamakon DBCC don 'sys.sysxprops'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysxprops”.
Sakamakon DBCC don 'sys.sysscalartypes'.
Akwai layuka 34 a cikin shafuka 1 don abu “sys.sysscalartypes”.
Sakamakon DBCC don 'sys.systypedsubobjs'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.systypedsubobjs”.
Sakamakon DBCC don 'sys.sysidxstats'.
Akwai layuka 207 a cikin shafuka 5 don abu “sys.sysidxstats”.
Sakamakon DBCC don 'sys.sysiscols'.
Akwai layuka 399 a cikin shafuka 2 don abu “sys.sysiscols”.
Sakamakon DBCC don 'sys.sysendpts'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysendpts”.
Sakamakon DBCC don 'sys.syswebmethods'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syswebmethods”.
Sakamakon DBCC don 'sys.sysbinobjs'.
Akwai layuka 23 a cikin shafuka 1 don abu “sys.sysbinobjs”.
Sakamakon DBCC na 'sys.sysaudacts'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysaudacts”.
Sakamakon DBCC don 'sys.sysobjvalues'.
Gyara: successfullyididdigar ustididdigar nasarar da aka sake gina don abu "sys.sysobjvalues" a cikin database "Error1".
Gyara: An rarraba shafin (1: 24) daga ID ID 60, ID index, lambar ID 1, sanya ID na lamba 281474980642816 (rubuta In-jere data).
Gyarawa: Rukunin bayanan da aka share-layi tare da ID 742981632, don ID ID 60, ID ID mai lamba, ID ɗin ɓoye 1, sanya ID na ɗaya 281474980642816 (rubuta LOB data) a shafi na (71776119065149440: 1), rami 369.
Gyarawa: Rukunin bayanan da aka share-layi tare da ID 742981632, don ID ID 60, ID ID mai lamba, ID ɗin ɓoye 1, sanya ID na ɗaya 281474980642816 (rubuta LOB data) a shafi na (71776119065149440: 1), rami 370.
Gyarawa: Rukunin bayanan da aka share-layi tare da ID 742981632, don ID ID 60, ID ID mai lamba, ID ɗin ɓoye 1, sanya ID na ɗaya 281474980642816 (rubuta LOB data) a shafi na (71776119065149440: 1), rami 371.
Msg 8945, Level 16, Jihar 1, Layin 8
Kuskuren tebur: ID ɗin ID 60, za a sake gina ID na 1.
An gyara kuskuren.
Msg 8928, Level 16, Jihar 1, Layin 8
ID ɗin abu 60, ID mai lamba 1, ID ɗin ɓoye 281474980642816, sanya ID naúrar 281474980642816 (rubuta In-jere data): Shafi (1: 24) ba za a iya sarrafa shi ba. Duba wasu kurakurai don cikakkun bayanai.
An gyara kuskuren.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID ɗin ID 60, ID na ƙididdiga 1, ID ɗin ɓoye 281474980642816, sanya ID ɗin naúrar 281474980642816 (sanya In-jere data), shafi na (1: 24). Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 2057 da -4.
An gyara kuskuren.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID ɗin ID 60, ID na ƙididdiga 1, ID ɗin ɓoye 281474980642816, sanya ID ɗin naúrar 281474980642816 (sanya In-jere data), shafi na (1: 24). Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 2057 da -4.
An gyara kuskuren.
Msg 8976, Level 16, Jihar 1, Layin 8
Kuskuren tebur: ID na ID na 60, ID na ID 1, ID na bangare 281474980642816, sanya ID naúrar 281474980642816 (rubuta In-jere data). Ba a ga Shafi (1:24) a cikin hoton ba kodayake mahaifanta (1: 43) da wanda ya gabata (1: 213) suna nuni gare shi. Duba duk kurakuran da suka gabata.
An gyara kuskuren.
Msg 8978, Level 16, Jihar 1, Layin 8
Kuskuren tebur: ID na ID na 60, ID na ID 1, ID na bangare 281474980642816, sanya ID naúrar 281474980642816 (rubuta In-jere data). Shafi (1:210) ya rasa nassi daga shafi na baya (1:24). Matsalar haɗi mai haɗari.
An gyara kuskuren.
Msg 8964, Level 16, Jihar 1, Layin 8
Kuskuren tebur: ID ɗin ID 60, ID na ƙididdiga 1, ID ɗin ɓoye 281474980642816, sanya ID na ɗaya 71776119065149440 (rubuta bayanan LOB). Kundin bayanan kashewa a shafi (1: 369), rami 0, ba a ambaci ID na rubutu 742981632.
An gyara kuskuren.
Msg 8964, Level 16, Jihar 1, Layin 8
Kuskuren tebur: ID ɗin ID 60, ID na ƙididdiga 1, ID ɗin ɓoye 281474980642816, sanya ID na ɗaya 71776119065149440 (rubuta bayanan LOB). Kundin bayanan kashewa a shafi (1: 370), rami 0, ba a ambaci ID na rubutu 742981632.
An gyara kuskuren.
Msg 8964, Level 16, Jihar 1, Layin 8
Kuskuren tebur: ID ɗin ID 60, ID na ƙididdiga 1, ID ɗin ɓoye 281474980642816, sanya ID na ɗaya 71776119065149440 (rubuta bayanan LOB). Kundin bayanan kashewa a shafi (1: 371), rami 0, ba a ambaci ID na rubutu 742981632.
An gyara kuskuren.
Akwai layuka 203 a cikin shafuka 20 don abu “sys.sysobjvalues”.
CHECKDB ya sami kurakurai kasafi 0 da kuskuren daidaito 8 a teburin 'sys.sysobjvalues' (ID ID 60).
CHECKDB ya gyara kurakuran kasafi 0 da kuskuren daidaito 8 a teburin 'sys.sysobjvalues' (ID ID 60).
Sakamakon DBCC don 'sys.syscscolsections'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syscscolsections”.
Sakamakon DBCC don 'sys.syscsdictionaries'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syscsdictionaries”.
Sakamakon DBCC don 'sys.sysclsobjs'.
Akwai layuka 16 a cikin shafi 1 don abu “sys.sysclsobjs”.
Sakamakon DBCC na 'sys.sysrowsetrefs'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysrowsetrefs”.
Sakamakon DBCC na 'sys.sysremsvcbinds'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysremsvcbinds”.
Sakamakon DBCC don 'sys.sysxmitqueue'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysxmitqueue”.
Sakamakon DBCC na 'sys.sysrts'.
Akwai layuka 1 a cikin shafuka 1 don abu “sys.sysrts”.
Sakamakon DBCC don 'sys.sysconvgroup'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysconvgroup”.
Sakamakon DBCC don 'sys.sysdesend'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysdesend”.
Sakamakon DBCC don 'sys.sysdercv'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysdercv”.
Sakamakon DBCC don 'sys.syssingleobjrefs'.
Akwai layuka 171 a cikin shafuka 1 don abu “sys.syssingleobjrefs”.
Sakamakon DBCC don 'sys.sysmultiobjrefs'.
Akwai layuka 107 a cikin shafuka 1 don abu “sys.sysmultiobjrefs”.
Sakamakon DBCC don 'sys.sysguidrefs'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysguidrefs”.
Sakamakon DBCC don 'sys.sysfoqueues'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysfoqueues”.
Sakamakon DBCC don 'sys.syschildinsts'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syschildinsts”.
Sakamakon DBCC don 'sys.syscompfractions'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syscompfragments”.
Sakamakon DBCC don 'sys.sysftsemanticsdb'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysftsemanticsdb”.
Sakamakon DBCC don 'sys.sysftstops'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysftstops”.
Sakamakon DBCC na 'sys.sysftproperties'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysftproperties”.
Sakamakon DBCC na 'sys.sysxmitbody'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysxmitbody”.
Sakamakon DBCC na 'sys.sysfos'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysfos”.
Sakamakon DBCC na 'sys.sysqnames'.
Akwai layuka 98 a cikin shafuka 1 don abu “sys.sysqnames”.
Sakamakon DBCC don 'sys.sysxmlcomponent'.
Akwai layuka 100 a cikin shafi 1 don abu “sys.sysxmlcomponent”.
Sakamakon DBCC na 'sys.sysxmlfacet'.
Akwai layuka 112 a cikin shafuka 1 don abu “sys.sysxmlfacet”.
Sakamakon DBCC don 'sys.sysxmlplacement'.
Akwai layi 19 a cikin shafuka 1 don abu “sys.sysxmlplacement”.
Sakamakon DBCC don 'sys.sysobjkeycrypts'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysobjkeycrypts”.
Sakamakon DBCC na 'sys.sysasymkeys'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysasymkeys”.
Sakamakon DBCC na 'sys.syssqlguides'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syssqlguides”.
Sakamakon DBCC don 'sys.sysbinsubobjs'.
Akwai layi 3 a cikin shafuka 1 don abu “sys.sysbinsubobjs”.
Sakamakon DBCC na 'sys.syssoftobjrefs'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syssoftobjrefs”.
Sakamakon DBCC don 'sys.plan_persist_plan'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.plan_persist_plan”.
Sakamakon DBCC na 'sys.plan_persist_runtime_stats'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.plan_persist_runtime_stats”.
Sakamakon DBCC na 'sys.plan_persist_runtime_stats_interval'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.plan_persist_runtime_stats_interval”.
Sakamakon DBCC na 'sys.plan_persist_context_settings'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.plan_persist_context_settings”.
Sakamakon DBCC na 'sys.sqlagent_jobs'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sqlagent_jobs”.
Sakamakon DBCC na 'sys.sqlagent_jobsteps'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sqlagent_jobsteps”.
Sakamakon DBCC na 'sys.sqlagent_job_history'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sqlagent_job_history”.
Sakamakon DBCC na 'sys.queue_messages_2009058193'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.queue_messages_2009058193”.
Sakamakon DBCC na 'sys.queue_messages_2041058307'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.queue_messages_2041058307”.
Sakamakon DBCC na 'sys.filestream_tombstone_2073058421'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.filestream_tombstone_2073058421”.
Sakamakon DBCC don 'sys.syscommittab'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syscommittab”.
Sakamakon DBCC na 'sys.filetable_updates_2105058535'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.filetable_updates_2105058535”.
Sakamakon DBCC na 'sys.plan_persist_query_text'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.plan_persist_query_text”.
Sakamakon DBCC don 'sys.plan_persist_query'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.plan_persist_query”.
CHECKDB ya sami kurakurai kasawa 0 da kuskuren daidaito 12 a cikin bayanan 'Error1'.
CHECKDB ya gyara kuskuren kasawa 0 da kurakurai daidaito 12 a cikin bayanan 'Error1'.
Msg 824, Level 24, Jihar 2, Layin 8
SQL Server gano kuskuren I / O mai daidaito mai ma'ana: rajistar ba daidai ba (ana tsammanin: 0xb7bd14b3; ainihin: 0xb7df14b2). Hakan ya faru ne yayin karanta shafi (1:24) a cikin ID na bayanan ID 39 a biya diyya 0x00000000030000 a cikin fayil 'C: Fayilolin ShirinMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Messagesarin saƙonni a cikin SQL Server kuskuren kuskure ko tsarin taron tsarin na iya samar da cikakken bayani. Wannan mummunan kuskure ne yanayin da ke barazanar mutuncin bayanan bayanai kuma dole ne a gyara shi nan da nan. Kammala cikakken tsarin daidaito na bayanai (DBCC CHECKDB). Wannan kuskuren na iya haifar da dalilai da yawa; don ƙarin bayani, duba SQL Server Littattafai akan layi.
Msg 824, Level 24, Jihar 2, Layin 8
SQL Server gano kuskuren I / O mai daidaito mai ma'ana: rajistar ba daidai ba (ana tsammanin: 0xb7bd14b3; ainihin: 0xb7df14b2). Hakan ya faru ne yayin karanta shafi (1:24) a cikin ID na bayanan ID 39 a biya diyya 0x00000000030000 a cikin fayil 'C: Fayilolin ShirinMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Messagesarin saƙonni a cikin SQL Server kuskuren kuskure ko tsarin taron tsarin na iya samar da cikakken bayani. Wannan mummunan kuskure ne yanayin da ke barazanar mutuncin bayanan bayanai kuma dole ne a gyara shi nan da nan. Kammala cikakken tsarin daidaito na bayanai (DBCC CHECKDB). Wannan kuskuren na iya haifar da dalilai da yawa; don ƙarin bayani, duba SQL Server Littattafai akan layi.
Msg 824, Level 24, Jihar 2, Layin 8
SQL Server gano kuskuren I / O mai daidaito mai ma'ana: rajistar ba daidai ba (ana tsammanin: 0xb7bd14b3; ainihin: 0xb7df14b2). Hakan ya faru ne yayin karanta shafi (1:24) a cikin ID na bayanan ID 39 a biya diyya 0x00000000030000 a cikin fayil 'C: Fayilolin ShirinMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Messagesarin saƙonni a cikin SQL Server kuskuren kuskure ko tsarin taron tsarin na iya samar da cikakken bayani. Wannan mummunan kuskure ne yanayin da ke barazanar mutuncin bayanan bayanai kuma dole ne a gyara shi nan da nan. Kammala cikakken tsarin daidaito na bayanai (DBCC CHECKDB). Wannan kuskuren na iya haifar da dalilai da yawa; don ƙarin bayani, duba SQL Server Littattafai akan layi.
Msg 824, Level 24, Jihar 2, Layin 8
SQL Server gano kuskuren I / O mai daidaito mai ma'ana: rajistar ba daidai ba (ana tsammanin: 0xc8e2ed96; ainihin: 0xb8a2f3df). Hakan ya faru ne yayin karanta shafi (1:63) a cikin ID na bayanan ID 39 a biya diyya 0x0000000007e000 a cikin fayil 'C: Fayilolin ShirinMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Messagesarin saƙonni a cikin SQL Server kuskuren kuskure ko tsarin taron tsarin na iya samar da cikakken bayani. Wannan mummunan kuskure ne yanayin da ke barazanar mutuncin bayanan bayanai kuma dole ne a gyara shi nan da nan. Kammala cikakken tsarin daidaito na bayanai (DBCC CHECKDB). Wannan kuskuren na iya haifar da dalilai da yawa; don ƙarin bayani, duba SQL Server Littattafai akan layi.
Msg 824, Level 24, Jihar 2, Layin 8
SQL Server gano kuskuren I / O mai daidaito mai ma'ana: rajistar ba daidai ba (ana tsammanin: 0xc8e2ed96; ainihin: 0xb8a2f3df). Hakan ya faru ne yayin karanta shafi (1:63) a cikin ID na bayanan ID 39 a biya diyya 0x0000000007e000 a cikin fayil 'C: Fayilolin ShirinMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Messagesarin saƙonni a cikin SQL Server kuskuren kuskure ko tsarin taron tsarin na iya samar da cikakken bayani. Wannan mummunan kuskure ne yanayin da ke barazanar mutuncin bayanan bayanai kuma dole ne a gyara shi nan da nan. Kammala cikakken tsarin daidaito na bayanai (DBCC CHECKDB). Wannan kuskuren na iya haifar da dalilai da yawa; don ƙarin bayani, duba SQL Server Littattafai akan layi.
Msg 824, Level 24, Jihar 2, Layin 8
SQL Server gano kuskuren I / O mai daidaito mai ma'ana: rajistar ba daidai ba (ana tsammanin: 0xc8e2ed96; ainihin: 0xb8a2f3df). Hakan ya faru ne yayin karanta shafi (1:63) a cikin ID na bayanan ID 39 a biya diyya 0x0000000007e000 a cikin fayil 'C: Fayilolin ShirinMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Messagesarin saƙonni a cikin SQL Server kuskuren kuskure ko tsarin taron tsarin na iya samar da cikakken bayani. Wannan mummunan kuskure ne yanayin da ke barazanar mutuncin bayanan bayanai kuma dole ne a gyara shi nan da nan. Kammala cikakken tsarin daidaito na bayanai (DBCC CHECKDB). Wannan kuskuren na iya haifar da dalilai da yawa; don ƙarin bayani, duba SQL Server Littattafai akan layi.
Msg 824, Level 24, Jihar 2, Layin 8
SQL Server gano kuskuren I / O mai daidaito mai ma'ana: rajistar ba daidai ba (ana tsammanin: 0xc8e2ed96; ainihin: 0xb8a2f3df). Hakan ya faru ne yayin karanta shafi (1:63) a cikin ID na bayanan ID 39 a biya diyya 0x0000000007e000 a cikin fayil 'C: Fayilolin ShirinMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Messagesarin saƙonni a cikin SQL Server kuskuren kuskure ko tsarin taron tsarin na iya samar da cikakken bayani. Wannan mummunan kuskure ne yanayin da ke barazanar mutuncin bayanan bayanai kuma dole ne a gyara shi nan da nan. Kammala cikakken tsarin daidaito na bayanai (DBCC CHECKDB). Wannan kuskuren na iya haifar da dalilai da yawa; don ƙarin bayani, duba SQL Server Littattafai akan layi.

inda 'Error1' shine sunan ɓataccen bayanan MDF da ake gyarawa.

Msg 8945 yana nuna kuskuren tebur wanda shine kuskuren daidaito.

Hoton kuskuren hoto:

Daidaitaccen Bayani:

a cikin wata SQL Server MDF bayanai, akwai da yawa teburin tsarin amfani dashi don adana tsari da meta data na bayanan.

Lokacin da CHECKDB ya sami akwai rashin daidaituwa a ɗayan teburin tsarin, zai ba da rahoton saƙon kuskuren Msg 8945, 8978, 8928, 8939, da dai sauransu. da kuma kokarin gyara kurakurai. Idan ba zai iya gyara kuskuren ba, to murmurewa ya kasa kuma zai haifar da ƙarin kurakurai, kamar su Msg 824.

Zaka iya amfani da samfurinmu DataNumen SQL Recovery don dawo da bayanan daga fayil ɗin MDF mai lalata kuma warware wannan kuskuren.

Samfurin fayiloli:

Samfurin gurbatattun fayilolin MDF wanda zai haifar da Msg 8945 kuskure:

SQL Server version Gurbataccen MDF fayil Fayil MDF ta gyara DataNumen SQL Recovery
SQL Server 2014 Kuskure5.mdf Kuskuren5_fixed.mdf