SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

This was the question asked by a developer, due to a particular process fills up the transaction log so quickly. I had to explain the reason and tricks that can reduce the transaction log bulge using best recovery methods on the database. Going back to basics there certain FAQ about Transaction log usage within SQL Server. Transaction Log - why it is required? A log is a seperate file that stores all kinds of information about the SQL Server instance and databases. Each database has its own log file...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2010/07/29/what-is-transaction-log-file-can-i-delete-it.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9304" width="1" height="1">