Posted under tips on November 02 , 2019 by Nidhisha Shetty
Databases are usually in Full Recovery mode. This means that every transaction is retained in the transaction logs allowing a point in time recovery.
The implication of this is that unless the transaction log is truncated, no space gets freed up on deleting rows from any tables. Delete operations only shift data from the table to the logs.
Following are the steps to reduce the size of transaction log in SQL Server Management Studio:
Fig 1: Options to reduce transaction log file size