Failback configuration wfcm on AlwaysOn group

Question

When an availability group is created trough SSMS, the failover setting in wfcm is "allow failback / immediately"
Automatic failovers to and from an FCI are not allowed in an Always On availability group.
If I create a Role in WFCM the default is "prevent failback".
How can I change the default settings to "prevent failback" while creating the availability group trough TSQL/SSMS?

Answer 1

Hi. Thank you for your question and reaching out. I’d be more than happy to help you with your query

To change the default setting for the failback option while creating an Always On availability group in SSMS, you can use the following steps:

Open SQL Server Management Studio and connect to the SQL Server instance.

In the Object Explorer, expand the Always On High Availability node and right-click on the Availability Groups folder.

Select the "New Availability Group Wizard" option to launch the wizard.

In the "Select Databases" step, select the databases you want to include in the availability group and click "Next".

In the "Specify Replicas" step, add the replicas for the availability group and configure the replica settings as needed.

In the "Listener" step, configure the listener settings for the availability group, if needed, and click "Next".

In the "Data Synchronization" step, configure the data synchronization settings for the availability group and click "Next".

In the "Automatic Failover" step, select the "No" option for the "Allow automatic failover" setting to prevent automatic failovers to the primary replica. You can also select the "No" option for the "Allow automatic failover when data loss may occur" setting, if needed. Click "Next".

In the "Select Initial Data Synchronization" step, choose how you want to perform the initial data synchronization for the availability group and click "Next".

In the "Validation" step, review the settings for the availability group and click "Finish" to create the availability group.

If the reply was helpful, please don’t forget to upvote or accept as answer, thank you.

Answer 2

Double post