Ukufumana kwakhona SQL Server Idatha esuka kwi tempdb.mdf

Nini SQL Server iyasebenza, iya kugcina yonke itemporary idatha, kuquka yonke temporary iitafile kunye neenkqubo zokugcina, zibe temporary idatabase ebizwa ngokuba yi tempdb.mdf. Xa intlekele yedatha isenzeka, ukuba awukwazi ukubuyisela idatha efunwayo kwi-mdf ekhoyo kunye neefayile ze-ndf ezinxulumene, usenokukwazi ukubuyisela idatha yakho kwi-temdb.mdf, ngokusebenzisa DataNumen SQL Recovery, ngoku Landelayo:

  1. Yeka SQL Server Inkonzo yeNjini yedatha.
  2. Usebenzisa umsebenzi wokukhangela weWindows ukukhangela ifayile ye tempdb.mdf kwikhompyuter apho i SQL Server umzekelo ufakiwe.
  3. Emva kokuba ufumene i tempdb.mdf, ungayikhetha njengefayile yemvelaphi eza kulungiswa, kwaye usebenzise DataNumen SQL Recovery ukuyilungisa.