Ha o sebelisa Microsoft SQL Server ho hokela kapa ho fihlella file e senyehileng ea database ea MDF, o tla bona melaetsa e fapaneng ea liphoso, e kanna ea u ferekanya. Ka hona, mona re tla leka ho thathamisa liphoso tsohle tse ka bang teng, tse hlophiloeng ho latela makhetlo a tsona a hlahang. Bakeng sa phoso e ngoe le e ngoe, re tla hlalosa matšoao a eona, re hlalose lebaka la eona le ho fana ka mehlala ea lifaele hammoho le faele e hlophisitsoeng ke rona DataNumen SQL Recovery, e le hore u ka li utloisisa hamolemo. Ka tlase re tla sebelisa 'xxx.MDF' ho hlahisa bobolu ba hau SQL Server Lebitso la faele la database la MDF.
Ho ipapisitsoe le SQL Server kapa melaetsa ea phoso ea CHECKDB, ho na le mefuta e meraro ea liphoso e tla baka ho hloleha:

    1. Liphoso tsa kabo: Rea tseba hore tlhaiso-leseling e fumanehang ho lifaele tsa MDF & NDF li abetsoe e le maqepheng. Hona le maqephe a khethehileng a sebelisetsoang taolo ea kabo, ka tsela e latelang:
Mofuta oa Leqephe Tlhaloso
Leqephe la GAM Boloka leseli la 'mapa oa kabelo ea lefatše (GAM).
Leqephe la SGAM Boloka lintlha tse arolelanoeng tsa 'mapa oa kabo ea lefatše (SGAM).
Leqephe la IAM Tlhahisoleseling ea 'mapa oa kabo ea lebenkele (IAM).
Leqephe la PFS Boloka leseli la kabo ea PFS.

Haeba efe kapa efe ea maqephe a kabo e kaholimo a na le liphoso, kapa lintlha tse laoloang ke maqephe ana a kabo ha li lumellane le tlhaiso-leseling ea kabo, SQL Server kapa CHECKDB e tla tlaleha liphoso tsa kabo.

  • Liphoso tse sa fetoheng: etsoe maqepheng tse sebelisetsoang ho boloka lintlha, ho kenyeletsoa maqephe a data le maqephe a li-index, haeba SQL Server kapa CHECKDB e fumana ho se lumellane leha e le hofe lipakeng tsa litaba tsa leqephe le checksum, ebe ba tla tlaleha liphoso tsa ho se lumellane.
  • Liphoso tse ling kaofela: Ho kanna ha ba le liphoso tse ling tse sa oeleng ka mekhahlelo e 'meli e kaholimo.

 

SQL Server e na le sesebelisoa se hahelletsoeng se bitsoang DBCC, e nang le TLHOKOMELO 'me HLALELETSA likhetho tse ka thusang ho lokisa database tsa MDF tse senyehileng. Leha ho le joalo, bakeng sa lifaele tsa database tsa MDB tse senyehileng haholo, TLHOKOMELISO DBCC 'me HLALELETSA le eona e tla hloleha.

Liphoso tse sa fetoheng tse tlalehiloeng ke CHECKDB:

Liphoso tsa kabo tse tlalehiloeng ke CHECKDB:

Liphoso tse ling tsohle tse tlalehiloeng ke CHECKDB: