Unable to change the File Growth Option in SQL 2005

• sbvenkatesh77

  Ten Centuries

  Points: 1215

  More actions

  April 13, 2010 at 2:25 pm

  #139665

  Hi,

  We have tried to change the TLog file growth option in SQL 2005 from Restricted to UnRestricted.

  After changing, again we check in GUI, it shows as restricted only.

  I tried to change the option through query analyzer also.

  Is this bug of sql 2005.

  Regards,

  S.Balavenkatesh

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  April 13, 2010 at 2:30 pm

  #1151018

  Two things,

  1. do you have rights for this? Sysadmin or serveradmin rights?

  2. What code did you run?