I have a SQL Server 2k SP4 installed on a Win 2k3 SP2 used for a Blackberry server. The tempdb log file is keep growing at some point been 14 GB. At that point I issued a
backup log tempdb with truncate_only
and shrink the database file without any problem, so there seems to be no long running transaction.
doesn't show anything, the output been
"No active open transactions."
For now I have an hourly job that is running "backup log tempdb with truncate_only", but I would prefer to know what might cause the issue without having to restart the server which indeed might clear the issue. Any idea is highly appreciated.