Open the SQL Server Management Studio.
- Expand the Databases node and expand User Databases
- Right-click the database, and click Properties, which opens the Database Properties dialog box.
- In the Select a page pane, click Options.
- View the current recovery model in the Recovery model list box, which should be set to Full
- Click the dropdown arrow in the recovery model section and select the Simple recovery model
- Click OK.
- Right-click on the same database name and click Task-> Shrink-> Files
- Use the File type drop-down menu and choose Log
- You can use the default setting of Release Unused Space or select Reorganize pages before releasing unused space, and you can specify the file size by supplying a value in the Shrink file to option.
Note: the shrink may take some time depending on how large the file is and how much it has to shrink.
- After the shrink completes, change the recovery model back to Full by clicking the recovery model dropdown arrow and selecting the Full recovery model
After completing these steps your transaction log should be at a normal size and if you implement the steps discussed in my Avoiding Ginormous Transaction Log files blog article you shouldn’t have to repeat the steps in this blog again.
Source : http://microtechpoint.com/index.php?route=blog/article&article_id=10