Microsoft SQL Server Transaction Log Internals

Download this episode

Download Video

Description

The transaction log plays the most critical role in any SQL Server database. In this session we discuss the importance of the transaction log and the roles it plays inside the database engine. We look at how logging and recovery works, the checkpoint process, write-ahead logging, and steps you need to take as a DBA to ensure proper management of the transaction log for a SQL Server database.

For more information, check out this course on Microsoft Virtual Academy:

Day:

3

Session Type:

Breakout

Code:

DBI-B309

Room:

Room 353

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.