SQL Server Performance

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

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jul 28, 2010.

  1. Anonymous New Member

    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">

Share This Page