The Transaction Log provides the means by which either the complete set of tasks of a database transaction are performed or none of them are. It ensures that , via rollback, only valid data is written out to the database, and it allows transactions to be played back to recreate the system state right before a failure. Robert Sheldon explains the various basic tasks involved in managing the transaction log.  Read more...

The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it.  Read more...

This script is basically used in SQL Server 2005/2008 as that version not having the option to perform the same activity in the single window.  Read more...

James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)  Read more...

I am planning on moving the SQL Server log file of my production database on this drive. I am curious about how it will optimize the performance. What are some of the considerations I should take into account and how can I move the SQL Server database log file to a separate physical location?  Read more...

Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.  Read more...

One of the common questions often asked online is how to respond to a full transaction log. New author Krishna Potlakayala brings us a few techniques for dealing with this.  Read more...

can undermine server performance. An expert runs various tests to determine how transaction log file size responds to various T-SQL commands.  Read more...

One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it.  Read more...

Read more...

This article shows how a database can be restored to achieve point in time recovery  Read more...

Over the years, I have assisted so many different clients whose transactional log file has become "too large" that I thought it would be helpful to write about it. The issue can be a system crippling problem, but can be easily avoided. Today I'll look at what causes your transaction logs to grow too large, and what you can do to curb the problem.  Read more...

Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.   Read more...

James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)  Read more...

The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it.  Read more...

James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)  Read more...

One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it.  Read more...

The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it.  Read more...