CODEWITHSUNDEEP
sql-server
Pintu Kawar
Pintu Kawar

Reputation: 2156

Transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION

I tried to shrink the log file but it only did small amount of free space.

The log space of tempdb is full due to the data file. How can I free the space?

Edit:

I have checked following: 1. Bad queries are running - NO Queries are running

  1. DBCC OPENTRAN - No Result

  2. The tempdb is in SIMPLE recovery mode.

  3. I have a separate drive for Transaction log of 1TB i.e. 40% free now.

Observation: When I Right click on tempdb>task>shrink>database shows 99% free space available. Can I shrink the database file here?

Upvotes: 6

Views: 19092

Answers (1)

Oliver
Oliver

Reputation: 36413

Restarting the SQL instance will flush the tempdb and recreate it.

Upvotes: 2

Related Questions