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: Theididdigar ustididdigar nasarar da aka sake gina don abu "syscolpars" a cikin bayanan "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'.
Mai ba da sabis na Sabis Msg 9675, Jiha ta 1: An bincika Nau'in Saƙo: 14.
Sabis na Sabis Msg 9676, Jiha na 1: An bincika Yarjejeniyar Sabis: 6.
Sabis na Sabis Msg 9667, Jiha na 1: An bincika ayyuka: 3.
Mai Kula da Sabis Msg 9668, Jiha 1: An binciki layukan Sabis: 3.
Broker Sabis Msg 9669, Jiha 1: An bincika Endarshen Tattaunawa: 0.
Broker Service Msg 9674, Jiha 1: An tattauna Rukunin Tattaunawa: 0.
Mai Kula da Sabis Msg 9670, Jiha 1: An binciko Baurin Sabis na Nesa: 0.
Mai Kula da Sabis Msg 9605, Jiha 1: An yi nazarin Abubuwan Faɗi mafi mahimmanci: 0.
Msg 8992, Level 16, Jihar 1, Layin 8
Bincika Catalog Msg 3852, Jiha 1: Row (object_id = 69) a cikin sys.objects (type = S) bashi da layi mai daidaita (object_id = 69, column_id = 1) a cikin sys.columns.
Msg 8992, Level 16, Jihar 1, Layin 8
Bincika Catalog Msg 3852, Jiha 1: Row (object_id = 71) a cikin sys.objects (type = S) bashi da layi mai daidaita (object_id = 71, column_id = 1) a cikin sys.columns.
Msg 8992, Level 16, Jihar 1, Layin 8
Bincika Catalog Msg 3852, Jiha 1: Row (object_id = 72) a cikin sys.objects (type = S) bashi da layi mai daidaita (object_id = 72, column_id = 1) a cikin sys.columns.
Msg 8992, Level 16, Jihar 1, Layin 8
Bincika Catalog Msg 3852, Jiha 1: Row (object_id = 73) a cikin sys.objects (type = S) bashi da layi mai daidaita (object_id = 73, column_id = 1) a cikin sys.columns.
CHECKDB ya sami kurakurai kasawa guda 0 da kuskuren daidaito 4 waɗanda ba a haɗa su da kowane abu guda ba.
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.sysschobjs'.
Akwai layuka 2262 a cikin shafuka 29 don abu “sys.sysschobjs”.
Sakamakon DBCC don 'sys.syscsrowgroups'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syscsrowgroups”.
Sakamakon DBCC don 'sys.sysexttables'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysexttables”.
Sakamakon DBCC don 'sys.syscolpars'.
Gyara: successfullyididdigar ustididdigar nasarar da aka sake gina don abu "sys.syscolpars" a cikin bayanan "Error1".
Gyara: An rarraba shafin (1: 53) 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 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: 53) 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: 53). 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:53) a cikin hoton ba kodayake mahaifanta (1: 111) da wanda ya gabata (1: 113) 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 41, ID na ID 1, ID na bangare 281474979397632, sanya ID naúrar 281474979397632 (rubuta In-jere data). Shafi (1:56) ya rasa nassi daga shafi na baya (1:53). Matsalar haɗi mai haɗari.
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 845 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'.
Akwai layuka 213 a cikin shafuka 21 don abu “sys.sysobjvalues”.
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.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.sqlagent_jobsteps_logs'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sqlagent_jobsteps_logs”.
Sakamakon DBCC don 'TestTable'.
Akwai layuka 11000 a cikin shafuka 110 don abu “TestTable”.
Sakamakon DBCC na 'sys.queue_messages_1977058079'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.queue_messages_1977058079”.
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 8 a cikin bayanan 'Error1'.
CHECKDB ya gyara kuskuren kasawa 0 da kurakurai daidaito 4 a cikin bayanan 'Error1'.
An kammala aikin DBCC. Idan DBCC ta buga saƙonnin kuskure, tuntuɓi mai kula da tsarinku.
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: 0xeddf7c98; ainihin: 0xed637c9c). Hakan ya faru ne yayin karanta shafi (1:53) a cikin ID na bayanan ID 39 a biya diyya 0x0000000006a000 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: 0xeddf7c98; ainihin: 0xed637c9c). Hakan ya faru ne yayin karanta shafi (1:53) a cikin ID na bayanan ID 39 a biya diyya 0x0000000006a000 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: 0xeddf7c98; ainihin: 0xed637c9c). Hakan ya faru ne yayin karanta shafi (1:53) a cikin ID na bayanan ID 39 a biya diyya 0x0000000006a000 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: 0xeddf7c98; ainihin: 0xed637c9c). Hakan ya faru ne yayin karanta shafi (1:53) a cikin ID na bayanan ID 39 a biya diyya 0x0000000006a000 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: 0xeddf7c98; ainihin: 0xed637c9c). Hakan ya faru ne yayin karanta shafi (1:53) a cikin ID na bayanan ID 39 a biya diyya 0x0000000006a000 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: 0xeddf7c98; ainihin: 0xed637c9c). Hakan ya faru ne yayin karanta shafi (1:53) a cikin ID na bayanan ID 39 a biya diyya 0x0000000006a000 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.

or

