How to – Purge / Clear SQL Log

To delete a sql database log file you can do the following:

1. de attach the original database
2. delete or rename log file manullay
3. attach again (.mdf file),log file wil create automatically

Before doing the above stop the services that use the database as well.  You can start them up again after you attach.

Leave a Reply