Understanding Backup Options

Video References

These additional references will help you take what you've learned in this SQL Server Video to the next step.

Book References

Microsoft SQL Server 2005 Administrator's Pocket Consultant

Microsoft SQL Server 2005 Administrator's Pocket Consultant
Review

Relevance: All of Chapter 14 is great - and covers backups and options in depth. The book is primarily a reference manual, so it's treatment of concepts is light, but after watching this video you'll find that this chapter is an incredible resource.

Inside Microsoft SQL Server 2000

Inside Microsoft SQL Server 2000
Review

Relevance: All of chapter 5 is a great resource if you'd like to learn more about database files and backups in general, while pages 209-219 provide a great overview of some of the key concepts involved in backup and recovery.

Inside Microsoft SQL Server 2005: The Storage Engine

Inside Microsoft SQL Server 2005: The Storage Engine
Review

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 162-173 for more indepth treatment of backup and recovery operations.


Links / References


spacer