 How to shrink MS SQL database
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.Thanks,Shane G.AccuWebHosting.Com
To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.
| 
Linear Mode
