by Administrator
21. January 2010 23:53
ALTER DATABASE TempDB MODIFY FILE
(NAME = templog, FILENAME = 't:\templog.ldf')
Just change the logical name of your log file - and the new physical file location
Note that you need to restart SQL Server for this to take effect