SQL Server Backups Demystified
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.
Microsoft SQL Server 2005 Administrator's Pocket Consultant
Relevance: Chapter 7 provides some background information on core database administration (including log file management concepts), while chapter 14 gets into the specifics of backing up SQL Server 2005 databases.
Links / References
SQL Server Books Online [link]
Relevance: Check out the following links for SQL Server Documentation on Backups and Recovery:
SQL Server 2000
Database Backups
Transaction Log Backups
SQL Server 2005/2008
Overview of Restore and Recovery in SQL Server
Backing Up and Restoring Databases in SQL Server
Working with Transaction Log Backups
SQLMag.com [link]
Relevance: Pinalkumar Dave has a great introductory article in the February 2008 issue. (Hey, great article title!)
