Discussion:
The log file for database tempdb is full, backup transaction log to free some space
(too old to reply)
iccsi
2012-04-05 17:00:08 UTC
Permalink
I got "The log file for database tempdb is full, backup transaction
log to free up some space for log space"
error message.

Please help any store procedure or any method to do so,

Your help is great appreciated,

iccsi
Erland Sommarskog
2012-04-05 21:46:07 UTC
Permalink
Post by iccsi
I got "The log file for database tempdb is full, backup transaction
log to free up some space for log space"
error message.
Please help any store procedure or any method to do so,
So if the log for tempdb is full, there is not much point in
backing it up.

But there is reason to review:

1) How big is that log?
2) How much space is there on that disk? (Not much, since you ran out
of space.)
3) Maybe you should put the tempdb elsewhere than on the system disk?
--
Erland Sommarskog, SQL Server MVP, ***@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
Loading...