shohelr2003 (11/27/2012)
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.
All inactive VLF's in the transaction log will be truncated upon Checkpoint. Causing the transaction log to stay at a minimum size.
Note: Long running transactions can still fill up your log and and ause it to grow