We're dedicating new disk space for logs and I need to move tempdb's log only. I've searched this forum and have found entries where both the mdf and ldf are being moved at the same time, but is it possible to move only tempdb's log file to a different drive?
If so, can I do it with
ALTER DATABASE tempdb MODIFY FILE (NAME=templog, FILENAME = 'drive:\templog.ldf') ?
Thanks for your consideration