SQL Server Transaction Log

The Curious Case of… a truncated log file after a revert from snapshot

Posted on: January 6, 2020 12:21 pm

The Curious Case of… why a minimally-logged operation doesn’t make a log backup smaller

Posted on: October 3, 2019 1:31 pm

The Curious Case of… too few log records for an offline index rebuild

Posted on: September 4, 2019 1:57 pm

The Curious Case of… why the transaction log has to be zero-initialized

Posted on: July 24, 2019 12:58 pm

The Curious Case of… faster disks causing more WRITELOG waits

Posted on: March 6, 2019 3:35 pm

Lazy log truncation or why VLFs might stay at status 2 after log clearing

Posted on: October 16, 2018 3:52 pm

New VLF status value

Posted on: September 20, 2018 2:27 am

SQLskills SQL101: Is the recovery interval guaranteed?

Posted on: March 21, 2018 4:48 pm

Bug: database/server ‘shutdown due to error 3314’

Posted on: December 5, 2017 11:31 am

SQLskills SQL101: Should you kill that long-running transaction?

Posted on: October 10, 2017 8:16 am

SQLskills SQL101: Switching recovery models

Posted on: March 29, 2017 12:44 am

Code to show rolled back transactions after a crash

Posted on: January 18, 2017 5:27 pm

Getting a history of database snapshot creation

Posted on: October 20, 2016 5:24 pm

Code to analyze the transaction hierarchy in the log

Posted on: May 1, 2016 9:45 am

T-SQL Tuesday #67 – monitoring log activity with Extended Events

Posted on: June 9, 2015 10:02 am

Finding a transaction in the log for a particular user

Posted on: June 3, 2015 11:45 am

REPLICATION preventing log reuse but no replication configured

Posted on: April 6, 2015 2:10 pm

Incomplete checkpoints and recovery

Posted on: March 18, 2015 12:13 pm

Important change to VLF creation algorithm in SQL Server 2014

Posted on: January 6, 2015 3:27 pm

Delayed Durability in SQL Server 2014

Posted on: November 20, 2014 11:13 am

When is fast recovery used?

Posted on: September 15, 2014 1:40 pm

What is the most worrying cause of log growth (log_reuse_wait_desc)?

Posted on: March 17, 2014 7:58 pm

More on using Transaction SID from the transaction log

Posted on: February 11, 2014 6:54 am

Are I/O latencies killing your performance?

Posted on: November 14, 2013 9:02 am

Why is log_reuse_wait_desc saying LOG_BACKUP after doing a log backup?

Posted on: November 13, 2013 12:33 pm

How to tell who changed a log file characteristic?

Posted on: September 18, 2013 2:10 pm

The Accidental DBA (Day 30 of 30): Troubleshooting: Transaction Log Growth

Posted on: June 30, 2013 8:00 am

Tracking page splits using the transaction log

Posted on: February 7, 2013 11:43 am

New 7.5 hour online course on logging, recovery, and the transaction log

Posted on: November 16, 2012 3:33 pm

Parent transaction ID in 2012 fn_dblog output

Posted on: October 4, 2012 9:15 pm

Multiple log files and why they’re bad

Posted on: September 24, 2012 3:48 pm

Survey: transaction log files per database (code to run)

Posted on: August 29, 2012 12:11 pm

Using fn_dblog, fn_dump_dblog, and restoring with STOPBEFOREMARK to an LSN

Posted on: May 17, 2012 3:05 am

Understanding data vs log usage for spills in tempdb

Posted on: May 11, 2012 2:08 am

TechNet Magazine: September 2011 SQL Q&A column

Posted on: September 14, 2011 5:43 am

Initial VLF sequence numbers and default log file size

Posted on: September 13, 2011 11:52 am

TechNet Magazine: July 2011 SQL Q&A column

Posted on: July 21, 2011 3:11 pm

TechNet Magazine: January 2011 SQL Q&A column

Posted on: January 19, 2011 9:27 am

Log file configuration metrics for 17000 databases

Posted on: July 4, 2010 5:20 am

Disaster recovery 101: backing up the tail of the log

Posted on: June 18, 2010 9:21 am

Bug: log file growth broken for multiples of 4GB

Posted on: May 15, 2010 7:23 pm

A SQL Server DBA myth a day: (30/30) backup myths

Posted on: April 30, 2010 9:19 am

A SQL Server DBA myth a day: (28/30) BULK_LOGGED recovery model

Posted on: April 28, 2010 2:28 am

A SQL Server DBA myth a day: (26/30) nested transactions are real

Posted on: April 26, 2010 11:03 am

Survey: how are your transaction logs configured?

Posted on: April 23, 2010 1:54 pm

