Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Possible to configure database autogrowth settings at the instance level?

Basically I would like to have all databases in a certain instance have the same autogrow settings. Is it possible to set this at the instance level so that I don't need to go into each database and configure it?

like image 899
Abe Miessler Avatar asked Jan 26 '26 15:01

Abe Miessler


1 Answers

Any user database you create inherits it's base settings from the system model database. Set the size and autogrowth settings in model and each database you create from then on will have the same configuration.

like image 130
Mark Storey-Smith Avatar answered Jan 29 '26 07:01

Mark Storey-Smith