SQL 2008 R2 Shrink Log Files in Management Studio

Date July 28, 2016 Author By kadmin Category SQL Server 2005

Set Logging To Simple

If you want to prevent further growing you need to set your database logging to simple (but only if you do Full Backups of your database!).

1. Right click on your database
2. Choose Properties
3. Choose Options
4. Set Recovery mode to simple

Shrink The Database

1. Open up Sql Management Studio
2. Right click the database, Tasks > Shrink > Files.
3. Under File Type, choose the the log file. Be sure to mark option Release unused space as the shrink action, click OK.