MS SQL Compressed Database logging method

Data | database | compression

The method inside Enterprise Manager:
1. Open Enterprise Manager
2, open the database to be processed
3, click on the top menu > Tools >sql Query Analyzer, open SQL Query Analyzer
4, enter in the input window:

Program code:

DUMP TRANSACTION [database name] with NO_LOG
BACKUP LOG [database name] with NO_LOG
DBCC shrinkdatabase ([database name])

Click on the green triangle (or press F5) to execute the query, and so on the status bar prompts processing completed!

The method inside the program:
Compress database logs
--1. Empty log
EXEC (' DUMP TRANSACTION [' + @dbname + '] with no_log ')
--2. Truncate the transaction log:
EXEC (' BACKUP LOG [' + @dbname + '] with no_log ')
--3. Shrink the database file (if not compressed, the database file will not be reduced
EXEC (' DBCC shrinkdatabase ([' + @dbname + ']) ')