We are running out of disk space on a d:\ drive on a server and we cant grow it much.
We have another drives on these servers where we have enough space. On the current d:\ drive we have tran. logs and data files. If i shrink current tran. log to 10% and set autogrow off and create another transaction log to the new drive where we have enough space , will this solution work? my concern is since i set autogrow off for 1 tran. log file any long running transaction should not fail.
PS, this database is part of always on