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.
Thanks,
Shane G.
AccuWebHosting.Com
