SQL Server 2022 Administration Inside Out

Chapter 10

Develop, deploy, and manage data recovery

• Prepare for data recovery

• Ransomware attacks

• Understand different types of backups

• Understand backup devices

• Create and verify backups

• Restore a database

• Define a recovery strategy

The first and foremost responsibility of a production DBA is to ensure that a database can be recovered in the event of a disaster. This chapter outlines the fundamentals of data recovery and SQL Server recovery models. Then, it covers backup devices in SQL Server before discussing the different types of backups. Next, it shows you how to create and verify database backups, and how to restore databases from those backups. This chapter ends with a discussion of defining a recovery strategy based on a fictitious ...