Paunoshandisa Microsoft SQL Server kubatanidza kana kuwana yakashata MDF dhatabhesi faira, iwe uchaona akasiyana mhosho mameseji, izvo zvinogona kunge zvichikanganisa kwauri. Naizvozvo, pano isu tichaedza kunyora zvese zvingangoitika zvikanganiso, zvakarongedzwa zvichienderana nekuwanda kwavo kuitika. Kune imwe neimwe kukanganisa, isu tinotsanangura chiratidzo chayo, tsanangura chikonzero chayo chaicho uye topa sampuro mafaera pamwe nefaira rakagadziriswa neyedu DataNumen SQL Recovery, kuti iwe ugone kuvanzwisisa zviri nani. Pazasi isu tinoshandisa 'xxx.MDF' kuratidza huori hwako SQL Server MDF dhatabhesi zita refaira.
Maererano ne SQL Server kana CHECKDB mhosho mameseji, kune matatu marudzi emhosho ayo anogona kukonzera kutadza:

    1. Kugovera zvikanganiso: Isu tinoziva iyo data mune MDF & NDF mafaera akagoverwa se mapeji. Uye kune mamwe akakosha mapeji ayo anoshandiswa kuitira kugovera manejimendi, seinotevera:
Peji Rudzi tsananguro
GAM Peji Chengetedza pasi rose mepu yekugovera (GAM) info.
SGAM Peji Chengetedza yakagovaniswa yepasi rose kugovera mepu (SGAM) info.
IAM Peji Chitoro chekodhi yekugovera mepu (IAM) info.
PFS Peji Chengetedza PFS kugovera info.

Kana chero emapeji ekugovera ari pamusoro aine zvikanganiso, kana iyo data inochengetwa neaya mapeji ekuparadzanisa zvisingaenderane neruzivo rwekugovera, saka SQL Server kana CHECKDB inozivisa zvikanganiso zvekugovera.

  • Kukanganisa kusagadzikana: For mapeji ayo anoshandiswa kuchengeta data, kusanganisira iwo mapeji e data uye mapeji e index, kana SQL Server kana CHECKDB tsvaga chero kusapindirana pakati pezvirimo peji uye cheki, vanobva vazvitaurira kuwirirana zvikanganiso.
  • Zvimwe zvese zvikanganiso: Panogona kunge paine zvimwe zvikanganiso zvisingawire muzvikamu zviviri zviri pamusoro.

 

SQL Server ine mudziyo wakavakirwa unonzi DBCC, ine CHECKDB uye CHECKTABLE sarudzo dzinogona kubatsira kugadzirisa yakashata MDF dhatabhesi. Nekudaro, kune akanyanya akakuvara MDB dhata dhata, DBCC CHECKDB uye CHECKTABLE zvichakundikanawo.

Kukanganisa kusagadzikana kwakataurwa neCHECKDB:

Kugovera zvikanganiso zvinotaurwa neCHECKDB:

Zvimwe zvese zvikanganiso zvakataurwa naCHECKDB: