I have used the GUI and the CLI to attempt to change SQL Server 2008 log file autogrowth property all to NO avail. In other words, there are NO error messages of any kind, indeed the CLI reports that the command completed successfully. But re-examining the database properties shows that NO change was effected.
For the CLI command, I have used the following with dots filled in for my database and logfile:
ALTER DATABASE ... MODIFY FILE ( NAME = ..., FILEGROWTH = 10%)
Why doesn't this work? How to make it work?
View Complete Post