Lokacin amfani da Microsoft SQL Server don haɗawa ko samun dama ga gurbatattun fayil ɗin bayanai na MDF, ƙila ku haɗu da saƙon kuskure iri-iri waɗanda zasu iya zama ruɗani. A ƙasa, za mu jera duk kurakurai, ana jerawa ta mita. Ga kowane kuskure, za mu zayyana alamun sa, mu bayyana ainihin dalilin, da samar da fayilolin samfurin tare da fayilolin da aka gyara DataNumen SQL Recovery. Wannan zai taimake ka ka fahimci waɗannan kurakurai. Lura 'xxx.MDF' zai wakilci sunan gurɓataccen ku SQL Server MDF fayil ɗin bayanai.

bisa SQL Server ko saƙon kuskure na CHECKDB, akwai kurakurai iri uku:

    1. Kurakurai kasajewa: Mun san bayanai a cikin fayilolin MDF & NDF an kasafta azaman shafukan. Kuma akwai wasu shafuka na musamman waɗanda ake amfani dasu don gudanarwa, kamar haka:
Nau'in Shafi description
GAM Shafin Adana bayanan taswirar duniya (GAM).
Shafin SGAM Adana bayanan raba taswirar duniya (SGAM).
Shafin IAM Taswirar kasafi na ma'auni (IAM) bayanai.
Shafin PFS Adana bayanan raba PFS.

Idan kowane ɗayan shafukan yanar gizo na sama yana da kurakurai, ko kuma bayanan da waɗannan shafuka keɓaɓɓu ke gudanarwa bai dace da bayanan rabon ba, SQL Server ko CHECKDB zai bada rahoto kurakurai kasafi.

  • Kuskuren daidaito: Ma shafukan waɗanda ake amfani dasu don adana bayanai, gami da shafukan bayanai da shafukan fihirisa, idan SQL Server ko CHECKDB sun sami wani rashin daidaito tsakanin abubuwan da ke shafin da cak, to za su bayar da rahoto daidaito kurakurai.
  • Duk sauran kurakurai: Zai yiwu akwai wasu kurakurai ba su faɗa cikin fannoni biyu na sama ba.

 

SQL Server yana da kayan aikin ginannen da ake kira Farashin DBCC, wanda yake da Bincika da kuma Dubawa zaɓuɓɓukan da zasu iya taimakawa wajen gyara ɓatattun bayanan MDF. Koyaya, don manyan fayilolin bayanan MDB da suka lalace, Farashin DBCC da kuma Dubawa shima zai kasa.

Kuskuren daidaito da CHECKDB ya ruwaito:

Kurakuran rabuwa da CHECKDB ya ruwaito:

Duk sauran kuskuren da CHECKDB ya ruwaito: