SQL Server Database Log file expansion can be fairly tedious if you need to make the log bigger in many reasonably-sized growth increments. It can be tedious because you may need to write and execute a large number of
ALTER DATABASE ... MODIFY FILE ...commands.
The following code automatically grows a SQL Server Database log file, using the size and growth increments you configure in the script. If you set the
1, the script will only print the commands required, instead of executing them. This allows you to see what exactly will be executed ahead of time. Alternately, you could copy-and-paste the commands into a query window and execute them one-by-one.
Click through for that code.