Название: SQL Server 2019 High Availability
Автор: Tanveer A.
Издательство: Amazon.com Services LLC
Год: 2020
Страниц: 174
Язык: английский
Формат: pdf, epub
Размер: 31.0 MB

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 include:

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