• Actually transaction log file keeps on growing, so my database file also grows which consumes more disk spaces. To make database size smaller, I shrink log file that serves my purpose.

    If I set recovery model SIMPLE then how would I be benefited?

    Please clarify me these things.