Categories

How to Shrink Your MS SQL Database Log File

Transaction Log is a weak place in SQL server for HDD, especially if it’s a test area and you don’t make every day back up of your databases. While creating back up transaction logs are shrinking.

To shrink transaction logs in Microsoft SQL Database is a task you have to execute from time to time. To truncate transaction log you should have Microsoft SQL Server Management Studio according to your version of SQL server.