Home / Software / Tips and Tricks / How do you shrink the SQL Server transaction log?

How do you shrink the SQL Server transaction log?

Updated:  10/15/2013 08:10 AM
Author:  Shiju Mathews

Status:    Resolved.


Note: It is recommended to create a full back up of the database that is going to shrink

Assume that you have installed AdventureWorks2008R2 in your database.



You can shrink the database using SSMS

Right click on the database name.
Select Tasks -> Shrink -> Database
Then click OK!
Usually open the Windows Explorer directory containing the database files so I can immediately see the effect.


Also you can do this by TSQL