Lapho usebenzisa iMicrosoft SQL Server ukuze unamathisele noma ufinyelele ifayili ledatha le-MDF elonakele, uzobona imilayezo yamaphutha ehlukahlukene, engahle ikudide. Ngakho-ke, lapha sizozama ukufaka kuhlu wonke amaphutha angenzeka, ahlelwe ngokuya ngemvamisa yawo evela. Ngephutha ngalinye, sizochaza uphawu lwayo, sichaze isizathu salo esiqondile futhi sinikeze amafayela wesampula kanye nefayela elilungiswe yithi DataNumen SQL Recovery, ukuze uziqonde kangcono. Ngezansi sizosebenzisa i- 'xxx.MDF' ukuveza inkohlakalo yakho SQL Server Igama lefayela ledatha ye-MDF.
Ngokusekelwe ku SQL Server noma imilayezo yephutha ye-CHECKDB, kunezinhlobo ezintathu zamaphutha ezizodala ukwehluleka:

    1. Amaphutha okwabiwa: Siyazi ukuthi idatha emafayilini e-MDF ne-NDF yabelwe njenge- amakhasi. Futhi kunamakhasi akhethekile asetshenziselwa ukuphathwa kwesabelo, ngokulandelayo:
Uhlobo lwekhasi Incazelo
Ikhasi le-GAM Gcina imininingwane yemephu yokwabiwa komhlaba wonke (GAM).
Ikhasi le-SGAM Gcina imininingwane eyabiwe yemephu yokwabiwa komhlaba wonke (SGAM).
Ikhasi le-IAM Imininingwane yemephu yesabelo sesitolo (IAM).
Ikhasi le-PFS Gcina imininingwane yokwabiwa kwe-PFS.

Uma ngabe amanye amakhasi okwabiwa ngenhla enamaphutha, noma idatha ephethwe yilawa makhasi esabelo ayihambelani nemininingwane yokwabiwa, lapho-ke SQL Server noma i-CHECKDB izobika amaphutha wokwabiwa.

  • Amaphutha wokuvumelana: Ukuze amakhasi ezisetshenziselwa ukugcina idatha, kufaka phakathi amakhasi wedatha namakhasi wezinkomba, uma SQL Server noma i-CHECKDB ithola noma yikuphi ukungahambisani phakathi kokuqukethwe kwekhasi ne-checksum, khona-ke bazobika ukungaguquguquki kwamaphutha.
  • Wonke amanye amaphutha: Kungaba namanye amaphutha angaweli ezigabeni ezimbili ezingenhla.

 

SQL Server inethuluzi elakhelwe ngaphakathi elibizwa nge- I-DBCC, eye I-CHECKDB futhi HLOLA izinketho ezingasiza ukulungisa i-database ye-MDF ekhohlakele. Kodwa-ke, kumafayili wedatha we-MDB owonakele kakhulu, I-DBCC CHECKDB futhi HLOLA nayo izokwehluleka.

Amaphutha okungaguquguquki abikwe yi-CHECKDB:

Amaphutha okwabiwa abikwe yi-CHECKDB:

Wonke amanye amaphutha abikwe yi-CHECKDB: