How to Clear SQL Server Log with DBCC Shrinkfile Command?

DBCC SHRINKFILE tries to shrink each physical log file to its target size immediately. However, if part of the logical log resides in the virtual logs beyond the target size, the Database Engine frees as much space as possible, and then issues an informat

DBCC SHRINKFILE 是 SQL Server 提供的一条命令，用于收缩指定数据库文件的大小，包括数据文件和日志文件。 使用此命令可以有效地释放未使用的空间，从而减少日志文件的物理大小。

Learn how to shrink the SQL Server transaction log for a SQL Server database either using SSMS or TSQL code.

若要允许 DBCC SHRINKFILE 命令收缩文件，首先需要通过将数据库恢复模式设置为 SIMPLE 来截断该文件。 -- Truncate the log by changing the database recovery model to SIMPLE. -- Shrink the truncated log file to 1 MB. -- Reset the database recovery model. 注意：从设置数据库到简单恢复，缩小文件，再设置完全恢复，实际上有部分日志数据是丢失的，

本文讲述了在磁盘空间不足时，如何通过数据库管理操作来收缩名为_log的日志文件，包括设置简单恢复模式，使用DBCCSHRINKFILE命令以及可能的TRUNCATEONLY选项，最后切换回完整恢复模式的过程。

You can shrink a transaction log file while the system is in use (DML commands are also being executed), however this will only affect the inactive portion of the transaction log file.

A simple guide to know how to Clear SQL Server Transaction Log with DBCC SHRINKFILE and Truncate_only command or by using Management Studio