Currently my scheduled task(s) failing due to the "out of space" error on the log side.
Have modified the log file in management studio as well as using TSQL in below
and still gets reset back to 2GB max and restricted. The available space on this drive letter is 100 GB.
What could be possibly going on to limit this way?
alter database YourDB
modify file (name='YourDB_log', size=100MB, filegrowth=10%, maxsize=unlimited)