How to disable Automatic Grow features

How to disable Automatic Grow features

Step 1

To disable a filegroup from growing automatically than the allocated size go to Enterprise manager and right click on your database. For this case we will use Demo database.

Then another window will popup as shown below:

Step 2

Uncheck the Automatically Grow File to disable file growing other than the allocated size.