Gyara: Theididdigar ustididdigar nasarar da aka sake gina don abu "syscolpars" a cikin bayanan "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'.
Mai ba da sabis na Sabis Msg 9675, Jiha ta 1: An bincika Nau'in Saƙo: 14.
Sabis na Sabis Msg 9676, Jiha na 1: An bincika Yarjejeniyar Sabis: 6.
Sabis na Sabis Msg 9667, Jiha na 1: An bincika ayyuka: 3.
Mai Kula da Sabis Msg 9668, Jiha 1: An binciki layukan Sabis: 3.
Broker Sabis Msg 9669, Jiha 1: An bincika Endarshen Tattaunawa: 0.
Broker Service Msg 9674, Jiha 1: An tattauna Rukunin Tattaunawa: 0.
Mai Kula da Sabis Msg 9670, Jiha 1: An binciko Baurin Sabis na Nesa: 0.
Mai Kula da Sabis Msg 9605, Jiha 1: An yi nazarin Abubuwan Faɗi mafi mahimmanci: 0.
Msg 8992, Level 16, Jihar 1, Layin 8
Bincika Catalog Msg 3852, Jiha 1: Row (object_id = 23) a cikin sys.objects (type = S) bashi da layi mai daidaita (object_id = 23, column_id = 1) a cikin sys.columns.
Msg 8992, Level 16, Jihar 1, Layin 8
Bincika Catalog Msg 3852, Jiha 1: Row (object_id = 24) a cikin sys.objects (type = S) bashi da layi mai daidaita (object_id = 24, column_id = 1) a cikin sys.columns.
CHECKDB ya sami kurakurai kasawa guda 0 da kuskuren daidaito 2 waɗanda ba a haɗa su da kowane abu guda ba.
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 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.sysschobjs'.
Akwai layuka 2262 a cikin shafuka 29 don abu “sys.sysschobjs”.
Sakamakon DBCC don 'sys.syscsrowgroups'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.syscsrowgroups”.
Sakamakon DBCC don 'sys.sysexttables'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sysexttables”.
Sakamakon DBCC don 'sys.syscolpars'.
Gyara: successfullyididdigar ustididdigar nasarar da aka sake gina don abu "sys.syscolpars" a cikin bayanan "Error1".
Gyara: An rarraba shafin (1: 59) 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 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: 59) 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: 59). 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:59) a cikin hoton ba kodayake mahaifanta (1: 111) da wanda ya gabata (1: 155) 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 41, ID na ID 1, ID na bangare 281474979397632, sanya ID naúrar 281474979397632 (rubuta In-jere data). Shafi (1:112) ya rasa nassi daga shafi na baya (1:59). Matsalar haɗi mai haɗari.
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 832 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'.
Akwai layuka 213 a cikin shafuka 21 don abu “sys.sysobjvalues”.
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.sqlagent_jobsteps_logs'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.sqlagent_jobsteps_logs”.
Sakamakon DBCC don 'TestTable'.
Akwai layuka 11000 a cikin shafuka 110 don abu “TestTable”.
Sakamakon DBCC na 'sys.queue_messages_1977058079'.
Akwai layuka 0 a cikin shafuka 0 don abu “sys.queue_messages_1977058079”.
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 6 a cikin bayanan 'Error1'.
CHECKDB ya gyara kuskuren kasawa 0 da kurakurai daidaito 4 a cikin bayanan 'Error1'.
An kammala aikin DBCC. Idan DBCC ta buga saƙonnin kuskure, tuntuɓi mai kula da tsarinku.
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: 0x9eb87140; ainihin: 0xdeb84c40). Hakan ya faru ne yayin karanta shafi (1:59) a cikin ID na bayanan ID 39 a biya diyya 0x00000000076000 a cikin fayil 'C: Fayilolin Shirye-shiryenMicrosoft 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: 0x9eb87140; ainihin: 0xdeb84c40). Hakan ya faru ne yayin karanta shafi (1:59) a cikin ID na bayanan ID 39 a biya diyya 0x00000000076000 a cikin fayil 'C: Fayilolin Shirye-shiryenMicrosoft 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: 0x9eb87140; ainihin: 0xdeb84c40). Hakan ya faru ne yayin karanta shafi (1:59) a cikin ID na bayanan ID 39 a biya diyya 0x00000000076000 a cikin fayil 'C: Fayilolin Shirye-shiryenMicrosoft 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: 0x9eb87140; ainihin: 0xdeb84c40). Hakan ya faru ne yayin karanta shafi (1:59) a cikin ID na bayanan ID 39 a biya diyya 0x00000000076000 a cikin fayil 'C: Fayilolin Shirye-shiryenMicrosoft 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 8992 bi da Msg 3852 kuskure kuskure ne daidaito.

Hoton kuskuren hoto:

or

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 tsakanin teburin tsarin guda biyu, zai ba da rahoton saƙon kuskuren Msg 8992 da Msg 3852.

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 daMsg 8992 da Msg 3852 kuskure:

SQL Server version Gurbataccen MDF fayil Fayil MDF ta gyara DataNumen SQL Recovery
SQL Server 2014 Kuskure4_1.mdf Kuskure4_1_fixed.mdf
SQL Server 2014 Kuskure4_2.mdf Kuskure4_2_fixed.mdf

References: