Shrink  SQL Server log

SQL Server Management Studio
Created date 2025-04-10

1. Check the Size of files *.ldf

1. Masuk & login ke  SQL Server Management Studio
2. Pilih database misal “CSO1”, klik kanan pilih Properties
3. Options ganti Recovery model ke Simple

1. Task >> Shrink >> Files

1. Ganti jadi 0

1. Check file tsb apakah sudah bersih ?

1. Selesai