mahenshi

• Nov 20th, 2007

 

Just restart the server.

jaya

• Nov 23rd, 2007

 

Dump tran with truncate_only if it is not cleared the go for select lct_admin("abort", {process_id [, database_id]})

dychandran

 Profile Answers by dychandran 

• Oct 5th, 2010

 

We may need to identify the Culprit Spid Which is casuing the Tempdb to filled up and confirm about the is that ok to kill it and clear the log.

use dbcc log - Commad to identify the Cuprit Spid.

dbcc log

Purpose: displays transaction log records.