Cov ntaub ntawv ldf tsis ntsws los ntawm nws tus kheej, lossis thaum koj tsim cov ntawv thaub qab. Txhawm rau txo cov ntaub ntawv ldf, koj siv lus txib hu ua DBCC SHRINKFILE (cov ntaub ntawv ntawm no). Koj tuaj yeem ua qhov no hauv SSMS los ntawm txoj cai-nias lub database, xaiv "Tasks", "Shrink" thiab "Files".
Kuv yuav ua li cas txo cov ntaub ntawv LDF hauv SQL Server?
Txhawm rau txo lub cav hauv SSMS, nyem nyem rau ntawm lub database, xaiv Tasks, Shrink, Cov ntaub ntawv:
- Ntawm lub qhov rai Shrink File, hloov hom Cov Ntaub Ntawv rau Log. …
- Shrink lub cav siv TSQL. …
- DBCC SHRINKFILE (AdventureWorks2012_log, 1)
Kuv yuav txo qis MDF thiab LDF cov ntaub ntawv li cas?
Yuav Ua Li Cas. mdf Cov ntaub ntawv hauv SQL Server
- Txuas mus rau SQL Server Management Studio, Mus rau Databases.
- Xaiv cov ntaub ntawv xav tau uas yuav tsum tau txo qis.
- Right-click on the database, Select Tasks >> Shrink >> Files.
- Nco ntsoov tias koj xaiv Cov Ntaub Ntawv Cov Ntaub Ntawv rau kev txo qis MDF Cov Ntaub Ntawv.
- Cov kev xaiv ntawm Shrink Option yog raws li nram no:
Kuv yuav ua li cas txo cov ntaub ntawv SQL neeg rau zaub mov?
Txhim kho cov ntaub ntawv lossis cov ntaub ntawv teev cia. Hauv Object Explorer, txuas mus rau ib qho piv txwv ntawm SQL Server Database Cav thiab tom qab ntawd nthuav qhov piv txwv ntawd. Expand Databases thiab ces right-click lub database uas koj xav kom shrink. Point to Tasks, taw tes rau Shrink, thiab tom qab ntawd nyem Cov Ntaub Ntawv.
Kuv puas tuaj yeem tshem LDF cov ntaub ntawv?
Qee zaum, covMicrosoft SQL Server Database Transaction Log (. LDF) cov ntaub ntawv yuav loj heev. Nws nkim ntau qhov chaw disk thiab ua rau qee qhov teeb meem yog tias koj xav tau thaub qab thiab kho cov ntaub ntawv. Peb tuaj yeem delete cov ntaub ntawv teev tseg thiab tsim cov ntaub ntawv teev npe tshiab nrog qhov tsawg kawg nkaus.
