Announcement

Collapse
No announcement yet.

How to shrink MS SQL database

Collapse

Ads on showthread pages

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to shrink MS SQL database

    WordPress Hosting on SSD Servers
    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
Working...
X
Sign up for a News Letter Click here to sign up