SQL Server 2019 High Availability

by Tanveer A.

This Book introduces several SQL Server high-availability solutions that improve the availability of servers or databases. It will cover some of the best recommended techniques to ensure the high availability of customer database servers. It will show you how to address pain-points and how to build a failover cluster, to avoid even the slightest downtime. By the end, you will be equipped with all the tools and techniques to ensure your SQL server is always on. To many organizations, the availability of their applications is of the utmost importance. Without their applications, e.g. web shops, ERP, CRM applications, their business would grind to a halt, costing thousands or even millions of dollars. Most applications rely on databases for storing their data and many organizations use Microsoft’s SQL Server database. The learning outcomes for this Book SQL Server Installation for High Availability Setting up a Database Mirroring solution with Log Shipping. Designing a Windows Cluster with an Always On Availability Group. Designing a Windows Cluster with an Always On Failover Cluster. Designing and Implementing Backup and Recovery strategies. By the end of the course, you will be able to understand the different SQL Server high availability and disaster recovery technologies, how they work, and be able to properly implement the right solution to address recovery objectives and service level agreements. What you'll learn-and how you can apply it The meaning of high availability and disaster recovery Configuring a Log Shipping Solution Designing a Windows Cluster with an Always On Availability Group Designing a Windows Cluster with an Always On Failover Cluster Designing and implementing backup and recovery strategies

191 pages, Kindle Edition

Published October 27, 2020