If you get the error message for Tempdb Transaction log is full.
Msg 9002, Level 17, State 4, Procedure sp_helpdb, Line 19
The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Solution: 1
-- First check Tempdb Tran log file size using dbcc sqlperf(logspace)
-- tempdb 999.9922 99.99628 0
USE MASTER
GO
ALTER DATABASE TEMPDB MODIFY FILE (NAME='templog', SIZE=1500MB)
Solution:2
ALTER DATABASE Tempdb
ADD LOG FILE
( NAME = tempdblog2,
FILENAME = 'E:\MSSQL.1\MSSQL\DATA\tempdblog2.ldf',
SIZE = 10MB,
MAXSIZE = 100MB,
FILEGROWTH = 10MB)
