SQL Server 2017 Administration Inside Out, First Edition

Chapter 11Developing, deploying, and managing data recovery

The fundamentals of data recovery

Understanding backup devices

Understanding different types of backups

Creating and verifying backups

Defining a recovery strategy

The first and foremost responsibility of a data professional is to ensure that a database can be recovered in the event of a disaster.

NOTE

As discussed in Chapter 2, a disaster is any unplanned event caused by, but not limited to, natural disaster, hardware or software failure, or human error.

You don’t design a backup strategy. You design a restore strategy. You need to allow for potential downtime and loss of data, within acceptable limits. These are defined by the business requirements for getting an environment back ...