Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
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?
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.
