I have not come accross these sort of excited recovery scenario, and learn a lot from the experience shared from the article and responses.

In the past, I also come across the DB log growing too large. I found that the fastest way to shrink the DB log is like that :

- Stop the DB

- Detach the DB with sp_detach_db

- Delete / Rename the LDF file

- Attach the DB with sp_attach_single_file_db with the MDF file left.

Can sp_attach_single_file_db to be used in the mentioned scenario ?