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?


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.