Set Auto growth for all the databases in SQL Server

Spread the love

Introduction

Below script will give the command to execute to change the database auto-growth. If you need to execute for only a single database, then please copy the relevant rows and execute.

SQL Script for database Auto Growth

SQL Script for database Auto Growth

Using GUI

The same result can be obtain by using GUI SSMS also. Set Auto growth for SQL database using GUI

Set Auto growth for SQL database using GUI


Spread the love
Soyeluddin Biswas, SQL Server DBA. Mostly involved in Data center migration. He has rich experience in SQL server design and database migration.

Leave a Reply

Your email address will not be published. Required fields are marked *