Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Transaction Logs Rss

Search for any content tagged transaction logs

<< Newer    Items 21 to 40 of 50    Older >>
 

SQL Server Transaction Log Fragmentation: a Primer

Generally, you will have no need to worry about the number of virtual log files in your transaction log. However, if you use the default settings for 'auto-grow', you can end up with such 'fragmentation' in your transaction log as to affect performance noticably. How can this be avoided? How can you tell it's a problem? What do you do about it? Greg explains.  Read more...
By Additional Articles 2012/11/23 (first published: 2012/05/01) | Source: SimpleTalk | Category: t-log
Rating: (not yet rated)  Rate this |   Briefcase | 6,510 reads

Stairway to Transaction Log Management in SQL Server, Level 5: Managing the Log in Full Recovery Mode

In FULL recovery mode it is possible to do a point-in-time restore of a database. It is thankfully a rare event. Tony explains what's involved  Read more...
By Tony Davis 2012/01/27 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,291 reads

Managing Transaction Logs

A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.  Read more...
By Gail Shaw 2012/01/03 (first published: 2008/10/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 54,772 reads

Stairway to Transaction Log Management in SQL Server, Level 4: Managing the Log in Simple Recovery Mode

Tony describes in more detail the SIMPLE recovery model, and the way it works, its advantages and disadvantages.  Read more...
By Tony Davis 2011/11/18 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,296 reads

Using PowerShell for SQL Server Transaction Log Backups

How can I use PowerShell to do a Transaction Log backup for SQL Server databases? In this tip we look at an alternative way of creating transaction log backups using a PowerShell script.  Read more...
By Additional Articles 2011/10/25 | Source: MSSQLCity.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,260 reads

Stairway to Transaction Log Management in SQL Server, Level 3: Transaction Logs, Backup and Recovery

This article discusses the different types of backup and recovery models and gives the essential facts that will guide you to being able to achieve a recovery of a database to a point in time.  Read more...
By Tony Davis 2011/09/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,738 reads

Stairway to Transaction Log Management in SQL Server, Level 2: A Brief Overview of Transaction Log Architecture

In order to make it easier to understand truncation, space reuse and fragmentation in the log file, Tony gives a brief explanation of how the transaction log works.  Read more...
By Tony Davis 2011/08/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,644 reads

Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview

The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time.  Read more...
By Tony Davis 2013/10/30 (first published: 2011/06/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 19,696 reads

Avoiding Logging

It seems that some people think that you can perform actions in SQL Server without logging them in the transaction log. Steve Jones talks about this myth and says it's not even an option he'd like to have.  Read more...
By Steve Jones 2011/03/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 609 reads

Why is my transaction log full?

Why does the transaction log fill up? There are a variety of reasons, and MVP Gail Shaw walks you through the various things to check.  Read more...
By Gail Shaw 2012/08/31 (first published: 2011/02/21) | Source: SQLServerCentral.com | Category: transaction logs
Rating: |  Discuss |   Briefcase | 43,718 reads

DBA 101: Why is my log file full?

This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....  Read more...
By Grant Fritchey 2011/01/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,093 reads

Reading SQL Server's Transaction Log

This article shows how you can read the [RowLog Contents] in the Transaction Log, for Real!  Read more...
By Kraig Kerr 2012/11/09 (first published: 2010/11/22) | Source: SQLServerCentral.com | Category: transaction logs
Rating: |  Discuss |   Briefcase | 26,481 reads

Performance Issue with large number of Virtual Log Files in SQL Server Transaction Log

SQL Server transaction log files have an internal structure called the Virtual Log File or VLF. When the number of VLFs grow out of control due to autogrowth the log can become fragmented and cause delay. In this tip we look at how to see how many VLFs exist as well as how this can be reduced to a more reasonable number.   Read more...
By Additional Articles 2010/09/13 | Source: MSSQLTips.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 2,799 reads

Managing Transaction Logs

A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.  Read more...
By Gail Shaw 2012/01/03 (first published: 2008/10/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 54,772 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 logs
Rating: |  Discuss |   Briefcase | 32,242 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 | 14,098 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 logs
Rating:  Rate this |   Briefcase | 4,010 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 | 37,794 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 (dr)
Rating: |  Discuss |   Briefcase | 20,010 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 | 2,894 reads
<< Newer    Items 21 to 40 of 50    Older >>