Hello All,

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')

Press Run OR F5 to execute the above mentioned command. Once the command is executed…database will be truncated.


Shane G.