17 High availability and disaster recovery
High availability and disaster recovery (HADR) are complicated and important topics when we’re talking about our databases. One of the core responsibilities of a production DBA is ensuring that databases are available so applications and business users can access them. SQL Server has several options we can implement to improve the resiliency and availability of our data, including the following:
-
Log shipping
-
Windows Server Failover Clusters
-
Availability groups
Throughout this chapter, we’ll demonstrate how dbatools can help simplify working with each of these HADR solutions, making them easier to configure and monitor. First, let’s talk about log shipping.
17.1 Log shipping
Log shipping is the ...
Get Learn dbatools in a Month of Lunches 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.
