Tweet
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:
Press Run OR F5 to execute the above mentioned command. Once the command is executed…database will be truncated.
Thanks,
Shane G.
AccuWebHosting.Com
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
