WAL: The concept that makes recovery models & backups make sense (Dear SQL DBA Episode 32)
When you’re a Junior DBA, it’s really hard to take in all the information out there. Learn about write ahead logging: the concept that can help you make sense of recovery models and backup strategies in SQL Server. This is a foundational concept that can help you understand how SQL Server works, and how to take care of a SQL Server instance.
In this week’s episode, I tell the story of the “Wow!” moment when I learned about write ahead logging from Kimberly Tripp of SQLSkills.com way back when I was a Junior DBA. I give my own take on how write ahead logging works in SQL Server.
Predictably, my version has goofy drawings.
Note: I do some storytelling at the beginning of this episode. The tech content starts 8 minutes in if you’d like to skip straight to that part.
Junior DBA Training Plan: https://www.littlekendra.com/2016/03/29/training-plan-for-junior-dbas-learning-sql-server/
Learn about the Write Ahead Transaction Log on TechNet: https://technet.microsoft.com/en-us/library/ms186259.aspx