Root Cause for Increasing the Transaction Log.

Answer:

1.Uncommitted Transactions.
2.Extremely Large Transactions.
3.Operations : DBCC DBREINDEX / CREATE INDEX.
4.Client Applications do not process all results.
5.While Restoring from Transaction Log Backups.
6.Queries Time-Out before a transaction log completes the expansion and you receive false 'Log Full' error message.