O'Reilly logo

Pro SQL Server Internals, Second Edition by Dmitri Korotkevitch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_30

30. Transaction Log Internals

Dmitri Korotkevitch

(1)Tampa, Florida, USA

As you already know, every database in SQL Server has one or more transaction log files in addition to data files. The transaction log stores information about all of the changes made in the database, and it allows SQL Server to recover databases to transactionally consistent states in case of an unexpected shutdown or crash.

In this chapter, we will examine the internal structure of the transaction log, discuss how SQL Server logs data modifications, and review how it performs database crash recovery. We will also cover how to diagnose excessive transaction log growth and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required