Lapho usebenzisa iMicrosoft SQL Server ukuze unamathisele noma ufinyelele ifayela lesizindalwazi se-MDF elonakele, ungase uhlangane nemiyalezo yamaphutha ehlukahlukene engase ikudide. Ngezansi, sizoklelisa wonke amaphutha, ahlungwe ngokuvama. Ngephutha ngalinye, sizochaza izimpawu zalo, sichaze imbangela eqondile, futhi sinikeze amafayela ayisampula kanye namafayela alungiswe DataNumen SQL Recovery. Lokhu kuzokusiza ukuthi uqonde kangcono lawa maphutha. Qaphela ukuthi 'xxx.MDF' izomela igama labonakele bakho SQL Server Ifayela le-MDF database.

Ngokusekelwe ku SQL Server noma imilayezo yephutha ye-CHECKDB, kunezinhlobo ezintathu zamaphutha:

    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: