Tag Archives for " AlwaysOn "

Oct 28

Steps for Installing AlwaysOn Availability Groups – SQL 2019

By Ginger Daniel | Always On , Installation , SQL Administration , SQL Server

With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made.  This article is an update to our previous article https://www.sqlrx.com/steps-for-installing-sql-server-alwayson-availability-groups/ , and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Add Windows Failover Cluster (WSFC) Install […]

Continue reading
Aug 09

AlwaysOn – Create a Basic Availability Group

By Ginger Daniel | Always On , SQL 2016 , SQL 2017 , SQL Administration , SQL Server

AlwaysOn Basic Availability Groups (BAGs) are available with SQL Server 2016 and 2017 Standard edition.  The functionality is generally the same as database mirroring (which has been deprecated).  This feature replicates transactions to a database on a secondary server, and is useful for disaster recovery should something happen to the primary server. If you have […]

Continue reading
May 25

AlwaysOn 2016 – Encrypted Databases in an AG

By Ginger Daniel | Encryption , SQL 2016 , SQL Administration , SQL Server

In the AlwaysOn 2016 release, there are several enhancements that have improved manageability, scalability, and availability. One of the enhancements is the ability to add encrypted databases to an AlwaysOn group. Encrypted databases were allowed in earlier versions of AlwaysOn, however they could not be accessed if there was a failover to a secondary replica […]

Continue reading
>