SQL Server Performance

Restricted/Unrestricted File Growth

Discussion in 'SQL Server 2005 General DBA Questions' started by nupe02, May 6, 2008.

  1. nupe02 New Member

    I've currently have a database set to restricted file growth but I want to change it to Unrestricted File Growth, each time I go into the "Change Autogrowth" of Management Studio and set the radio button to unrestricted file growth (after clicking ok) the database file is still set to restricted file growth. Is this something that has to be done by using Alter Database?
  2. MohammedU New Member

    What value is it changed to? Largest possible size for ldf file is 2TB...

Share This Page