August 8, 2007 by pinaldave
We can use SSMS to Enable Autogrowth property of the Database.
Right-click on Database click on Properties and click on Files. There will be column of Autogrowth, click on small box with three (…) dots.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Pinalkumar Dave is Microsoft SQL Server MVP, Solid Quality Mentor and a prominent author of over 1000 SQL Server articles at SQLAuthority. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager specializing in SQL Server Programming with over 7 years of hands-on experience. He holds a degree in Masters of Science and has accomplished a number of certifications including MCDBA and MCAD (.NET). He has also been awarded Regional Mentor for PASS Asia.
pinaldave
That’s a usefull info, thanks Dave.
Hi Dave,
Good article. On one of my DB instances, SQL Server always reset this to “Restricted File Growth”. I tried few times to define Unrestricted File Growth, and server always reverts it bac to restricted. Any idea what could be wrong?
Even though I change the autogrowth with method above, its still 1280% in sysfiles like when I do:
select * from sysfiles
I have a problem with the auto growth, for some reason sql 2005 changes the auto growth to grow by either 6400 or 1440 %. i cant disable it because there is more inserting then selecting.
if anyway could could give me a solution it will really be appreciated.
regarads gavin
please mail it to me.
hi dave
how can i set the growth file size ……..?
is it will create any problem during DB transaction??