Chapter 12Implementing high availability and disaster recovery

No server is (intended to be) an island. Application downtime is costly. Loss of data can be fatal to an organization. In this chapter, we detail the Microsoft SQL Server technologies designed to provide high availability and disaster recovery, adding to the discussion of backups in Chapter 11. What’s beyond taking backups?

First, we take an overview of the available technologies, including log shipping, replication, failover clustering, and availability ...

Get SQL Server 2017 Administration Inside Out, First 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.