Summary

3 4

In this chapter, you've learned how SQL Server logging works and how to use checkpoints to reduce the amount of time needed to recover a database. You've also learned the fundamentals of performing SQL Server backups and the differences between full and differential backups and between database and transaction log backups. And you've learned how to schedule backups and improve your backups. Chapter 33 continues our examination of backing up, restoring, and recovering the database. In that chapter, you'll learn how to restore the database and how to plan for disaster recovery.