SQL Server Always On Install - SQL-FineBuild/Common GitHub Wiki

Previous SQL Server Cluster Install SQL FineBuild Always On Overview Next

FineBuild supports installing SQL Server 2012 and above using Always On Availability Groups, including many common pre-installation and post-installation tasks.

The SQL FineBuild Always On Install process is based on the Main Instance Server Build but with additional parameters to support Always On. Please see the sections listed below for more details of SQL FineBuild Always On install processing.

The SQL FineBuild Always On Install process consists of the following:

Item Comment
Always On Planning
SQL FineBuild Always On Overview Overview of the SQL FineBuild Always On Install process
Always On Naming Convention Naming convention for SQL FineBuild Always On items
Listener IP Address Allocation Assignment of IP Addresses to SQL Availability Group Listener
Always On Installation
Always On Install Preparation Preparation required prior to installing a SQL Server Always On
Install First SQL Server Always On Node Install the first node of a SQL Always On Cluster
Install Remaining SQL Server Always On Nodes Install remaining nodes of a SQL Always On Cluster
Always On Operation
Always On Failover Process for performing an Always On failover
Split Brain Scenarios Scenarios that can cause Split Brain and resolution
AlwaysOn Utilities
Function FB_GetAGServers Get table of Primary and Secondary servers
Proc FB_AGFailover Process planned failover of an Availability Group
Proc FB_AGPostFailover Configure DB Synchronisation and Job Schedules following an Availability Group failover
Proc FB_AGSystemData Copy System Data from Primary to Secondary servers
Proc FB_DBRestore Database Restore Procedure
Table FB_AGPostFailoverDBUsers User Mappings to be processed after Failover
Table FB_AGSystemDataJobExceptions Job Exceptions tha tcan be run on a Secondary server

Copyright FineBuild Team © 2019-2020. License and Acknowledgements

Previous SQL Server Cluster Install Top SQL FineBuild Always On Overview Next