-
Notifications
You must be signed in to change notification settings - Fork 10
Proc FB_AGPostFailover
| Proc FB_Failover | FineBuild Parameter Inventory Next |
|---|
The FB_AGPostFailover procedure performs a number of tasks needed following an Availability Group state change.
The tasks included in FB_AGPostFailover are:
SQL FineBuild uses enabling and disabling of SQL Agent Job Schedules to control on which server Jobs are run.
The schedules of all Jobs on the Primary Server are set to Enabled, and the schedules of all jobs on the Secondary Servers are set to Disabled. This work is done using sp_update_jobschedule.
Availability Group synchronisation is checked and if necessary restarted for all databases on Secondary Servers
Authorisation is updated for the Data Quality Databases to reflect the Failover status
Copyright FineBuild Team © 2019. License and Acknowledgements
| Proc FB_Failover | Top | FineBuild Parameter Inventory Next |
|---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP