Always On Archives - {coding}Sight

Configure SQL Server Always ON Availability Groups between Two Synchronous Replicas. Part 2

Manvendra Singh — Wed, 23 Jun 2021 09:55:11 +0000

We already covered some theory about configuring Always ON Availability Groups for Linux-based SQL Servers. The current article will focus on practice. We are going to present the step-by-step process of configuring the SQL Server Always ON Availability Groups between two synchronous replicas. Also, we’ll highlight the usage of the configuration-only replica to perform automatic …

The post Configure SQL Server Always ON Availability Groups between Two Synchronous Replicas. Part 2 appeared first on {coding}Sight.

Understanding Always ON Availability Group between Linux-Based SQL Server Instances. Part 1

Manvendra Singh — Tue, 22 Jun 2021 09:33:41 +0000

SQL Server Always ON Availability Group is a solution meant to achieve high availability and disaster recovery for SQL Server databases. We can configure this functionality between the Windows-based SQL Server installations, Linux-based SQL Server installations, and even between Linux and Windows-based SQL Server installations together. Availability Groups are tightly integrated with cluster technologies in …

The post Understanding Always ON Availability Group between Linux-Based SQL Server Instances. Part 1 appeared first on {coding}Sight.

Configuring AlwaysOn Availability Groups on SQL Server

Kenneth Igiri — Thu, 03 Sep 2020 07:13:52 +0000

INTRODUCTION This document describes the steps and additional information necessary to configure AlwaysOn Availability Groups for HA and DR on MS SQL Server. AlwaysOn Availability Groups is an HA-DR solution introduced in SQL Server 2012, designed like a Transaction Log Shipping and Database Mirroring combination. AlwaysOn AG implements HA at the database level, even though …

The post Configuring AlwaysOn Availability Groups on SQL Server appeared first on {coding}Sight.

Different Ways to Monitor SQL Server AlwaysOn Availability Groups

Nisarg Upadhyay — Fri, 21 Feb 2020 00:52:53 +0000

In my previous articles, I have explained the step-by-step process of deploying an AlwaysOn Availability group on SQL Server 2017. In this article, I am going to explain how to monitor AlwaysOn availability groups. First, let’s review the configuration of the availability group we had deployed previously. To do that, open SQL Server Management Studio …

The post Different Ways to Monitor SQL Server AlwaysOn Availability Groups appeared first on {coding}Sight.

SQL Server AlwaysOn Availability Groups: Installation and configuration, Part 2

Nisarg Upadhyay — Tue, 21 Jan 2020 08:00:48 +0000

In my previous article, I have explained the process of installing and creating a failover cluster and how to enable the AlwaysOn availability group. In this article, I am going to explain the step-by-step deployment process of SQL Server AlwaysOn Availability groups using wizards. The deployment configurations look the following way: We have installed SQL …

The post SQL Server AlwaysOn Availability Groups: Installation and configuration, Part 2 appeared first on {coding}Sight.

SQL Server AlwaysOn Availability Groups: Installation and Configuration. Part 2

Nisarg Upadhyay — Tue, 21 Jan 2020 08:00:48 +0000

The post SQL Server AlwaysOn Availability Groups: Installation and Configuration. Part 2 appeared first on {coding}Sight.

SQL Server AlwaysOn Availability Groups: Installation and configuration, Part 1

Nisarg Upadhyay — Sat, 18 Jan 2020 01:17:21 +0000

In this article, I will explain the process of installing pre-requisites to deploy the SQL Server AlwaysOn availability group. For the demonstration, I have prepared a demo set up at my work station. See the following components: Virtual Machine Host Name Purpose Domain Controller DC.Local The domain controller is installed on this machine Primary Replica …

The post SQL Server AlwaysOn Availability Groups: Installation and configuration, Part 1 appeared first on {coding}Sight.

SQL Always On Availability Groups: Computer Objects

Kenneth Igiri — Mon, 21 Oct 2019 23:37:06 +0000

SQL Server Always On Availability Groups is Microsoft’s latest technology for addressing the High Availability and Disaster Recovery needs of organizations that use SQL Server. One big advantage of AlwaysOn is the ability to address both HA and DR in one implementation. We experienced the following key benefits of AlwaysOn: We can group related databases …

The post SQL Always On Availability Groups: Computer Objects appeared first on {coding}Sight.

AlwaysOn Availability Groups: Quorum

Kenneth Igiri — Mon, 29 Jul 2019 22:51:53 +0000

SQL Server AlwaysOn Availability Groups is Microsoft’s latest technology for addressing the High Availability and Disaster Recovery needs of organizations using SQL Server. One big advantage of AlwaysOn is the ability to address both HA and DR in one implementation. The key benefits of AlwaysOn that we have experienced are as follows: We can group …

The post AlwaysOn Availability Groups: Quorum appeared first on {coding}Sight.