Recently I was asked to find out way to reduce the log file of SQL , after few search over google (Thanks to google !), finally we got the way to completely delete the log file , here is the step we did carry out to delete log file completely.

Step 1 : Detach the database

Step 2 : Goto log file and rename the log file (say xyz_log.ldf to xyz_log1.ldf )

Step 3 : Attach the database back !

Step 4 : verify the database and If everything is good , you are good to delete log file !

Happy Coding !