Initially Recovery model was bulk. And it lead to grow the database file up to 100 GB. I have changed it to Simple mode and deattch\attach database to delete log file.

Do you need to be able to perform point in time restores?:- NO

Do you do transaction log backups?:- NO

We take backup on daily basics.