Database Error: Transaction log for tempdb is full

SQL Server uses a “tempdb” for its processing. It can be on the same drive as the data or on a different attached drive.

This probably means you are simply out of disk space where the tempdb is located.

Open SSMS and create a “New Query”. Then enter this select statement (it may give more information):

select log_reuse_wait_desc from sys.databases where name='tempdb'  

The following query will tell you where the files are located and if auto-grow is set to true (growth > 0):

SELECT name, physical_name, size, max_size, growth, is_percent_growth  
FROM sys.master_files  
WHERE database_id = DB_ID('tempdb')

If you have plenty of disk space there, make sure the tempdb log files are set to auto-grow.

The error might also mean that there is an active transaction preventing the log from clearing.

Execute this command in a Query window:

DBCC OPENTRAN  

If that says there is an open transaction, you can clear it by restarting SQL Server.