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.


Shane G.