What is the reason behind of transaction log file reach out of control in size ? Transaction log backups are not occurring while in Simple recovery mode Very long transactions are occurring, like indexes of table or many updates Demo to control the size of transaction log by doing log backups