One can follow below mentioned steps and commands to truncate MS SQL database:
1) Open Enterprise Manager.
2) Expand Local Computer.
3) Click on databases.
4) Click on the database which one need to shrink it.
5) Click on tools -> SQL Query Analyzer from menu bar.
6) Type below mentioned commands:
- dbcc shrinkdatabase (database name, 'target percent')