Philip Ng Malaysia's Blog

How to purge the database log file ...

let say you want to pur the Northwind database log

1) Start Query Analyser run the following statement

backup log Northwind with truncate_only
checkpoint


2) Right click the Northwind database => All Task => Shrink Database

Click File button and then choose the Log File from the Database Files list.

Lastly click the OK button two times.


FYI:
Note: Please remember to schedule to run the above step 1) and step 2) once a week . Else the log file will grow until it is too big and it will slow down database access time.