Sql-server – Changing Auto-Growth Setting in AOAG for log file

auto-growthsql serversql server 2014transaction-log

We are on AOAG SQL Server 2014.

I am planning to change Auto-Growth setting from % –> MBs for log file.

Do I need to change the setting in all Replicas or only Primary Replica?

Best Answer

Set it on Primary replica only and it gets applied to all secondaries.

You can test it out on a small db .. add it to availability group and change the autogrowth setting.