Transaction Log Full For Tempdb database

Posted: April 1, 2008 in Sqlserver

Identifying and Correcting the Problem for Transaction Log Full w.r.t Tempdb

Error:

From: SQLExec

Sent: Monday, February 13, 2006 5:05 PM

To: #IS CompTech DBA

Subject: SQL Server Alert System: ‘Full log’ occurred on \\HAS644

DATE/TIME: 2/13/2006 5:04:33 PM

DESCRIPTION: Error: 9002, Severity: 17, State: 6

The log file for database ‘tempdb’ is full. Back up the transaction log for the database to free up some log space.

COMMENT: (None)

JOB RUN: (None)

Solution:

  • Check whether for the sufficient Disk Space.
  • When this error is raised, in the Enterprise Manager
    Right click on the Tempdb Database ->click on Properties -> Data Files -> Look for the Space allocated Column (Size)
  • Now, Increase the Size of the datafile or you can also add a new Data file.
  • Do Not try to Shrink “Tempdb” database.
Advertisements

Comments are closed.