0

I am wondering it is possible or advisable to change the AutoGrowth settings of a database while it is part of an AlwaysOn SQL Server 2016 database cluster. I realized I used the default settings when I want to use custom growth rates based on the suggestions by Brent Ozar.

File Details

I cant change them in the GUI so I am guessing its not possible but I wanted to check. Will I have to remove the database from the AlwaysOn group, change the growth settings and then add it back in?

1

You have to have AutoGrow enabled and do it on the primary replica. You can also do it in t-sql using the ALTER DATABASE command.

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.