One can follow below mentioned steps and commands to truncate MS SQL database Logs:
1) Open Enterprise Manager.
2) Expand Local Computer.
3) Click on databases.
4) Click on the database for which one need to trunk the logs.
5) Click on tools -> SQL Query Analyzer from menu bar.
6) Type below mentioned commands:
- dbcc shrinkfile (Log file name, 'target size in MB')