SQL Server Always On Install

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