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
by Administrator
6. October 2009 20:51
USE DATABASENAME
GO
DBCC SHRINKFILE(LOGNAME, 1)
BACKUP LOG DATABASENAME WITH TRUNCATE_ONLY
DBCC SHRINKFILE(LOGNAME, 1)