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!
Data structures and transaction logging ...
Get SQL Server 2019 Administrator's Guide - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
