Category Archives for "Always On"

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
>