Mukamagwiritsa ntchito Microsoft SQL Server kulumikiza kapena kulumikiza fayilo yachinyengo ya MDF, muwona mauthenga olakwika osiyanasiyana, omwe atha kukusokonezani. Chifukwa chake, apa tiyesa kulemba zolakwika zonse zomwe zingachitike, zosanjidwa molingana ndi kuchuluka kwawo. Pa cholakwika chilichonse, tifotokoza chizindikiro chake, tifotokoze chifukwa chake ndikupereka mafayilo amawu komanso fayilo yomwe idakonzedwa ndi yathu DataNumen SQL Recovery, kuti mumvetsetse bwino. Pansipa tigwiritsa ntchito 'xxx.MDF' posonyeza kuwonongeka kwanu SQL Server Dzina la fayilo ya database ya MDF.
Kutengera SQL Server kapena mauthenga olakwika a CHECKDB, pali mitundu itatu yazolakwika zomwe zingayambitse kulephera:

    1. Zolakwitsa pakugawa: Tikudziwa kuti mafailo a MDF & NDF amaperekedwa monga masamba. Ndipo pali masamba ena apadera omwe amagwiritsidwa ntchito poyang'anira magawidwe, motere:
Mtundu Watsamba Kufotokozera
Tsamba la GAM Sungani zambiri zamapu apadziko lonse lapansi (GAM).
Tsamba la SGAM Sungani zambiri za mapu apadziko lonse lapansi (SGAM).
Tsamba la IAM Zambiri zama mapu a magawo azosunga (IAM).
Tsamba la PFS Sungani zambiri za kagawidwe ka PFS.

Ngati masamba aliwonse omwe atchulidwa pamwambapa ali ndi zolakwika, kapena zomwe zimayendetsedwa ndi masambawa sizikugwirizana ndi zomwe amagawa, ndiye kuti SQL Server kapena CHECKDB ipereka lipoti Zolakwitsa zakugawa.

  • Zolakwitsa mogwirizana: pakuti masamba zomwe zimagwiritsidwa ntchito posungira, kuphatikiza masamba azidziwitso ndi masamba amalozera, ngati SQL Server kapena CHECKDB imapeza kusagwirizana kulikonse pakati pazomwe zili patsamba ndi checksum, kenako azinena zolakwa kusasintha.
  • Zolakwa zina zonse: Pakhoza kukhala zolakwika zina zomwe sizingagwere m'magulu awiriwa.

 

SQL Server ali ndi chida chomangidwa chotchedwa Zamgululi, yomwe CHECKDB ndi KUYANG'ANIRA zosankha zomwe zingathandize kukonzanso nkhokwe zachinyengo za MDF. Komabe, pamafayilo osungidwa a MDB, Kufufuza ndi KUYANG'ANIRA adzalephera.

Zolakwitsa zosasinthasintha zomwe zafotokozedwa ndi CHECKDB:

Zolakwitsa pakugawa zomwe zalembedwa ndi CHECKDB:

Zolakwitsa zina zonse zomwe zalembedwa ndi CHECKDB: