Apr 22, 2025 · Learn how to shrink the SQL Server transaction log for a SQL Server database either using SSMS or TSQL code.

May 19, 2025 · Learn how to shrink a data or log file in SQL Server by using SQL Server Management Studio or Transact-SQL.

Jul 25, 2025 · In this blog, we look at the reasons to reduce transaction Log file size and the best methods to shrink Log file in SQL server.

Dec 28, 2023 · This article describes how to shrink MS SQL Transaction Log file using SQL Server Management Studio. The log file shrinking can orrur when the database is online and …

Aug 26, 2025 · This article describes how to monitor SQL Server transaction log size, shrink the transaction log, add to or enlarge a transaction log file, optimize the tempdb transaction log …

Quickly: in full backup mode all transactions are retained in the log files until a backup of the log file is performed, then that space can be reused. This makes sense in many production …

Sep 29, 2025 · Typically it's the log file that appears not to shrink, usually the result of a log file that hasn't been truncated by a regular transaction log backup. To truncate the log, back up …

Jan 2, 2025 · In this article we walk through an example of how SQL Server database files grow and then the steps to take to shrink a database file.

May 19, 2025 · This example uses DBCC SHRINKDATABASE (Transact-SQL) to decrease the size of the data and log files in the UserDB database, and to allow for 10 percent free space in …

Learn when to Shrink SQL Server Log Files and the right way to do it for proper log file performance on SQL Server.