May 2023
Intermediate to advanced
992 pages
31h 14m
English
book
SQL Server 2022 Administration Inside Out
by Randolph West, Melody Zacharias, William Assaf, Deepthi Goguri, Elizabeth Noble, Meagan Longoria, Joseph D'Antoni, Louis Davidson
Content preview from SQL Server 2022 Administration Inside Out
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 10
Develop, deploy, and manage data recovery
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 ...