Compress SQL SERVER Log Files

Recently, the walnut network project did not add any data at the time of creation, but the log files were all 10 MB, so we found a compression method.
1. Find the database to be compressed, right-click and click "properties"
2. Select "option" and change the fault recovery mode to "simple" and click "OK"
3. Right-click the database to be compressed, select "all tasks", click "contract", select "Database", and click "OK"
4. Repeat Step 1 and change the fault recovery mode to "complete" and click "OK" in the options"

In this way, you will see that the log file is much smaller. Remember to perform Step 1!

Reference: http://or2.com.cn/blogview.asp? LogID = 869