• (i) Displaying Log_reuse_wait_desc as Log_Backup for a db in SIMPLE contradicts.

    (ii) Is there any active transaction pending on this db?

    (iii) Change the Recovery to Full.... and then again to SIMPLE then try.

    (vi) Have you tried to create a new db in SIMPLE and do the same exercise?