Because Coscomis's database is getting bigger, its transaction log file is getting bigger and bigger, has reached nearly 2G, and finally studied how to shrink the database today, it is very simple.
- Clear Log Dump Transaction Database name with no_log
- Truncate Transaction Log Backup Log Database Name with no_log
- Shrink Database DBCC ShrinkDatabase (Database Name)
I use DBCC ShrinkDatabase (cosComis), the execution 1.8G transaction log is 1M, huh, huh!
