- Right-click the database, choose properties, then options.
- Make sure “Recovery model” is set to “Simple”, not “Full”
- Click Ok
- Right-click the database again, choose tasks -> shrink files
- Change file type to “log”
- Click ok.
Alternatively, the SQL to do it:
ALTER DATABASE mydatabase SET RECOVERY SIMPLE DBCC SHRINKFILE (mydatabase_Log, 1)