Availability Groups Archives - {coding}Sight https://codingsight.com/category/database-administration/availability-groups/ Blog for SQL Server DBAs and Developers Fri, 07 Oct 2022 07:59:47 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Availability Groups Archives - {coding}Sight https://codingsight.com/category/database-administration/availability-groups/ 32 32 Configure SQL Server Always ON Availability Groups between Two Synchronous Replicas. Part 2 https://codingsight.com/configure-two-node-synchronous-replicas-on-pacemaker-cluster/ Wed, 23 Jun 2021 09:55:11 +0000 http://codingsight.com/?p=14837 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 https://codingsight.com/understanding-always-on-availability-group-between-linux-based-sql-server-instances-part-1/ Tue, 22 Jun 2021 09:33:41 +0000 http://codingsight.com/?p=14801 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.

]]> Transparent Data Encryption (TDE) in SQL Server in an AlwaysOn Availability Group on Example https://codingsight.com/enable-tde-of-databases-in-alwayson-availability-group-scenario/ Fri, 23 Apr 2021 12:24:21 +0000 http://codingsight.com/?p=12974 Availability Groups are fantastic for High Availability/Disaster Recovery solutions, and I’m sure that fellow DBAs will agree with me. However, there will be times when we must consider certain precautions and extra steps carefully to avoid unwanted surprises. For instance, any Secondary Replica becomes the current Primary Replica for whatever reason, and our goal is …

The post Transparent Data Encryption (TDE) in SQL Server in an AlwaysOn Availability Group on Example appeared first on {coding}Sight.

]]> Deploy SQL Server AlwaysOn Availability Groups on Linux https://codingsight.com/deploy-sql-server-alwayson-availability-groups-on-linux/ Fri, 11 Dec 2020 16:13:36 +0000 https://codingsight.com/?p=11020 In the previous article, I explained how we could install Ubuntu 18.04 and SQL Server 2019 on the virtual machines. Now, before we proceed further, let’s go through the configuration. We created three virtual machines, and the details are the following: Host Name IP Address Role LinuxSQL01 192.168.0.140 Primary Replica LinuxSQL02 192.168.0.141 Synchronous Secondary Replica …

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

]]> Сreating a Virtual Machine With Oracle VM Virtual Box https://codingsight.com/creating-virtual-machine-with-oracle-vm-virtual-box/ Wed, 25 Nov 2020 13:08:33 +0000 https://codingsight.com/?p=10658 Microsoft announced cross-platform support of SQL Server – the SQL Server 2017 and SQL Server 2019 work on Microsoft Windows and Linux. We can install SQL Server 2017 and higher on Red Hat Enterprise Linux, Ubuntu, and SUSE Enterprise Server. We can also set up high availability and disaster recovery mechanism for SQL Server on …

The post Сreating a Virtual Machine With Oracle VM Virtual Box appeared first on {coding}Sight.

]]> Configuring AlwaysOn Availability Groups on SQL Server https://codingsight.com/configuring-alwayson-availability-groups-on-sql-server/ Thu, 03 Sep 2020 07:13:52 +0000 https://codingsight.com/?p=9861 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 https://codingsight.com/different-ways-to-monitor-sql-server-alwayson-availability-groups/ Fri, 21 Feb 2020 00:52:53 +0000 https://codingsight.com/?p=8462 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 https://codingsight.com/sql-server-alwayson-availability-groups-installation-and-configuration-part-2/ Tue, 21 Jan 2020 08:00:48 +0000 https://codingsight.com/?p=8247 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 https://codingsight.com/sql-server-alwayson-availability-groups-installation-and-configuration-part-2-2/ Tue, 21 Jan 2020 08:00:48 +0000 https://codingsight.com/?p=8247 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 1 https://codingsight.com/sql-server-alwayson-availability-groups-installation-and-configuration-part-1/ https://codingsight.com/sql-server-alwayson-availability-groups-installation-and-configuration-part-1/#comments Sat, 18 Jan 2020 01:17:21 +0000 https://codingsight.com/?p=8429 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.

]]> https://codingsight.com/sql-server-alwayson-availability-groups-installation-and-configuration-part-1/feed/ 1