STEPS TO DELETE LOG FILE OF A DATABASE...

LOG FILE OF A DATABASE... 

 

• Backup the database
• Detach the database, either by using Enterprise Manager or by executing : *Sp_DetachDB [DBName]*
• Delete the transaction log file. (or rename the file, just in case)
• Re-attach the database again using: *Sp_AttachDB [DBName]*
• When the database is attached, a new transaction log file is created.

SOURCE: SADOP