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:
-
- 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.
- xxxx.mdf ba shine fayil na asali ba na asali. (Microsoft SQL Server, Kuskure: 5171)
- Rubutun kai don fayil 'xxxx.mdf' ba shine ingantaccen taken fayil din bayanai ba. Kadarorin FILE SIZE ba daidai bane. (Microsoft SQL Server, Kuskure: 5172)
- SQL Server gano kuskuren I / O mai daidaito mai ma'ana: ba daidai ba ne
- SQL Server gano kuskuren I / O mai daidaito mai ma'ana: tsage shafi
- Kuna share wasu bayanan ko wasu tebur a cikin ɗakunan ajiya bisa kuskure.
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:
- SQL Server gano kuskuren I / O mai daidaito mai ma'ana: ba daidai ba ne
- Jere a cikin sys.xxx ba shi da layi mai daidaita a cikin sys.xxx.
- Kuskuren tebur: Abubuwan ID ##, za a sake gina ID na ID ##.
- Ba za a iya sake ƙirƙirar wannan ma'aunin jadawalin tsarin ba.
- Lamarin ID ##, ID ID ##, ID na bangare ##, sanya ID ID ## (rubuta Ba a sani ba), ID na shafi (##: 560) ya ƙunshi ID ɗin shafi mara kyau a cikin taken shafin.
Kurakuran rabuwa da CHECKDB ya ruwaito:
- Taswirar Rarraba exididdigar (IAM) Shafin Mai Nuna Na Shafin IAM yake Nunawa
- Entari (##: ##) a cikin bayanan ID ## an yi alama a cikin GAM, amma babu SGAM ko IAM da suka ba shi.
Duk sauran kuskuren da CHECKDB ya ruwaito:
- Ba a yi nasarar ba: (- ########) Yin aiwatar da tambayar "DBCC CHECKDB (xxxx) TARE DA NO_INFOMSGS" ya gaza tare da kuskuren mai zuwa: “xxxx”.
- An gano kuskuren I / O (mummunan shafi ID) yayin karantawa a biya diyya 0x ###### a cikin fayil 'xxxx.mdf'.
- Tsarin Ba Zai Iya Amfani da isasshen Bayanan Bayanai Don Sake Sake Rubuta
- Rasa Bayanai A Lokacin Gyarawa Tare da CHECKDB
- Fayil ya bayyana cewa tsarin aikin ya yanke shi.
- Yayin sake yin wani aiki a cikin rumbun adana bayanan 'xxxx', kuskure ya faru a ID rikodin rajista.