SQL 2008 R2 Reducir LOG files Managment Studio

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.