In case there are multiple ldf file in the same drive that you do not want to keep, you can empty the ldf file and remove it. But after remove you will get this error.

Msg 5009, Level 16, State 9, Line 1 One or more files listed in the statement could not be found or could not be initialized. Input string was not in a correct format

Detach the database¬†with following parameter:@keepfulltextindexfile=N’false’¬†and reattached it.


USE [master]
 EXEC master.dbo.sp_detach_db @dbname = N'DatabaseName', @keepfulltextindexfile=N'false'