A SQL Server DBA myth a day: (19/30) TRUNCATE TABLE is non-logged

Posted on: April 19, 2010 11:57 am

A SQL Server DBA myth a day: (14/30) clearing the log zeroes out log records

Posted on: April 14, 2010 6:07 am

Script: open transactions with text and plans

Posted on: February 1, 2010 4:37 pm

Benchmarking: 1-TB table population (part 2: optimizing log block IO size and how log IO works)

Posted on: January 27, 2010 11:23 am

Interesting case of watching log file growth during a perf test

Posted on: January 18, 2010 11:56 am

What can cause log reads and other transaction log questions

Posted on: December 9, 2009 4:14 pm

Lock logging and fast recovery

Posted on: November 13, 2009 1:24 pm

New script: is that database REALLY in the FULL recovery mode?

Posted on: October 7, 2009 1:27 pm

What does checkpoint do for tempdb?

Posted on: October 7, 2009 11:49 am

How do checkpoints work and what gets logged

Posted on: September 27, 2009 9:28 pm

TechNet Magazine: August 2009 SQL Q&A column

Posted on: July 17, 2009 1:57 pm

Finding out who dropped a table using the transaction log

Posted on: June 16, 2009 6:27 pm

Misconceptions around the log and log backups: how to convince yourself

Posted on: May 29, 2009 11:09 am

New script: how much data will the next log backup include?

Posted on: May 24, 2009 2:32 pm

A sad tale of mis-steps and corruption (from today)

Posted on: May 12, 2009 8:36 pm

How expensive are page splits in terms of transaction log?

Posted on: May 12, 2009 5:50 pm

Why could restoring a log-shipping log backup be slow?

Posted on: April 21, 2009 5:48 pm

Inside the Storage Engine: More on the circular nature of the log

Posted on: April 21, 2009 12:42 am

Importance of proper transaction log size management

Posted on: April 10, 2009 12:21 pm

Weekly survey: transaction log size management

Posted on: April 3, 2009 9:59 am

Ghost cleanup redux

Posted on: March 19, 2009 10:44 am

How can a log backup fail but a full backup succeed?

Posted on: March 7, 2009 8:57 am

Performance impact of lots of VLFs in the transaction log

Posted on: February 9, 2009 6:18 pm

TechNet Magazine: February 2009 SQL Q&A column

Posted on: January 16, 2009 10:15 am

TechNet Magazine: feature article on understanding logging and recovery

Posted on: January 16, 2009 10:01 am

Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup

Posted on: November 26, 2008 5:43 am

Conference Questions Pot-Pourri #9: Q&A around compression features

Posted on: November 11, 2008 9:29 am

New minimally-logged insert functionality in SQL Server 2008

Posted on: October 28, 2008 1:26 am

TechNet Magazine: October SQL Q&A column

Posted on: September 23, 2008 1:07 am

Should Microsoft provide a transaction log reader tool?

Posted on: August 26, 2008 12:21 am

Search Engine Q&A #25: Why isn’t my log backup the same size as my log?

Posted on: August 25, 2008 12:23 am

Search Engine Q&A #24: Why can’t the transaction log use instant initialization?

Posted on: August 20, 2008 7:47 pm

Search Engine Q&A #23: My transaction log is full – now what?

Posted on: August 14, 2008 3:05 pm

Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)

Posted on: June 8, 2008 5:12 pm

More on how much transaction log a full backup includes

Posted on: January 31, 2008 8:01 am

Conference Questions Pot-Pourri #3: unexpected index rebuild results and bulk-logged operations

Posted on: November 6, 2007 11:17 pm

Why won’t my log clear in SIMPLE recovery mode? SQL 2000 bug or very large VLFs

Posted on: November 5, 2007 2:59 pm

Debunking a couple of myths around full database backups

Posted on: October 25, 2007 9:42 pm

More on Database Mirroring performance and index maintenance

Posted on: October 19, 2007 12:37 am

BACKUP LOG WITH NO_LOG – use, abuse, and undocumented trace flags to stop it

Posted on: October 12, 2007 5:09 pm

SQL Server 2008: Performance boost for Database Mirroring

Posted on: October 11, 2007 12:06 am

Inside the Storage Engine: Ghost cleanup in depth

Posted on: October 8, 2007 4:24 pm

Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup

Posted on: October 6, 2007 1:00 am

EMERGENCY-mode repair: the very, very last resort

Posted on: October 2, 2007 11:26 pm

Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database

Posted on: October 2, 2007 5:20 pm

Search Engine Q&A #1: Running out of transaction log space

Posted on: September 24, 2007 12:35 am

Corruption: Last resorts that people try first…

Posted on: September 15, 2007 12:29 am

In Recovery...