Cov txheej txheem:

LDF file yog dab tsi?
LDF file yog dab tsi?

Video: LDF file yog dab tsi?

Video: LDF file yog dab tsi?
Video: हार्ट की पम्पिंग पावर बढ़ाये नैचुरली | इजेक्शन फ्रैक्शन (Ejection Fraction) | Dr. Bimal Chhajer 2024, Kaum ib hlis
Anonim

Ib LDF cov ntaub ntawv yog log ntaub ntawv tsim los ntawm SQLServer, kev sib raug zoo database tswj system (RDBMS) tsim los ntawm Microsoft. Nws muaj ib lub cav ntawm kev ua tsis ntev los no tau ua los ntawm thedatabase thiab yog siv los taug qab cov xwm txheej kom cov ntaub ntawv tuaj yeem rov qab los ntawm cov khoom siv tsis ua haujlwm lossis lwm yam kev npaj txhij txog.

Xav txog qhov no, cov ntaub ntawv LDF puas tuaj yeem raug tshem tawm?

Lub hlis kawg snapshots yog nruj me ntsis rau kev tshaj tawm lub hom phiaj, tsis muaj kev ntxig, hloov tshiab lossis tshem tawm puas tau ua rau lawv. Txhua qhov snapshots muaj. MDF thiab. LDF cov ntaub ntawv . Kuv xav tau rho tawm cov. LDF cov ntaub ntawv thiab tso qee qhov chaw ntawm lub server.

Tsis tas li, kuv yuav txo qhov loj ntawm kuv cov ntaub ntawv LDF li cas? Thaum cov thaub qab tau ua tiav, nres qhov kev pabcuam SQL neeg rau zaub mov, ces txoj nyem rau ntawm lub database thiab xaiv Tasks> Txo > Shrink Cov ntaub ntawv . Xaiv Log li tus ntaub ntawv hom thiab xaiv Tso qhov chaw tsis siv.

Txhawm rau txo cov ntaub ntawv.ldf, koj yuav tsum ua peb yam:

  1. Backup lub database.
  2. Nres qhov kev pabcuam database.
  3. Txo cov ntaub ntawv.ldf.

Kuj tseem paub yog, MDF thiab LDF cov ntaub ntawv yog dab tsi?

1. MDF yog cov ntaub ntawv tseem ceeb ntaub ntawv rau MSSQL. The LDF , ntawm qhov tod tes, yog kev txhawb nqa ntaub ntawv andis characterized as a server transaction log ntaub ntawv .2. MDF muaj tag nrho cov ntaub ntawv tseem ceeb thiab tsim nyog nyob rau hauvdatabases thaum lub LDF muaj tag nrho cov kev nqis tes ua uas suav nrog kev hloov pauv thiab hloov pauv hauv MDFfile.

Kuv tuaj yeem qhib LDF cov ntaub ntawv hauv SQL Server li cas?

Saib cov ntaub ntawv log

  1. Txoj cai-nias SQL Server Logs, taw tes rau Saib, thiab tom qab ntawd nyem rau ntawm SQL Server Log lossis SQL Server thiab Windows Log.
  2. Nthuav SQL Server Logs, right-click any log file, and thennclick View SQL Server Log. Koj tseem tuaj yeem nyem ob npaug rau txhua lub logfile.

Pom zoo: