SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Transaction Log Rss

Search for any content tagged transaction log

   Items 1 to 15 of 15   
 

Transaction Log Growth, do you need it?

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...
By James Rea 2010/05/28 (first published: 2009/01/05) | Source: SQLServerCentral.com | Category: transaction log
Rating: |  Discuss |  Briefcase | 16,509 reads

Log Growing Pains

Understanding the transaction log seems to be a very difficult concept fro mos DBAs to grasp. Jason Brimhall brings us a new article that helps to troubleshoot the cause of log growths.  Read more...
By Jason Brimhall 2010/03/11 | Source: SQLServerCentral.com | Category: log growth
Rating: |  Discuss |  Briefcase | 9,190 reads

Managing Transaction Logs in SQL Server

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...
By Additional Articles 2009/11/23 | Source: SimpleTalk | Category: transaction log
Rating:  Rate this |  Briefcase | 3,494 reads

Introduction to the Transaction Log

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...
By James Rea 2009/11/06 (first published: 2008/07/02) | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |  Briefcase | 31,338 reads

A Story of the Deleted Transaction Log

James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)  Read more...
By James DiMauro 2009/08/07 (first published: 2008/07/14) | Source: SQLServerCentral.com | Category: disaster recovery
Rating: |  Discuss |  Briefcase | 19,341 reads

Move SQL Server transaction log files to a different location via T-SQL and SSMS

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...
By Additional Articles 2009/07/02 | Source: MSSQLTips.com | Category: administration
Rating: (not yet rated)  Rate this |  Briefcase | 1,871 reads

Determining the source of full transaction logs

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...
By Additional Articles 2009/06/15 | Source: SearchSQLServer | Category: transaction log
Rating:  Rate this |  Briefcase | 3,135 reads

Full Transaction log

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...
By Krishna 2009/03/18 | Source: SQLServerCentral.com | Category: transaction log
Rating: |  Discuss |  Briefcase | 11,121 reads

Can you shrink your transaction log files to death?

can undermine server performance. An expert runs various tests to determine how transaction log file size responds to various T-SQL commands.  Read more...
By Additional Articles 2009/02/23 | Source: SearchSQLServer | Category: transaction log
Rating: (not yet rated)  Rate this |  Briefcase | 2,688 reads

Transaction Log Growth, do you need it?

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...
By James Rea 2010/05/28 (first published: 2009/01/05) | Source: SQLServerCentral.com | Category: transaction log
Rating: |  Discuss |  Briefcase | 16,509 reads

Restore Transaction Logs for Point in Time Recovery

This article shows how a database can be restored to achieve point in time recovery  Read more...
By Additional Articles 2008/11/12 | Source: SQL Server Performance | Category: backup / restore
Rating:  Rate this |  Briefcase | 2,147 reads

Help! My SQL Server Log File is too big!

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...
By Additional Articles 2008/10/28 | Source: Builder.com | Category: transaction log
Rating:  Rate this |  Briefcase | 6,219 reads

SQL Server Sanity: Maintain Healthy Transaction Logs for Easy Data Recovery

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...
By Additional Articles 2008/10/20 | Source: DevX | Category: transaction log
Rating:  Rate this |  Briefcase | 2,317 reads

A Story of the Deleted Transaction Log

James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)  Read more...
By James DiMauro 2009/08/07 (first published: 2008/07/14) | Source: SQLServerCentral.com | Category: disaster recovery
Rating: |  Discuss |  Briefcase | 19,341 reads

Introduction to the Transaction Log

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...
By James Rea 2009/11/06 (first published: 2008/07/02) | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |  Briefcase | 31,338 reads
   Items 1 to 15 of 15