Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Content with tag
Transaction Log
Items 1 to 20 of 33
Next 20 >>
Stairway to Transaction Log Management in SQL Server
When things are going well, there is no need to be particularly conscious of what the Transaction log does or how it works. You just need to be confident that every database has the correct backup regime in place. When things go wrong, an understanding of the transaction log is important for taking corrective action, pasrticularly when a point-in-time restore of a database is required, urgently! Tony Davis give just the right level of detail that every DBA should know.
Read more...
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
|
5,128 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
|
41,479 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
|
4,215 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
|
4,959 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
|
7,510 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
2011/06/17
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
8,615 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
|
565 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
2011/02/21
|
Source:
SQLServerCentral.com
|
Category:
transaction log
Rating:
|
Discuss
|
Briefcase
|
23,297 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
|
2,538 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
2010/11/22
|
Source:
SQLServerCentral.com
|
Category:
transaction log
Rating:
|
Discuss
|
Briefcase
|
15,109 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
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,127 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
|
41,479 reads
Clearing the Transaction Log
Read more...
By
Paul Randal
2010/06/01
|
Category:
transaction log
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,597 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
|
31,932 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
|
12,519 reads
Shrinking the transaction log
Read more...
By
VM-723206
2009/12/10
|
Category:
transaction log
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,814 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,782 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
|
36,277 reads
Backup Both Full and TLog Database Backup within a single Job
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...
By
Nitin Gupta
2009/08/11
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
1,408 reads
Items 1 to 20 of 33
Next 20 >>
Tags
administration
(7)
backup / restore
(6)
stairway series
(6)
disaster recovery (dr)
(2)
blogs
(1)
dbcc shrinkfile
(1)
design and theory
(1)
editorial
(1)
log growth
(1)
management
(1)
performance
(1)
point-in-time
(1)
shrink database
(1)
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.