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?
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.