How to effectively delete Log files in SQL 2000 ? * Backup DB (just in case something goes wrong) * Enterprise manager >> DBName [Rightclick] >> Options >> Single User Mode (If it complains others are using the DB, open Query Analyzer and sp_who and kill those Process ids) * Enterprise manager >> DBName [Rightclick]… (1 comment)