cannot change the growth of distribution database log file

• KATHLEEN Y ZHANG

  Hall of Fame

  Points: 3534

  More actions

  November 19, 2007 at 8:49 am

  #200634

  Hello everyone,

  The log file of our replication distribution database is restricted to 2097152MB, (dont know why and how it was set like this). I tried to change it to 'unrestricted file growth' using 'database properties' UI, it wont take the change. Any ideas?

  Thanks much!

  Kathleen

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736632

  More actions

  November 19, 2007 at 9:21 am

  #752353

  How did you try to change it? SSMS or T-SQL?

  I might try an ALTER DATABASE command and see. Alternatively, can you stop replication and try to shrink the log file, then alter it?