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 !
Recent Comments