Can I grow the transaction Log using a script?
My scenario:
I have 3 different scripts that need to run on this particular database, 2 of them only need 4gb of TL space, so I set the transaction log to automatically grow by 4096, which works well, but the other script requires 24Gb, and it spends a lot of time growing the file while executing the script. I want to be able to grow the file to 24Gb before the script executes and then shrink it afterwards.
Thank you,
Ryk