Lokacin da kake amfani da Microsoft SQL Server don haɗawa ko samun dama ga fayil na MDF mai lalata, za ku ga saƙonnin kuskure daban-daban, waɗanda na iya ɗan rikice muku. Saboda haka, a nan za mu yi ƙoƙari mu lissafa duk kurakuran da za a iya yi, ana jera su gwargwadon yadda suke faruwa. Ga kowane kuskure, za mu bayyana alamunsa, bayyana ainihin dalilinsa kuma mu ba da fayilolin samfuri da fayil ɗin da namu ya gyara DataNumen SQL Recovery, domin ku fahimce su sosai. A ƙasa za mu yi amfani da 'xxx.MDF' don bayyana lalacewar ku SQL Server Sunan fayil din MDF.
bisa SQL Server ko CHECKDB saƙonnin kuskure, akwai nau'ikan kurakurai guda uku waɗanda zasu haifar da gazawa:

    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 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, DBCC CHECKDB 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: