Announcement

Collapse
No announcement yet.

How to truncate MS SQL database Logs

Collapse

Ads on showthread pages

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to truncate MS SQL database Logs

    WordPress Hosting on SSD Servers
    Hello All,

    One can follow below mentioned steps and commands to truncate MS SQL database Logs:

    1) Open Enterprise Manager.
    2) Expand Local Computer.
    3) Click on databases.
    4) Click on the database for which one need to trunk the logs.
    5) Click on tools -> SQL Query Analyzer from menu bar.
    6) Type below mentioned commands:
    • dbcc shrinkfile (Log file name, 'target size in MB')
    Press Run OR F5 to execute the above mentioned command. Once the command is executed the logs file will be truncated.

    Thanks,

    Shane G.
    AccuWebHosting.Com
Working...
X
Sign up for a News Letter Click here to sign up