How to Set Autogrowth for SQL Server Database

You can either change autogrowth of an existing database in SQL Server Management Studio or write T-SQL to modify the same.

To change the autogrowth setting in SQL Server Management Studio:

right click on the database and select the "Properties" menu item
this will open the "Database Properties" dialog
under the "Select a page" section click on the "Files" item in the left pane
this will display the database file information in the right pane
click on the button containing the 3 dots "..." to navigate to the window where auto-growth setting can actually be changed
this will open the "Change Autogrowth" window as illustrated below
In this window you can change the auto-grow settings for your database

Setting autogrowth for SQL Server

This is how FILEGROWTH settings for database "DB1" can be changed via SQL statement:

ALTER DATABASE DB1
MODIFY FILE (NAME=DB1_Log,FILEGROWTH=20MB);

Have any questions? Contact us