Hōʻailona:
I ka wā e hoʻohana ai DBCC CHECKDB me REPAIR_ALLOW_DATA_LOSS ʻāpana no ka hoʻoponopono ʻana i kahi waihona .MDF hewa, e like me kēia:
DBCC CHECKDB(xxxx, 'REPAIR_ALLOW_DATA_LOSS')
ʻike ʻoe i kēia memo hewa:
Hoʻoponopono: Ua kūkulu hou ʻia ka papa kuhikuhi Clustered no ka mea "syscolpars" ma ka waihona "Error1".
Hoʻoponopono: Ua kūkulu hou ʻia ka papa kuhikuhi Nonclustered no ka mea "syscolpars" ma ka waihona "Error1".
Nā hualoaʻa DBCC no 'Error1'.
Service Broker Msg 9675, State 1: Nā ʻano memo i kālailai ʻia: 14.
Service Broker Msg 9676, Mokuʻāina 1: Nā ʻaelike lawelawe i kālailai ʻia: 6.
Service Broker Msg 9667, State 1: Nā lawelawe i kālailai ʻia: 3.
Service Broker Msg 9668, Mokuʻāina 1: Nānā ʻia nā Queues Service: 3.
Service Broker Msg 9669, Mokuʻāina 1: Nānā ʻia nā helu hope kamaʻilio: 0.
Service Broker Msg 9674, Mokuʻāina 1: Nānā ʻia nā hui kamaʻilio: 0.
Service Broker Msg 9670, Mokuʻāina 1: Hoʻopaʻa ʻia nā hoʻopaʻa lawelawe mamao: 0.
Service Broker Msg 9605, Mokuʻāina 1: Nānā ʻia nā mea nui o ke kamaʻilio ʻana: 0.
Msg 8992, Papa 16, Mokuʻāina 1, laina 8
E nānā i ka Catalog Msg 3852, Mokuʻāina 1: ʻAʻohe lālani kūpono i ka lālani (object_id=69) ma sys.objects (type=S ) (object_id=69,column_id=1) ma sys.columns.
Msg 8992, Papa 16, Mokuʻāina 1, laina 8
E nānā i ka Catalog Msg 3852, Mokuʻāina 1: ʻAʻohe lālani kūpono i ka lālani (object_id=71) ma sys.objects (type=S ) (object_id=71,column_id=1) ma sys.columns.
Msg 8992, Papa 16, Mokuʻāina 1, laina 8
E nānā i ka Catalog Msg 3852, Mokuʻāina 1: ʻAʻohe lālani kūpono i ka lālani (object_id=72) ma sys.objects (type=S ) (object_id=72,column_id=1) ma sys.columns.
Msg 8992, Papa 16, Mokuʻāina 1, laina 8
E nānā i ka Catalog Msg 3852, Mokuʻāina 1: ʻAʻohe lālani kūpono i ka lālani (object_id=73) ma sys.objects (type=S ) (object_id=73,column_id=1) ma sys.columns.
Ua loaʻa iā CHECKDB 0 nā hewa hoʻokaʻawale a me 4 mau hewa kūlike ʻaʻole pili i kekahi mea hoʻokahi.
Nā hualoaʻa DBCC no 'sys.sysrscols'.
He 1092 lālani ma 14 ʻaoʻao no ka mea "sys.sysrscols".
Nā hualoaʻa DBCC no 'sys.sysrowsets'.
He 148 lālani ma 3 ʻaoʻao no ka mea "sys.sysrowsets".
Nā hualoaʻa DBCC no 'sys.sysclones'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysclones".
Nā hualoaʻa DBCC no 'sys.sysallocunits'.
He 172 lālani ma 2 ʻaoʻao no ka mea "sys.sysallocunits".
Nā hualoaʻa DBCC no 'sys.sysfiles1'.
Aia 2 lālani ma 1 ʻaoʻao no ka mea "sys.sysfiles1".
Nā hualoaʻa DBCC no 'sys.sysseobjvalues'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysseobjvalues".
Nā hualoaʻa DBCC no 'sys.syspriorities'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syspriorities".
Nā hualoaʻa DBCC no 'sys.sysdbflole lole'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysdbflole lole”.
Nā hualoaʻa DBCC no 'sys.sysfgfrag'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysfgfrag".
Nā hualoaʻa DBCC no 'sys.sysdbfiles'.
He 2 lālani ma 1 ʻaoʻao no ka mea "sys.sysdbfiles”.
Nā hualoaʻa DBCC no 'sys.syspru'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syspru".
Nā hualoaʻa DBCC no 'sys.sysbrickfiles'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysbrickfiles".
Nā hualoaʻa DBCC no 'sys.sysphfg'.
Aia 1 lālani ma 1 ʻaoʻao no ka mea "sys.sysphfg".
Nā hualoaʻa DBCC no 'sys.sysprufiles'.
Aia 2 lālani ma 1 ʻaoʻao no ka mea "sys.sysprufiles".
Nā hualoaʻa DBCC no 'sys.sysftinds'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysftinds".
Nā hualoaʻa DBCC no 'sys.sysowners'.
He 14 lālani ma 1 ʻaoʻao no ka mea "sys.sysowners".
Nā hualoaʻa DBCC no 'sys.sysdbreg'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysdbreg".
Nā hualoaʻa DBCC no 'sys.sysprivs'.
He 140 lālani ma 1 ʻaoʻao no ka mea "sys.sysprivs".
Nā hualoaʻa DBCC no 'sys.sysschobjs'.
He 2262 lālani ma 29 ʻaoʻao no ka mea "sys.sysschobjs".
Nā hualoaʻa DBCC no 'sys.syscsrowgroups'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscsrowgroups".
Nā hualoaʻa DBCC no 'sys.sysexttables'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysexttables".
Nā hualoaʻa DBCC no 'sys.syscolpars'.
Hoʻoponopono: Ua kūkulu hou ʻia ka papa kuhikuhi Clustered no ka mea "sys.syscolpars" ma ka waihona "Error1".
Hoʻoponopono: Ua wehe ʻia ka ʻaoʻao (1:53) mai ka mea ID 41, index ID 1, ʻāpana ID 281474979397632, alloc unit ID 281474979397632 (type In-row data).
Hoʻoponopono: Ua kūkulu hou ʻia ka papa kuhikuhi Nonclustered no ka mea "sys.syscolpars, nc" ma ka waihona "Error1".
Msg 8945, Papa 16, Mokuʻāina 1, laina 8
Hapa papa: Object ID 41, index ID 1 e kūkulu hou ʻia.
Ua hoʻoponopono ʻia ka hewa.
Msg 8928, Papa 16, Mokuʻāina 1, laina 8
Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data): ʻAʻole hiki ke hana ʻia ka ʻaoʻao (1:53). E ʻike i nā hewa ʻē aʻe no nā kikoʻī.
Ua hoʻoponopono ʻia ka hewa.
Msg 8939, Papa 16, Mokuʻāina 98, laina 8
Hapa papa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data), page (1:53). ʻAʻole hiki ke hoʻāʻo (IS_OFF (BUF_IOERR, pBUF->bstat)). ʻO 2057 a me -4 nā waiwai.
Ua hoʻoponopono ʻia ka hewa.
Msg 8976, Papa 16, Mokuʻāina 1, laina 8
Hapa papa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). ʻAʻole ʻike ʻia ka ʻaoʻao (1:53) ma ka scan ʻoiai ʻo kona makua (1:111) a me ka mua (1:113) i kuhikuhi iā ia. E nānā i nā hewa ma mua.
Ua hoʻoponopono ʻia ka hewa.
Msg 8978, Papa 16, Mokuʻāina 1, laina 8
Hapa papa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Aia ka ʻaoʻao (1:56) i kahi kuhikuhi mai ka ʻaoʻao mua (1:53). Pilikia pili kaulahao paha.
Ua hoʻoponopono ʻia ka hewa.
Msg 8945, Papa 16, Mokuʻāina 1, laina 8
Hapa papa: Object ID 41, index ID 2 e kūkulu hou ʻia.
Ua hoʻoponopono ʻia ka hewa.
He 845 lālani ma 15 ʻaoʻao no ka mea "sys.syscolpars".
Ua loaʻa iā CHECKDB 0 nā hewa hoʻokaʻawale a me 4 mau hewa kūlike ma ka papa 'sys.syscolpars' (mea ID 41).
Ua hoʻopaʻa ʻo CHECKDB i nā hewa hoʻokaʻawale 0 a me 4 mau hewa kūlike ma ka papa 'sys.syscolpars' (mea ID 41).
Nā hualoaʻa DBCC no 'sys.sysxlgns'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysxlgns".
Nā hualoaʻa DBCC no 'sys.sysxsrvs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysxsrvs".
Nā hualoaʻa DBCC no 'sys.sysnsobjs'.
Aia 1 lālani ma 1 ʻaoʻao no ka mea "sys.sysnsobjs".
Nā hualoaʻa DBCC no 'sys.sysusermsgs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysusermsgs".
Nā hualoaʻa DBCC no 'sys.syscerts'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscerts".
Nā hualoaʻa DBCC no 'sys.sysrmtlgns'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysrmtlgns".
Nā hualoaʻa DBCC no 'sys.syslnklgns'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syslnklgns".
Nā hualoaʻa DBCC no 'sys.sysxprops'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysxprops".
Nā hualoaʻa DBCC no 'sys.sysscalartypes'.
He 34 lālani ma 1 ʻaoʻao no ka mea "sys.sysscalartypes".
Nā hualoaʻa DBCC no 'sys.sytypedsubobjs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sytypedsubobjs".
Nā hualoaʻa DBCC no 'sys.sysidxstats'.
He 207 lālani ma 5 ʻaoʻao no ka mea "sys.sysidxstats".
Nā hualoaʻa DBCC no 'sys.sysiscols'.
He 399 lālani ma 2 ʻaoʻao no ka mea "sys.sysiscols".
Nā hualoaʻa DBCC no 'sys.sysendpts'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysendpts".
Nā hualoaʻa DBCC no 'sys.syswebmethods'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syswebmethods".
Nā hualoaʻa DBCC no 'sys.sysbinobjs'.
He 23 lālani ma 1 ʻaoʻao no ka mea "sys.sysbinobjs".
Nā hualoaʻa DBCC no 'sys.sysaudacts'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysaudacts".
Nā hualoaʻa DBCC no 'sys.sysobjvalues'.
He 213 lālani ma 21 ʻaoʻao no ka mea "sys.sysobjvalues".
Nā hualoaʻa DBCC no 'sys.syscscolsegments'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscscolsegments".
Nā hualoaʻa DBCC no 'sys.syscsdictionaries'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscsdictionaries".
Nā hualoaʻa DBCC no 'sys.sysclsobjs'.
He 16 lālani ma 1 ʻaoʻao no ka mea "sys.sysclsobjs".
Nā hualoaʻa DBCC no 'sys.sysrowsetrefs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysrowsetrefs".
Nā hualoaʻa DBCC no 'sys.sysremsvcbinds'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysremsvcbinds".
Nā hualoaʻa DBCC no 'sys.sysmultiobjrefs'.
He 107 lālani ma 1 ʻaoʻao no ka mea "sys.sysmultiobjrefs".
Nā hualoaʻa DBCC no 'sys.sysguidrefs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysguidrefs".
Nā hualoaʻa DBCC no 'sys.sysfoqueues'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysfoqueues".
Nā hualoaʻa DBCC no 'sys.syschildinsts'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syschildinsts".
Nā hualoaʻa DBCC no 'sys.syscompfragments'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscompfragments".
Nā hualoaʻa DBCC no 'sys.sysftsemanticsdb'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysftsemanticsdb".
Nā hualoaʻa DBCC no 'sys.sysftstops'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysftstops".
Nā hualoaʻa DBCC no 'sys.sysftproperties'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysftproperties".
Nā hualoaʻa DBCC no 'sys.sysxmitbody'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysxmitbody".
Nā hualoaʻa DBCC no 'sys.sysfos'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysfos".
Nā hualoaʻa DBCC no 'sys.sysqnames'.
He 98 lālani ma 1 ʻaoʻao no ka mea "sys.sysqnames".
Nā hualoaʻa DBCC no 'sys.sysxmlcomponent'.
He 100 lālani ma 1 ʻaoʻao no ka mea "sys.sysxmlcomponent".
Nā hualoaʻa DBCC no 'sys.sysxmlfacet'.
He 112 lālani ma 1 ʻaoʻao no ka mea "sys.sysxmlfacet".
Nā hualoaʻa DBCC no 'sys.sysxmlplacement'.
He 19 lālani ma 1 ʻaoʻao no ka mea "sys.sysxmlplacement".
Nā hualoaʻa DBCC no 'sys.sysobjkeycrypts'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysobjkeycrypts".
Nā hualoaʻa DBCC no 'sys.sysasymkeys'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysasymkeys".
Nā hualoaʻa DBCC no 'sys.syssqlguides'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syssqlguides".
Nā hualoaʻa DBCC no 'sys.sysbinsubobjs'.
Aia 3 lālani ma 1 ʻaoʻao no ka mea "sys.sysbinsubobjs".
Nā hualoaʻa DBCC no 'sys.syssoftobjrefs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syssoftobjrefs".
Nā hualoaʻa DBCC no 'sys.plan_persist_plan'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_plan".
Nā hualoaʻa DBCC no 'sys.plan_persist_runtime_stats'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_runtime_stats".
Nā hualoaʻa DBCC no 'sys.plan_persist_runtime_stats_interval'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_runtime_stats_interval".
Nā hualoaʻa DBCC no 'sys.plan_persist_context_settings'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_context_settings".
Nā hualoaʻa DBCC no 'sys.sqlagent_jobs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sqlagent_jobs".
Nā hualoaʻa DBCC no 'sys.sqlagent_jobsteps'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sqlagent_jobsteps".
Nā hualoaʻa DBCC no 'sys.sqlagent_job_history'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sqlagent_job_history".
Nā hualoaʻa DBCC no 'sys.sqlagent_jobsteps_logs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sqlagent_jobsteps_logs".
Nā hualoaʻa DBCC no 'TestTable'.
Aia 11000 lālani ma 110 ʻaoʻao no ka mea "TestTable".
Nā hualoa‘a DBCC no 'sys.queue_messages_1977058079'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.queue_messages_1977058079".
Nā hualoa‘a DBCC no 'sys.queue_messages_2009058193'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.queue_messages_2009058193".
Nā hualoa‘a DBCC no 'sys.queue_messages_2041058307'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.queue_messages_2041058307".
Nā hualoa‘a DBCC no 'sys.filestream_tombstone_2073058421'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.filestream_tombstone_2073058421".
Nā hualoaʻa DBCC no 'sys.syscommittab'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscommittab".
Nā hualoa‘a DBCC no 'sys.filetable_updates_2105058535'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.filetable_updates_2105058535".
Nā hualoaʻa DBCC no 'sys.plan_persist_query_text'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_query_text".
Nā hualoaʻa DBCC no 'sys.plan_persist_query'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_query".
Ua loaʻa iā CHECKDB 0 nā hewa hoʻokaʻawale a me 8 mau hewa kūlike i ka waihona 'Error1'.
Ua hoʻoponopono ʻo CHECKDB i nā hewa hoʻokaʻawale 0 a me 4 mau hewa kūlike i ka waihona 'Error1'.
Ua pau ka hoʻokō ʻana o DBCC. Inā paʻi ʻo DBCC i nā memo hewa, e kelepona i kāu luna hoʻonohonoho.
Msg 824, Papa 24, Mokuʻāina 2, laina 8
SQL Server ua ʻike ʻia kahi hewa I/O e pili ana i ka lokahi: helu helu hewa (manaʻo ʻia: 0xeddf7c98; maoli: 0xed637c9c). Ua loaʻa ia ma ka heluhelu ʻana o ka ʻaoʻao (1:53) ma ka waihona ID 39 ma offset 0x0000000006a000 ma ka waihona 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Nā memo hou ma ka SQL Server hiki ke hāʻawi i nā kikoʻī hou aku i ka log error a i ʻole ka log event system. He kūlana hewa nui kēia e hoʻoweliweli ana i ka pono o ka waihona a pono e hoʻoponopono koke ʻia. E hoʻopiha i kahi hōʻoia ʻikepili piha piha (DBCC CHECKDB). Hiki ke kumu o kēia hewa e nā kumu he nui; no ka 'ike hou aku, e nana SQL Server Nā puke ma ka pūnaewele.
Msg 824, Papa 24, Mokuʻāina 2, laina 8
SQL Server ua ʻike ʻia kahi hewa I/O e pili ana i ka lokahi: helu helu hewa (manaʻo ʻia: 0xeddf7c98; maoli: 0xed637c9c). Ua loaʻa ia ma ka heluhelu ʻana o ka ʻaoʻao (1:53) ma ka waihona ID 39 ma offset 0x0000000006a000 ma ka waihona 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Nā memo hou ma ka SQL Server hiki ke hāʻawi i nā kikoʻī hou aku i ka log error a i ʻole ka log event system. He kūlana hewa nui kēia e hoʻoweliweli ana i ka pono o ka waihona a pono e hoʻoponopono koke ʻia. E hoʻopiha i kahi hōʻoia ʻikepili piha piha (DBCC CHECKDB). Hiki ke kumu o kēia hewa e nā kumu he nui; no ka 'ike hou aku, e nana SQL Server Nā puke ma ka pūnaewele.
Msg 824, Papa 24, Mokuʻāina 2, laina 8
SQL Server ua ʻike ʻia kahi hewa I/O e pili ana i ka lokahi: helu helu hewa (manaʻo ʻia: 0xeddf7c98; maoli: 0xed637c9c). Ua loaʻa ia ma ka heluhelu ʻana o ka ʻaoʻao (1:53) ma ka waihona ID 39 ma offset 0x0000000006a000 ma ka waihona 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Nā memo hou ma ka SQL Server hiki ke hāʻawi i nā kikoʻī hou aku i ka log error a i ʻole ka log event system. He kūlana hewa nui kēia e hoʻoweliweli ana i ka pono o ka waihona a pono e hoʻoponopono koke ʻia. E hoʻopiha i kahi hōʻoia ʻikepili piha piha (DBCC CHECKDB). Hiki ke kumu o kēia hewa e nā kumu he nui; no ka 'ike hou aku, e nana SQL Server Nā puke ma ka pūnaewele.
Msg 824, Papa 24, Mokuʻāina 2, laina 8
SQL Server ua ʻike ʻia kahi hewa I/O e pili ana i ka lokahi: helu helu hewa (manaʻo ʻia: 0xeddf7c98; maoli: 0xed637c9c). Ua loaʻa ia ma ka heluhelu ʻana o ka ʻaoʻao (1:53) ma ka waihona ID 39 ma offset 0x0000000006a000 ma ka waihona 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Nā memo hou ma ka SQL Server hiki ke hāʻawi i nā kikoʻī hou aku i ka log error a i ʻole ka log event system. He kūlana hewa nui kēia e hoʻoweliweli ana i ka pono o ka waihona a pono e hoʻoponopono koke ʻia. E hoʻopiha i kahi hōʻoia ʻikepili piha piha (DBCC CHECKDB). Hiki ke kumu o kēia hewa e nā kumu he nui; no ka 'ike hou aku, e nana SQL Server Nā puke ma ka pūnaewele.
Msg 824, Papa 24, Mokuʻāina 2, laina 8
SQL Server ua ʻike ʻia kahi hewa I/O e pili ana i ka lokahi: helu helu hewa (manaʻo ʻia: 0xeddf7c98; maoli: 0xed637c9c). Ua loaʻa ia ma ka heluhelu ʻana o ka ʻaoʻao (1:53) ma ka waihona ID 39 ma offset 0x0000000006a000 ma ka waihona 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Nā memo hou ma ka SQL Server hiki ke hāʻawi i nā kikoʻī hou aku i ka log error a i ʻole ka log event system. He kūlana hewa nui kēia e hoʻoweliweli ana i ka pono o ka waihona a pono e hoʻoponopono koke ʻia. E hoʻopiha i kahi hōʻoia ʻikepili piha piha (DBCC CHECKDB). Hiki ke kumu o kēia hewa e nā kumu he nui; no ka 'ike hou aku, e nana SQL Server Nā puke ma ka pūnaewele.
Msg 824, Papa 24, Mokuʻāina 2, laina 8
SQL Server ua ʻike ʻia kahi hewa I/O e pili ana i ka lokahi: helu helu hewa (manaʻo ʻia: 0xeddf7c98; maoli: 0xed637c9c). Ua loaʻa ia ma ka heluhelu ʻana o ka ʻaoʻao (1:53) ma ka waihona ID 39 ma offset 0x0000000006a000 ma ka waihona 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Nā memo hou ma ka SQL Server hiki ke hāʻawi i nā kikoʻī hou aku i ka log error a i ʻole ka log event system. He kūlana hewa nui kēia e hoʻoweliweli ana i ka pono o ka waihona a pono e hoʻoponopono koke ʻia. E hoʻopiha i kahi hōʻoia ʻikepili piha piha (DBCC CHECKDB). Hiki ke kumu o kēia hewa e nā kumu he nui; no ka 'ike hou aku, e nana SQL Server Nā puke ma ka pūnaewele.
or
Hoʻoponopono: Ua kūkulu hou ʻia ka papa kuhikuhi Clustered no ka mea "syscolpars" ma ka waihona "Error1".
Hoʻoponopono: Ua kūkulu hou ʻia ka papa kuhikuhi Nonclustered no ka mea "syscolpars" ma ka waihona "Error1".
Nā hualoaʻa DBCC no 'Error1'.
Service Broker Msg 9675, State 1: Nā ʻano memo i kālailai ʻia: 14.
Service Broker Msg 9676, Mokuʻāina 1: Nā ʻaelike lawelawe i kālailai ʻia: 6.
Service Broker Msg 9667, State 1: Nā lawelawe i kālailai ʻia: 3.
Service Broker Msg 9668, Mokuʻāina 1: Nānā ʻia nā Queues Service: 3.
Service Broker Msg 9669, Mokuʻāina 1: Nānā ʻia nā helu hope kamaʻilio: 0.
Service Broker Msg 9674, Mokuʻāina 1: Nānā ʻia nā hui kamaʻilio: 0.
Service Broker Msg 9670, Mokuʻāina 1: Hoʻopaʻa ʻia nā hoʻopaʻa lawelawe mamao: 0.
Service Broker Msg 9605, Mokuʻāina 1: Nānā ʻia nā mea nui o ke kamaʻilio ʻana: 0.
Msg 8992, Papa 16, Mokuʻāina 1, laina 8
E nānā i ka Catalog Msg 3852, Mokuʻāina 1: ʻAʻohe lālani kūpono i ka lālani (object_id=23) ma sys.objects (type=S ) (object_id=23,column_id=1) ma sys.columns.
Msg 8992, Papa 16, Mokuʻāina 1, laina 8
E nānā i ka Catalog Msg 3852, Mokuʻāina 1: ʻAʻohe lālani kūpono i ka lālani (object_id=24) ma sys.objects (type=S ) (object_id=24,column_id=1) ma sys.columns.
Ua loaʻa iā CHECKDB 0 nā hewa hoʻokaʻawale a me 2 mau hewa kūlike ʻaʻole pili i kekahi mea hoʻokahi.
Nā hualoaʻa DBCC no 'sys.sysrscols'.
He 1092 lālani ma 14 ʻaoʻao no ka mea "sys.sysrscols".
Nā hualoaʻa DBCC no 'sys.sysrowsets'.
He 148 lālani ma 3 ʻaoʻao no ka mea "sys.sysrowsets".
Nā hualoaʻa DBCC no 'sys.sysclones'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysclones".
Nā hualoaʻa DBCC no 'sys.sysallocunits'.
He 172 lālani ma 2 ʻaoʻao no ka mea "sys.sysallocunits".
Nā hualoaʻa DBCC no 'sys.sysfiles1'.
Aia 2 lālani ma 1 ʻaoʻao no ka mea "sys.sysfiles1".
Nā hualoaʻa DBCC no 'sys.sysseobjvalues'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysseobjvalues".
Nā hualoaʻa DBCC no 'sys.syspriorities'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syspriorities".
Nā hualoaʻa DBCC no 'sys.sysdbflole lole'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysdbflole lole”.
Nā hualoaʻa DBCC no 'sys.sysfgfrag'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysfgfrag".
Nā hualoaʻa DBCC no 'sys.sysdbfiles'.
He 2 lālani ma 1 ʻaoʻao no ka mea "sys.sysdbfiles”.
Nā hualoaʻa DBCC no 'sys.syspru'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syspru".
Nā hualoaʻa DBCC no 'sys.sysowners'.
He 14 lālani ma 1 ʻaoʻao no ka mea "sys.sysowners".
Nā hualoaʻa DBCC no 'sys.sysdbreg'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysdbreg".
Nā hualoaʻa DBCC no 'sys.sysprivs'.
He 140 lālani ma 1 ʻaoʻao no ka mea "sys.sysprivs".
Nā hualoaʻa DBCC no 'sys.sysschobjs'.
He 2262 lālani ma 29 ʻaoʻao no ka mea "sys.sysschobjs".
Nā hualoaʻa DBCC no 'sys.syscsrowgroups'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscsrowgroups".
Nā hualoaʻa DBCC no 'sys.sysexttables'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysexttables".
Nā hualoaʻa DBCC no 'sys.syscolpars'.
Hoʻoponopono: Ua kūkulu hou ʻia ka papa kuhikuhi Clustered no ka mea "sys.syscolpars" ma ka waihona "Error1".
Hoʻoponopono: Ua wehe ʻia ka ʻaoʻao (1:59) mai ka mea ID 41, index ID 1, ʻāpana ID 281474979397632, alloc unit ID 281474979397632 (type In-row data).
Hoʻoponopono: Ua kūkulu hou ʻia ka papa kuhikuhi Nonclustered no ka mea "sys.syscolpars, nc" ma ka waihona "Error1".
Msg 8945, Papa 16, Mokuʻāina 1, laina 8
Hapa papa: Object ID 41, index ID 1 e kūkulu hou ʻia.
Ua hoʻoponopono ʻia ka hewa.
Msg 8928, Papa 16, Mokuʻāina 1, laina 8
Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data): ʻAʻole hiki ke hana ʻia ka ʻaoʻao (1:59). E ʻike i nā hewa ʻē aʻe no nā kikoʻī.
Ua hoʻoponopono ʻia ka hewa.
Msg 8939, Papa 16, Mokuʻāina 98, laina 8
Hapa papa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data), page (1:59). ʻAʻole hiki ke hoʻāʻo (IS_OFF (BUF_IOERR, pBUF->bstat)). ʻO 2057 a me -4 nā waiwai.
Ua hoʻoponopono ʻia ka hewa.
Msg 8976, Papa 16, Mokuʻāina 1, laina 8
Hapa papa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). ʻAʻole ʻike ʻia ka ʻaoʻao (1:59) ma ka scan ʻoiai ʻo kona makua (1:111) a me ka mua (1:155) i kuhikuhi iā ia. E nānā i nā hewa ma mua.
Ua hoʻoponopono ʻia ka hewa.
Msg 8978, Papa 16, Mokuʻāina 1, laina 8
Hapa papa: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Aia ka ʻaoʻao (1:112) i kahi kuhikuhi mai ka ʻaoʻao mua (1:59). Pilikia pili kaulahao paha.
Ua hoʻoponopono ʻia ka hewa.
Msg 8945, Papa 16, Mokuʻāina 1, laina 8
Hapa papa: Object ID 41, index ID 2 e kūkulu hou ʻia.
Ua hoʻoponopono ʻia ka hewa.
He 832 lālani ma 15 ʻaoʻao no ka mea "sys.syscolpars".
Ua loaʻa iā CHECKDB 0 nā hewa hoʻokaʻawale a me 4 mau hewa kūlike ma ka papa 'sys.syscolpars' (mea ID 41).
Ua hoʻopaʻa ʻo CHECKDB i nā hewa hoʻokaʻawale 0 a me 4 mau hewa kūlike ma ka papa 'sys.syscolpars' (mea ID 41).
Nā hualoaʻa DBCC no 'sys.sysxlgns'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysxlgns".
Nā hualoaʻa DBCC no 'sys.sysxsrvs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysxsrvs".
Nā hualoaʻa DBCC no 'sys.sysnsobjs'.
Aia 1 lālani ma 1 ʻaoʻao no ka mea "sys.sysnsobjs".
Nā hualoaʻa DBCC no 'sys.sysusermsgs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysusermsgs".
Nā hualoaʻa DBCC no 'sys.syscerts'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscerts".
Nā hualoaʻa DBCC no 'sys.sysrmtlgns'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysrmtlgns".
Nā hualoaʻa DBCC no 'sys.syslnklgns'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syslnklgns".
Nā hualoaʻa DBCC no 'sys.sysxprops'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysxprops".
Nā hualoaʻa DBCC no 'sys.sysscalartypes'.
He 34 lālani ma 1 ʻaoʻao no ka mea "sys.sysscalartypes".
Nā hualoaʻa DBCC no 'sys.sytypedsubobjs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sytypedsubobjs".
Nā hualoaʻa DBCC no 'sys.sysidxstats'.
He 207 lālani ma 5 ʻaoʻao no ka mea "sys.sysidxstats".
Nā hualoaʻa DBCC no 'sys.sysiscols'.
He 399 lālani ma 2 ʻaoʻao no ka mea "sys.sysiscols".
Nā hualoaʻa DBCC no 'sys.sysendpts'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysendpts".
Nā hualoaʻa DBCC no 'sys.syswebmethods'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syswebmethods".
Nā hualoaʻa DBCC no 'sys.sysbinobjs'.
He 23 lālani ma 1 ʻaoʻao no ka mea "sys.sysbinobjs".
Nā hualoaʻa DBCC no 'sys.sysaudacts'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysaudacts".
Nā hualoaʻa DBCC no 'sys.sysobjvalues'.
He 213 lālani ma 21 ʻaoʻao no ka mea "sys.sysobjvalues".
Nā hualoaʻa DBCC no 'sys.syscscolsegments'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscscolsegments".
Nā hualoaʻa DBCC no 'sys.syscsdictionaries'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscsdictionaries".
Nā hualoaʻa DBCC no 'sys.sysclsobjs'.
He 16 lālani ma 1 ʻaoʻao no ka mea "sys.sysclsobjs".
Nā hualoaʻa DBCC no 'sys.sysrowsetrefs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysrowsetrefs".
Nā hualoaʻa DBCC no 'sys.sysremsvcbinds'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysremsvcbinds".
Nā hualoaʻa DBCC no 'sys.sysxmitqueue'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysxmitqueue".
Nā hualoaʻa DBCC no 'sys.sysrts'.
Aia 1 lālani ma 1 ʻaoʻao no ka mea "sys.sysrts".
Nā hualoaʻa DBCC no 'sys.syscovgroup'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscovgroup".
Nā hualoaʻa DBCC no 'sys.sysdesend'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysdesend".
Nā hualoaʻa DBCC no 'sys.sysdercv'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysdercv".
Nā hualoaʻa DBCC no 'sys.syssingleobjrefs'.
He 171 lālani ma 1 ʻaoʻao no ka mea "sys.syssingleobjrefs".
Nā hualoaʻa DBCC no 'sys.sysmultiobjrefs'.
He 107 lālani ma 1 ʻaoʻao no ka mea "sys.sysmultiobjrefs".
Nā hualoaʻa DBCC no 'sys.sysguidrefs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysguidrefs".
Nā hualoaʻa DBCC no 'sys.sysfoqueues'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysfoqueues".
Nā hualoaʻa DBCC no 'sys.syschildinsts'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syschildinsts".
Nā hualoaʻa DBCC no 'sys.syscompfragments'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscompfragments".
Nā hualoaʻa DBCC no 'sys.sysftsemanticsdb'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysftsemanticsdb".
Nā hualoaʻa DBCC no 'sys.sysftstops'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysftstops".
Nā hualoaʻa DBCC no 'sys.sysftproperties'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysftproperties".
Nā hualoaʻa DBCC no 'sys.sysxmitbody'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysxmitbody".
Nā hualoaʻa DBCC no 'sys.sysfos'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysfos".
Nā hualoaʻa DBCC no 'sys.sysqnames'.
He 98 lālani ma 1 ʻaoʻao no ka mea "sys.sysqnames".
Nā hualoaʻa DBCC no 'sys.sysxmlcomponent'.
He 100 lālani ma 1 ʻaoʻao no ka mea "sys.sysxmlcomponent".
Nā hualoaʻa DBCC no 'sys.sysxmlfacet'.
He 112 lālani ma 1 ʻaoʻao no ka mea "sys.sysxmlfacet".
Nā hualoaʻa DBCC no 'sys.sysxmlplacement'.
He 19 lālani ma 1 ʻaoʻao no ka mea "sys.sysxmlplacement".
Nā hualoaʻa DBCC no 'sys.sysobjkeycrypts'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysobjkeycrypts".
Nā hualoaʻa DBCC no 'sys.sysasymkeys'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sysasymkeys".
Nā hualoaʻa DBCC no 'sys.syssqlguides'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syssqlguides".
Nā hualoaʻa DBCC no 'sys.sysbinsubobjs'.
Aia 3 lālani ma 1 ʻaoʻao no ka mea "sys.sysbinsubobjs".
Nā hualoaʻa DBCC no 'sys.syssoftobjrefs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syssoftobjrefs".
Nā hualoaʻa DBCC no 'sys.plan_persist_plan'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_plan".
Nā hualoaʻa DBCC no 'sys.plan_persist_runtime_stats'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_runtime_stats".
Nā hualoaʻa DBCC no 'sys.plan_persist_runtime_stats_interval'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_runtime_stats_interval".
Nā hualoaʻa DBCC no 'sys.plan_persist_context_settings'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_context_settings".
Nā hualoaʻa DBCC no 'sys.sqlagent_jobs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sqlagent_jobs".
Nā hualoaʻa DBCC no 'sys.sqlagent_jobsteps'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sqlagent_jobsteps".
Nā hualoaʻa DBCC no 'sys.sqlagent_job_history'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sqlagent_job_history".
Nā hualoaʻa DBCC no 'sys.sqlagent_jobsteps_logs'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.sqlagent_jobsteps_logs".
Nā hualoaʻa DBCC no 'TestTable'.
Aia 11000 lālani ma 110 ʻaoʻao no ka mea "TestTable".
Nā hualoa‘a DBCC no 'sys.queue_messages_1977058079'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.queue_messages_1977058079".
Nā hualoa‘a DBCC no 'sys.queue_messages_2009058193'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.queue_messages_2009058193".
Nā hualoa‘a DBCC no 'sys.queue_messages_2041058307'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.queue_messages_2041058307".
Nā hualoa‘a DBCC no 'sys.filestream_tombstone_2073058421'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.filestream_tombstone_2073058421".
Nā hualoaʻa DBCC no 'sys.syscommittab'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.syscommittab".
Nā hualoa‘a DBCC no 'sys.filetable_updates_2105058535'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.filetable_updates_2105058535".
Nā hualoaʻa DBCC no 'sys.plan_persist_query_text'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_query_text".
Nā hualoaʻa DBCC no 'sys.plan_persist_query'.
He 0 lālani ma 0 ʻaoʻao no ka mea "sys.plan_persist_query".
Ua loaʻa iā CHECKDB 0 nā hewa hoʻokaʻawale a me 6 mau hewa kūlike i ka waihona 'Error1'.
Ua hoʻoponopono ʻo CHECKDB i nā hewa hoʻokaʻawale 0 a me 4 mau hewa kūlike i ka waihona 'Error1'.
Ua pau ka hoʻokō ʻana o DBCC. Inā paʻi ʻo DBCC i nā memo hewa, e kelepona i kāu luna hoʻonohonoho.
Msg 824, Papa 24, Mokuʻāina 2, laina 8
SQL Server ua ʻike ʻia kahi hewa I/O e pili ana i ka lokahi: helu helu hewa (manaʻo ʻia: 0x9eb87140; ʻoiaʻiʻo: 0xdeb84c40). Loaʻa ia i ka heluhelu ʻana o ka ʻaoʻao (1:59) ma ka waihona ID 39 ma offset 0x00000000076000 ma ka waihona 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Nā memo hou ma ka SQL Server hiki ke hāʻawi i nā kikoʻī hou aku i ka log error a i ʻole ka log event system. He kūlana hewa nui kēia e hoʻoweliweli ana i ka pono o ka waihona a pono e hoʻoponopono koke ʻia. E hoʻopiha i kahi hōʻoia ʻikepili piha piha (DBCC CHECKDB). Hiki ke kumu o kēia hewa e nā kumu he nui; no ka 'ike hou aku, e nana SQL Server Nā puke ma ka pūnaewele.
Msg 824, Papa 24, Mokuʻāina 2, laina 8
SQL Server ua ʻike ʻia kahi hewa I/O e pili ana i ka lokahi: helu helu hewa (manaʻo ʻia: 0x9eb87140; ʻoiaʻiʻo: 0xdeb84c40). Loaʻa ia i ka heluhelu ʻana o ka ʻaoʻao (1:59) ma ka waihona ID 39 ma offset 0x00000000076000 ma ka waihona 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Nā memo hou ma ka SQL Server hiki ke hāʻawi i nā kikoʻī hou aku i ka log error a i ʻole ka log event system. He kūlana hewa nui kēia e hoʻoweliweli ana i ka pono o ka waihona a pono e hoʻoponopono koke ʻia. E hoʻopiha i kahi hōʻoia ʻikepili piha piha (DBCC CHECKDB). Hiki ke kumu o kēia hewa e nā kumu he nui; no ka 'ike hou aku, e nana SQL Server Nā puke ma ka pūnaewele.
Msg 824, Papa 24, Mokuʻāina 2, laina 8
SQL Server ua ʻike ʻia kahi hewa I/O e pili ana i ka lokahi: helu helu hewa (manaʻo ʻia: 0x9eb87140; ʻoiaʻiʻo: 0xdeb84c40). Loaʻa ia i ka heluhelu ʻana o ka ʻaoʻao (1:59) ma ka waihona ID 39 ma offset 0x00000000076000 ma ka waihona 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Nā memo hou ma ka SQL Server hiki ke hāʻawi i nā kikoʻī hou aku i ka log error a i ʻole ka log event system. He kūlana hewa nui kēia e hoʻoweliweli ana i ka pono o ka waihona a pono e hoʻoponopono koke ʻia. E hoʻopiha i kahi hōʻoia ʻikepili piha piha (DBCC CHECKDB). Hiki ke kumu o kēia hewa e nā kumu he nui; no ka 'ike hou aku, e nana SQL Server Nā puke ma ka pūnaewele.
Msg 824, Papa 24, Mokuʻāina 2, laina 8
SQL Server ua ʻike ʻia kahi hewa I/O e pili ana i ka lokahi: helu helu hewa (manaʻo ʻia: 0x9eb87140; ʻoiaʻiʻo: 0xdeb84c40). Loaʻa ia i ka heluhelu ʻana o ka ʻaoʻao (1:59) ma ka waihona ID 39 ma offset 0x00000000076000 ma ka waihona 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Nā memo hou ma ka SQL Server hiki ke hāʻawi i nā kikoʻī hou aku i ka log error a i ʻole ka log event system. He kūlana hewa nui kēia e hoʻoweliweli ana i ka pono o ka waihona a pono e hoʻoponopono koke ʻia. E hoʻopiha i kahi hōʻoia ʻikepili piha piha (DBCC CHECKDB). Hiki ke kumu o kēia hewa e nā kumu he nui; no ka 'ike hou aku, e nana SQL Server Nā puke ma ka pūnaewele.
kahi 'Error1' ka inoa o ka waihona MDF ino e hooponopono ana.
Msg 8992 ukali ma Msg 3852 ʻo ka hewa he hewa kūlike.
Kiʻi kiʻi o ka memo hewa:
or
Wehewehe pololei:
i ka SQL Server MDF waihona, he nui nā papa ʻōnaehana hoʻohana ʻia e mālama i ke ʻano a me ka ʻikepili meta o ka waihona.
Ke ʻike ʻo CHECKDB aia nā ʻokoʻa ma waena o nā papa ʻōnaehana ʻelua, e hōʻike ia i ka memo hewa Msg 8992 a me Msg 3852.
Hiki iā ʻoe ke hoʻohana i kā mākou huahana DataNumen SQL Recovery e hoʻihoʻi i ka ʻikepili mai ka faila MDF hewa a hoʻoponopono i kēia hewa.
Nā waihona laʻana:
E hoʻāʻo i nā faila MDF hewa e hoʻokau i kaMsg 8992 a me Msg 3852 kikowaena:
| SQL Server mana | Ua hewa ka waihona MDF | Ua hoʻoponopono ʻia ka faila MDF e DataNumen SQL Recovery |
| SQL Server 2014 | Hapa4_1.mdf | Hapa4_1_fixed.mdf |
| SQL Server 2014 | Hapa4_2.mdf | Hapa4_2_fixed.mdf |