SQL Server Logging Essentials
Video References
These additional references will help you take what you've learned in this SQL Server Video to the next step.
Book References
Inside Microsoft SQL Server 2005: The Storage Engine
Relevance: Chapter 5 has great, in-depth, information on logging and recovery, and covers log-file growth, the check-point process, and information about virtual log files. See pages 92-93 for information about database and log files.
Inside Microsoft SQL Server 2000
Relevance: Chapter 5 (starting around page 175) provides some great information on database file sizes and growth - as well as information on shrinking files. Pages 182+ cover information about logging mechanics and truncation as well as the role of virtual log files.
Professional SQL Server 2000 Programming
Relevance: Pages 30-34 provide a high-level overview of databases and database files, while pages 461-466 go into greater depth on how logging works.
Links / References
SQL Server Books Online [link]
Relevance: For additional information about logging, check out relevant topics from Books Online:
SQL Server 2000
Transaction Recovery
Checkpoints and the Active Portion of the Log
Transactions Architecture
SQL Server 2005/2008
Introduction to Transaction Logs
Understanding and Managing Transaction Logs
Microsoft TechNet [link]
Relevance: Paul S. Randal has a great article outlining Logging and Recovery basics. Understanding Logging and Recovery in SQL Server.
SQLAdvice.com [link]
Relevance: Aaron Weiker has a great blog post on SQLAdvice.com: Transaction Log 101
