Chapter 3: Implementing Backup and Recovery

One of the many responsibilities of an administrator is to keep data backed up in case of any data failure. SQL Server helps administrators fulfill this responsibility via sophisticated backup and restore features. In this chapter, we will learn in detail what you need when choosing an appropriate database disaster recovery strategy in conjunction with the database's usage and configuration, as well as how to use stored backups to restore a database in case of failure.

We will cover the following topics in this chapter:

• Data structures and transaction logging
• SQL Server recovery models
• Designing a backup strategy
• Using database and log restore

Let's get started!